class SomeClass1(TableModel):
__tablename__ = "%s_%d" % (fn, 1)
_type_info = [
('i', Integer32(pk=True)),
('a', Array(SomeClass, store_as='json')),
]
class SomeTableSubset(TableModel):
__table__ = SomeTable.__table__
id = Integer32(pk=True) # sqla session doesn't work without pk
i = Integer32
class SomeOtherClass(TableModel):
__tablename__ = 'some_other_class'
__table_args__ = {"sqlite_autoincrement": True}
id = Integer32(primary_key=True)
s = Unicode(64)
class SomeClass(TableModel):
__tablename__ = 'some_class'
id = Integer32(primary_key=True)
values = Array(Unicode).store_as('table')
class SomeClass(TableModel):
__tablename__ = 'some_class'
id = Integer32(primary_key=True)
children = Array(SomeChildClass).store_as('xml')
mirror = SomeChildClass.store_as('json')
class D(TableModel):
__tablename__ = "d"
id = Integer32(pk=True)
c = Array(C).store_as('table')
class SomeClass(TableModel):
__tablename__ = 'some_class'
__table_args__ = {"sqlite_autoincrement": True}
id = Integer32(primary_key=True)
others = Array(SomeOtherClass, store_as='json')
class SomeClass(TableModel):
__tablename__ = 'some_class'
id = Integer32(primary_key=True)
child_id = Integer32(fk='some_child_class.id')
class SomeClass2(TableModel):
__tablename__ = "%s_%d" % (fn, 2)
i = Integer32(pk=True)
a = Any(store_as='jsonb')
class SomeClass1(TableModel):
__tablename__ = "%s_%d" % (fn, 1)
i = Integer32(pk=True)
b = Boolean
class SomeClass2(TableModel):
__tablename__ = "%s_%d" % (fn, 2)
i = Integer32(pk=True)
b = Boolean(store_as=int)
class SomeClass1(TableModel):
__tablename__ = "%s_%d" % (fn, 1)
i = Integer32(pk=True)
e = Unicode(32)
class SomeClass(TableModel):
__tablename__ = 'some_class'
__table_args__ = {"sqlite_autoincrement": True}
id = Integer32(primary_key=True, autoincrement=False)
s = Unicode(64, sqla_column_args=dict(name='ss'))
class SomeClass2(TableModel):
__tablename__ = "%s_%d" % (fn, 2)
i = Integer32(pk=True)
a = SomeClass.customize(store_as='json')
class D(TableModel):
__tablename__ = "dd"
id = Integer32(pk=True)
c = Array(C).customize(store_as=table(right='dd_id'))
class D(TableModel):
__tablename__ = 'd'
id = Integer32(pk=True)
i = M(Integer32)
class D(TableModel):
__tablename__ = "d"
id = Integer32(pk=True)
class Foo(TableModel):
__tablename__ = 'foo'
__table_args__ = {"sqlite_autoincrement": True}
id = Integer32(primary_key=True)
s = Unicode(64)
class C(TableModel):
__tablename__ = "c"
id = Integer32(pk=True)
class SomeClass1(TableModel):
__tablename__ = 'test_bool_1'
i = Integer32(pk=True)
b = Boolean
class SomeClass(TableModel):
__tablename__ = 'some_class'
__table_args__ = {"sqlite_autoincrement": True}
i = XmlAttribute(Integer32(pk=True))
s = XmlData(Unicode(64))
class SomeClass2(TableModel):
__tablename__ = 'test_bool_2'
i = Integer32(pk=True)
b = Boolean(store_as=int)
class SomeChildClass(TableModel):
__tablename__ = 'some_child_class'
id = Integer32(primary_key=True)
s = Unicode(64)
i = Integer32
class SomeClass(TableModel):
__tablename__ = 'some_class'
__table_args__ = {"sqlite_autoincrement": True}
id = Integer32(primary_key=True)
f = Unicode(32, db_default=u'uuu')
class SomeTable(TableModel):
__tablename__ = 'some_table'
id = Integer32(pk=True)
i = Integer32
s = Unicode(32)
class C(TableModel):
__tablename__ = "c"
id = Integer32(pk=True)
f = File(store_as=HybridFileStore('test_file_storage', 'json'))
class SomeClass(TableModel):
__tablename__ = table_name
id = Integer32(primary_key=True)
e = Enum(*enums, type_name='status_choices')
class D(TableModel):
__tablename__ = "d"
id = Integer32(pk=True)
c = C.store_as('table')
c_id = Integer32(15)
class SomeClass(TableModel):
__tablename__ = 'some_class'
__table_args__ = ({"sqlite_autoincrement": True}, )
id = Integer32(primary_key=True)
o = SomeOtherClass.customize(store_as='table')
class SomeClass3(TableModel):
__tablename__ = "%s_%d" % (fn, 3)
i = Integer32(pk=True)
a = File(store_as=HybridFileStore("path", db_format='jsonb'))
