Revision 2377
Added by Aaron Marcuse-Kubitza over 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