Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>The advantage of the inline <code>if</code> expression is that it's an expression, which means you can use it inside other expressions—list comprehensions, lambda functions, etc. </p> <p>The disadvantage of the inline <code>if</code> expression is <em>also</em> that it's an expression, which means you can't use any statements inside of it.</p> <hr> <p>A perfect example of the disadvantage is exactly what's causing your error: <code>a = a/w</code> is a statement, so you can't use it inside an expression. You have to write this:</p> <pre><code>if b == 2: a = a*2 else: a = a/w </code></pre> <p>Except that in this particular case, you just want to assign something to <code>a</code> in either case, so you can just write this:</p> <pre><code>a = a*2 if b==2 else a/w </code></pre> <p>As for the advantage, consider this:</p> <pre><code>odd_numbers = [number if number%2 else number+1 for number in numbers] </code></pre> <p>Without the <code>if</code> expression, you'd have to wrap the conditional in a named function—which is a good thing for non-trivial cases, but overly verbose here:</p> <pre><code>def oddify(number): if number%2: return number else: return number+1 odd_numbers = [oddify(number) for number in numbers] </code></pre> <p>Also, note that the following example is <em>not</em> using an <code>if</code> (ternary conditional) expression, but an <code>if</code> (conditional filter) clause:</p> <pre><code>odd_numbers = [number for number in numbers if number % 2] </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POIf and Inline if, what are the advantages and disadvantages?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USabarnert
    1. USabarnert
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POIf and Inline if, what are the advantages and disadvantages?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COIt's worth noting that the ternary operator can be used inside a list comprehension, but the keyword `if` can also be used in a list comp for filtering. They are different things, so it's worth making the distinction between an `if` statement and the ternary operator. E.g: `["Something" if item > 10 else "SomethingElse" for item in data if item > 5]` - the first use of `if` is the ternary operator, the second is filtering in the list comp.
      singulars
      1. PO
      1. USGareth Latty
    2. CO@Lattyware: True. I'll edit it to make that clearer. Thanks.
      singulars
      1. PO
      1. USabarnert
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload