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)
