Revision 7394
Added by Aaron Marcuse-Kubitza almost 12 years ago
lib/sql_io.py | ||
---|---|---|
342 | 342 |
'''Recovers from errors. |
343 | 343 |
Only works under PostgreSQL (uses INSERT RETURNING). |
344 | 344 |
|
345 |
Warning: This function's insert/if not exists get algorithm does not support
|
|
346 |
database triggers that populate fields covered by a unique constraint. Such
|
|
347 |
fields must be populated by the mappings instead. (Other fields are not
|
|
348 |
affected by this restriction on triggers.) |
|
345 |
Warning: This function's insert/on duplicate select algorithm does not
|
|
346 |
support database triggers that populate fields covered by a unique
|
|
347 |
constraint. Such fields must be populated by the mappings instead.
|
|
348 |
(Other fields are not affected by this restriction on triggers.)
|
|
349 | 349 |
@param in_tables The main input table to select from, followed by a list of |
350 | 350 |
tables to join with it using the main input table's pkey |
351 | 351 |
@param mapping dict(out_table_col=in_table_col, ...) |
Also available in: Unified diff
sql_io.py: put_table(): Corrected "insert/if not exists get" to "insert/on duplicate select"