Beispiel #1
0
 def check_tables(schema, provider, connection):
     cursor = connection.cursor()
     split = provider.split_table_name
     for table in sorted(itervalues(schema.tables), key=lambda table: split(table.name)):
         alias = provider.base_name(table.name)
         sql_ast = [ 'SELECT',
                     [ 'ALL', ] + [ [ 'COLUMN', alias, column.name ] for column in table.column_list ],
                     [ 'FROM', [ alias, 'TABLE', table.name ] ],
                     [ 'WHERE', [ 'EQ', [ 'VALUE', 0 ], [ 'VALUE', 1 ] ] ]
                   ]
         sql, adapter = provider.ast2sql(sql_ast)
         if core.local.debug: log_sql(sql)
         provider.execute(cursor, sql)
Beispiel #2
0
 def check_tables(schema, provider, connection):
     cursor = connection.cursor()
     for table in sorted(itervalues(schema.tables), key=lambda table: table.name):
         if isinstance(table.name, tuple): alias = table.name[-1]
         elif isinstance(table.name, basestring): alias = table.name
         else: assert False  # pragma: no cover
         sql_ast = [ 'SELECT',
                     [ 'ALL', ] + [ [ 'COLUMN', alias, column.name ] for column in table.column_list ],
                     [ 'FROM', [ alias, 'TABLE', table.name ] ],
                     [ 'WHERE', [ 'EQ', [ 'VALUE', 0 ], [ 'VALUE', 1 ] ] ]
                   ]
         sql, adapter = provider.ast2sql(sql_ast)
         if core.debug: log_sql(sql)
         provider.execute(cursor, sql)
 def check_tables(schema, provider, connection):
     cursor = connection.cursor()
     for table in sorted(itervalues(schema.tables), key=lambda table: table.name):
         if isinstance(table.name, tuple): alias = table.name[-1]
         elif isinstance(table.name, basestring): alias = table.name
         else: assert False  # pragma: no cover
         sql_ast = [ 'SELECT',
                     [ 'ALL', ] + [ [ 'COLUMN', alias, column.name ] for column in table.column_list ],
                     [ 'FROM', [ alias, 'TABLE', table.name ] ],
                     [ 'WHERE', [ 'EQ', [ 'VALUE', 0 ], [ 'VALUE', 1 ] ] ]
                   ]
         sql, adapter = provider.ast2sql(sql_ast)
         if core.debug: log_sql(sql)
         provider.execute(cursor, sql)
Beispiel #4
0
 def create(table, provider, connection, created_tables=None):
     commands = table.get_create_commands(created_tables)
     for i, sql in enumerate(commands):
         if core.debug: log_sql(sql)
         cursor = connection.cursor()
         try: provider.execute(cursor, sql)
         except DatabaseError, e:
             if e.exceptions[0].args[0].code == 955:
                 if core.debug: log_orm('ALREADY EXISTS: %s' % e.args[0].message)
                 if not i:
                     if len(commands) > 1:
                         log_orm('SKIP FURTHER DDL COMMANDS FOR TABLE %s\n' % table.name)
                     return
             else: raise
Beispiel #5
0
 def create(table, provider, connection):
     sql = table.get_create_command()
     if core.local.debug: log_sql(sql)
     cursor = connection.cursor()
     provider.execute(cursor, sql)
Beispiel #6
0
 def create(table, provider, connection):
     sql = table.get_create_command()
     if core.debug: log_sql(sql)
     cursor = connection.cursor()
     provider.execute(cursor, sql)
Beispiel #7
0
 def create(table, provider, connection, created_tables=None):
     commands = table.get_create_commands(created_tables)
     for sql in commands:
         if core.debug: log_sql(sql)
         cursor = connection.cursor()
         provider.execute(cursor, sql)
Beispiel #8
0
async def _create(self, provider, connection):
    sql = self.get_create_command()
    if core.debug: log_sql(sql)
    cursor = await connection.cursor()
    await provider.execute(cursor, sql)