Revision 2377
Added by Aaron Marcuse-Kubitza about 12 years ago
| lib/sql.py | ||
|---|---|---|
| 424 | 424 |
@param tables The single table to select from, or a list of tables to join |
| 425 | 425 |
together, with tables after the first being sql_gen.Join objects |
| 426 | 426 |
@param fields Use None to select all fields in the table |
| 427 |
@param conds WHERE conditions: dict(compare_left_side=compare_right_side):
|
|
| 427 |
@param conds WHERE conditions: [(compare_left_side, compare_right_side),...]
|
|
| 428 | 428 |
* compare_left_side: Code|str (for col name) |
| 429 | 429 |
* compare_right_side: ValueCond|literal value |
| 430 | 430 |
@param distinct_on The columns to SELECT DISTINCT ON, or distinct_on_all to |
Also available in: Unified diff
sql.py: mk_select(): conds is list of (key, value) tuples instead of dict (dict still supported for compatibility), so that there can be multiple conditions on the same column