Revision 10165
Added by Aaron Marcuse-Kubitza over 11 years ago
lib/sql_io.py | ||
---|---|---|
358 | 358 |
insert/on duplicate select. This operation is a cross between MySQL's |
359 | 359 |
INSERT ON DUPLICATE KEY UPDATE (which does not provide SELECT |
360 | 360 |
functionality), and PostgreSQL's INSERT RETURNING (which throws an error |
361 |
instead of returning the existing row). |
|
361 |
on duplicate instead of returning the existing row). |
|
362 |
|
|
362 | 363 |
@param in_tables The main input table to select from, followed by a list of |
363 | 364 |
tables to join with it using the main input table's pkey |
364 | 365 |
@param mapping dict(out_table_col=in_table_col, ...) |
Also available in: Unified diff
lib/sql_io.py: put_table() (column-based import): complexity note: clarified that INSERT RETURNING throws an error on duplicate instead of returning the existing row. added blank line after ΒΆ for readability.