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)