def _named_fk_fixture(self, table_args=(), table_kwargs={}): m = MetaData() t = Table( 'tname', m, Column('id', Integer, primary_key=True), Column('email', String()), Column('user_id', Integer, ForeignKey('user.id', name='ufk'))) return ApplyBatchImpl(t, table_args, table_kwargs)
def _server_default_fixture(self, table_args=(), table_kwargs={}): m = MetaData() t = Table( 'tname', m, Column('id', Integer, primary_key=True), Column('thing', String(), server_default='') ) return ApplyBatchImpl(t, table_args, table_kwargs)
def _enum_fixture(self, table_args=(), table_kwargs={}): m = MetaData() t = Table( 'tname', m, Column('id', Integer, primary_key=True), Column('thing', Enum('a', 'b', 'c')) ) return ApplyBatchImpl(t, table_args, table_kwargs)
def _boolean_no_ck_fixture(self, table_args=(), table_kwargs={}): m = MetaData() t = Table( 'tname', m, Column('id', Integer, primary_key=True), Column('flag', Boolean(create_constraint=False)) ) return ApplyBatchImpl(t, table_args, table_kwargs)
def _boolean_fixture(self, table_args=(), table_kwargs={}): m = MetaData() t = Table( 'tname', m, Column('id', Integer, primary_key=True), Column('flag', Boolean) ) return ApplyBatchImpl(t, table_args, table_kwargs)
def _sql_ck_fixture(self, table_args=(), table_kwargs={}): m = MetaData() t = Table( 'tname', m, Column('id', Integer, primary_key=True), Column('email', String()) ) t.append_constraint(CheckConstraint(t.c.email.like('%@%'))) return ApplyBatchImpl(t, table_args, table_kwargs)
def _simple_fixture(self, table_args=(), table_kwargs={}): m = MetaData() t = Table( 'tname', m, Column('id', Integer, primary_key=True), Column('x', String(10)), Column('y', Integer) ) return ApplyBatchImpl(t, table_args, table_kwargs)
def _selfref_fk_fixture(self, table_args=(), table_kwargs={}): m = MetaData() t = Table( 'tname', m, Column('id', Integer, primary_key=True), Column('parent_id', Integer, ForeignKey('tname.id')), Column('data', String) ) return ApplyBatchImpl(t, table_args, table_kwargs)
def _uq_fixture(self, table_args=(), table_kwargs={}): m = MetaData() t = Table( 'tname', m, Column('id', Integer, primary_key=True), Column('x', String()), Column('y', Integer), UniqueConstraint('y', name='uq1') ) return ApplyBatchImpl(t, table_args, table_kwargs)
def _ix_fixture(self, table_args=(), table_kwargs={}): m = MetaData() t = Table( 'tname', m, Column('id', Integer, primary_key=True), Column('x', String()), Column('y', Integer), Index('ix1', 'y') ) return ApplyBatchImpl(t, table_args, table_kwargs, False)
def _literal_ck_fixture(self, copy_from=None, table_args=(), table_kwargs={}): m = MetaData() if copy_from is not None: t = copy_from else: t = Table('tname', m, Column('id', Integer, primary_key=True), Column('email', String()), CheckConstraint("email LIKE '%@%'")) return ApplyBatchImpl(t, table_args, table_kwargs)
def _multi_fk_fixture(self, table_args=(), table_kwargs={}, schema=None): m = MetaData() if schema: schemaarg = "%s." % schema else: schemaarg = "" t = Table( 'tname', m, Column('id', Integer, primary_key=True), Column('email', String()), Column('user_id_1', Integer, ForeignKey('%suser.id' % schemaarg)), Column('user_id_2', Integer, ForeignKey('%suser.id' % schemaarg)), Column('user_id_3', Integer), Column('user_id_version', Integer), ForeignKeyConstraint( ['user_id_3', 'user_id_version'], ['%suser.id' % schemaarg, '%suser.id_version' % schemaarg]), schema=schema ) return ApplyBatchImpl(t, table_args, table_kwargs)