class TestFK2:
__db_schema__ = 'test_db_schema'
integer = Int(primary_key=True)
other = Int(
foreign_key=Model.TestFKTarget.use('integer').options(
ondelete='cascade'))
class TestCheck:
integer = Int(primary_key=True)
@classmethod
def define_table_args(cls):
table_args = super(TestCheck, cls).define_table_args()
return table_args + (CheckConstraint('integer > 0',
name='test'), )
class TestM2M2:
idmodel2 = Int(primary_key=True)
rel_m2m = Many2Many(label="Rel",
model=Model.TestM2M1,
join_table='reltable',
remote_columns='idmodel1',
m2m_remote_columns='idmodel1',
local_columns='idmodel2',
m2m_local_columns='idmodel2',
many2many='rel_m2m_inv')
class TestCheckLongConstraintName:
integer = Int(primary_key=True)
@classmethod
def define_table_args(cls):
table_args = super(TestCheckLongConstraintName,
cls).define_table_args()
return table_args + (CheckConstraint(
'integer > 0',
name=('long_long_long_long_long_long_long_long_long_long_'
'long_long_long_long_long_long_long_long_test')), )
class TestFK:
integer = Int(primary_key=True)
other = Int(foreign_key=Model.TestFKTarget.use('integer'))
class TestFKTarget:
integer = Int(primary_key=True)
class TestIndex:
integer = Int(primary_key=True)
other = Str(index=True)
class TestUnique:
integer = Int(primary_key=True)
other = Str(unique=True)
class Test:
integer = Int(primary_key=True)
other = Str()
class TestM2M1:
idmodel1 = Int(primary_key=True)
class TestFK:
__db_schema__ = 'test_db_schema'
integer = Int(primary_key=True)
other = Int(foreign_key=Model.TestFKTarget.use('integer'))
class TestFKTarget:
__db_schema__ = 'test_db_schema'
integer = Int(primary_key=True)
class TestIndex:
__db_schema__ = 'test_db_schema'
integer = Int(primary_key=True)
other = Str(index=True)
class TestUnique:
__db_schema__ = 'test_db_schema'
integer = Int(primary_key=True)
other = Str(unique=True)
