/lib/sql.py - Diff - BIEN 3 - NCEAS Projects

« Previous | Next »

Revision 3092

sql.py: mk_insert_select(): ignore mode: Support inserting all columns when cols == None

         lang = 'sql'
         if ignore:
             assert cols != None
             # Always return something to set the correct rowcount
             if returning == None: returning = sql_gen.NamedCol('NULL', None)
             embeddable = True # must use function
             lang = 'plpgsql'
             row = [sql_gen.Col(c.name, 'row') for c in cols]
             if cols == None:
                 row = [sql_gen.Col(sql_gen.all_cols, 'row')]
                 row_vars = [sql_gen.Table('row')]
             else:
                 row_vars = row = [sql_gen.Col(c.name, 'row') for c in cols]
             query = '''\
     DECLARE
         row '''+table.to_str(db)+'''%ROWTYPE;
-...
         (http://www.postgresql.org/docs/8.3/static/plpgsql-control-structures.html\
     #PLPGSQL-ERROR-TRAPPING)
         */
         FOR '''+(', '.join((c.to_str(db) for c in row)))+''' IN
         FOR '''+(', '.join((v.to_str(db) for v in row_vars)))+''' IN
     '''+select_query+'''
         LOOP
             BEGIN

Also available in: Unified diff