Revision 3298
Added by Aaron Marcuse-Kubitza over 12 years ago
sql_io.py | ||
---|---|---|
91 | 91 |
-- Insert the value and error for *each* source column. |
92 | 92 |
FOR "column" IN |
93 | 93 |
'''+sql.mk_select(db, sql_gen.NamedValues('c', None, [[c.name] for c in srcs]), |
94 |
order_by=None, start=0)+'''
|
|
94 |
order_by=None)+''' |
|
95 | 95 |
LOOP |
96 | 96 |
BEGIN |
97 | 97 |
'''+sql.mk_insert_select(db, errors_table, errors_table_cols, |
... | ... | |
276 | 276 |
# Place in new table for speed and so don't modify input if values edited |
277 | 277 |
in_table = sql_gen.Table('in') |
278 | 278 |
mapping = dicts.join(mapping, sql.flatten(db, in_table, input_joins, |
279 |
in_cols, preserve=[in_pkey_col], start=0))
|
|
279 |
in_cols, preserve=[in_pkey_col])) |
|
280 | 280 |
input_joins = [in_table] |
281 | 281 |
db.log_debug('Temp table: '+strings.as_tt(in_table.to_str(db)), level=2) |
282 | 282 |
|
... | ... | |
299 | 299 |
full_in_table_cols.append(default) |
300 | 300 |
default = sql_gen.with_table(default, full_in_table) |
301 | 301 |
sql.run_query_into(db, sql.mk_select(db, in_table, full_in_table_cols, |
302 |
order_by=None, start=0), into=full_in_table)
|
|
302 |
order_by=None), into=full_in_table) |
|
303 | 303 |
sql.add_pkey(db, full_in_table) |
304 | 304 |
|
305 | 305 |
pkeys_names = [in_pkey, out_pkey] |
... | ... | |
310 | 310 |
distinct_on = [] |
311 | 311 |
if distinct: distinct_on=[in_pkey_col] |
312 | 312 |
query = sql.mk_select(db, joins, cols, distinct_on=distinct_on, |
313 |
order_by=None, start=0)
|
|
313 |
order_by=None) |
|
314 | 314 |
|
315 | 315 |
if pkeys_table_exists_ref[0]: |
316 | 316 |
sql.insert_select(db, into, pkeys_names, query, **kw_args) |
... | ... | |
326 | 326 |
def mk_main_select(joins, cols): |
327 | 327 |
conds_ = [(sql_gen.with_table(k, insert_in_table), v) for k, v in conds] |
328 | 328 |
return sql.mk_select(db, joins, cols, conds_, limit=limit_ref[0], |
329 |
order_by=None, start=0)
|
|
329 |
order_by=None) |
|
330 | 330 |
|
331 | 331 |
exc_strs = set() |
332 | 332 |
def log_exc(e): |
Also available in: Unified diff
sql.mk_select() calls: Removed no longer needed start=0 to turn off missing WHERE, LIMIT, or OFFSET clause warning