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)
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 _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 _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 _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)