class Table21(DeclarativeBase, ApiModule): """ test 21 table """ __tablename__ = 'table21' __serialization__ = get_serialization( AttributeConfiguration(name='id', supports_json=(False, True)), AttributeConfiguration(name='name', supports_json=True), AttributeConfiguration(name='table11_id', supports_json=(True, False)), AttributeConfiguration(name='table11nams', supports_json=(False, True)), AttributeConfiguration(name='table12_id', supports_json=(True, False)), AttributeConfiguration(name='table12nams', supports_json=(False, True)), ) id = Column(Integer, primary_key=True) name = Column(Unicode(256), nullable=False, unique=True) table11_id = Column(Integer, ForeignKey('table11.id')) Table11 = get_table_cls(ApiModule, 'table11') Table11.__serialization__.append( AttributeConfiguration(name='table21s', supports_json=(False, True)), ) Table11.table21s = relationship('Table21') table11nams = column_property(select([(Table11.name)], table11_id == Table11.id)) table12_id = Column(Integer, ForeignKey('table12.id')) Table12 = get_table_cls(ApiModule, 'table12') Table12.__serialization__.append( AttributeConfiguration(name='table21s', supports_json=(False, True)), ) Table12.table21s = relationship('Table21') table12nams = column_property(select([(Table12.name)], table12_id == Table12.id))
class Groups(DeclarativeBase): __tablename__ = 'groups' __serialization__ = [ AttributeConfiguration(name='id', supports_json=(False, True)), AttributeConfiguration(name='name', supports_json=True), AttributeConfiguration(name='users', supports_json=(False, True)), AttributeConfiguration(name='modules', supports_json=(False, True)), ] id = Column(Integer, primary_key=True) name = Column(Unicode(256), nullable=False, unique=True) users = relationship('Users', cascade='all, delete-orphan') modules = relationship('ModulesPermissions', cascade='all, delete-orphan')
class User(Base): __tablename__ = 'users' id = Column( Integer, Sequence('user_id_seq'), primary_key=True, supports_dict=True, ) name = Column( String, supports_dict=True, ) addresses = relationship( "Address", backref="user", lazy="joined", supports_dict=True, on_serialize=serialize_address, ) def __repr__(self): return "<User(id='{0:s}', name='{1:s}')>".format( str(self.id), self.name, )
class User_OneToOne_Nested(BaseModel): """Mocked class with a single primary key.""" __tablename__ = 'users_one_to_one' __serialization__ = [ AttributeConfiguration(name='id', supports_csv=True, csv_sequence=1, supports_json=True, supports_yaml=True, supports_dict=True), AttributeConfiguration(name='name', supports_csv=True, csv_sequence=2, supports_json=True, supports_yaml=True, supports_dict=True, on_serialize=None, on_deserialize=None), AttributeConfiguration(name='address', supports_json=True, supports_yaml=(True, True), supports_dict=(True, True)), ] id = Column('id', Integer, primary_key=True) name = Column('username', String(50)) address = relationship('Address_Nested_OneToOne', backref='user', uselist=False)
class User(BaseModel): """Mocked class with a single primary key.""" __tablename__ = 'users' id = Column('id', Integer, primary_key=True) name = Column('username', String(50)) addresses = relationship('Address', backref='user') _hybrid = 1 @hybrid_property def hybrid(self): return self._hybrid @hybrid.setter def hybrid(self, value): self._hybrid = value @hybrid_property def hybrid_differentiated(self): return self._hybrid @hybrid_differentiated.setter def hybrid_differentiated(self, value): self._hybrid = value keywords_basic = association_proxy('keywords_basic', 'keyword')
class User2(BaseModel): """Mocked class with a single primary key.""" __tablename__ = 'users_composite' id = Column('id', Integer, primary_key = True) id2 = Column('id2', Integer, primary_key = True) id3 = Column('id3', Integer, primary_key = True) name = Column('username', String(50)) addresses = relationship('Address2', backref = 'user') _hybrid = 1 @hybrid_property def hybrid(self): return self._hybrid @hybrid_property def hybrid_differentiated(self): return self._hybrid
class Groups(DeclarativeBase, ApiModule): """ Ресурс групп """ __tablename__ = 'groups' __serialization__ = get_serialization( AttributeConfiguration(name='name', supports_json=True), AttributeConfiguration(name='users', supports_json=(False, True)), AttributeConfiguration(name='modules', supports_json=(False, True)), ) name = Column(Unicode(256), nullable=False, unique=True) users = relationship('Users', cascade='all, delete-orphan') modules = relationship('ModulesPermissions', cascade='all, delete-orphan')
class Users(DeclarativeBase): """ user """ __tablename__ = 'users' __serialization__ = [ AttributeConfiguration(name='id', supports_json=True), AttributeConfiguration(name='name', supports_json=True), AttributeConfiguration(name='key', supports_json=(True, False)), AttributeConfiguration(name='group_id', supports_json=(True, False)), #AttributeConfiguration(name='group', supports_json=(False, True)), AttributeConfiguration(name='group_name', supports_json=(False, True)), ] id = Column( Integer, primary_key=True, ) name = Column( Unicode(256), nullable=False, unique=True, ) key = Column(Unicode(512), ) group_id = Column( Integer, ForeignKey('groups.id'), nullable=False, ) group = relationship( 'Groups', back_populates='users', )
class User_Complex(BaseModel): """Mocked class with a single primary key with varied serialization support.""" __tablename__ = 'users_complex' id = Column('id', Integer, primary_key = True, supports_csv = True, csv_sequence = 1, supports_json = True, supports_yaml = True, supports_dict = True) name = Column('username', String(50), supports_csv = True, csv_sequence = 2, supports_json = True, supports_yaml = True, supports_dict = True) password = Column('password', String(50), supports_csv = (True, False), csv_sequence = 3, supports_json = (True, False), supports_yaml = (True, False), supports_dict = (True, False)) hidden = Column('hidden_column', String(50)) addresses = relationship('Address_Complex', backref = 'user', supports_json = True, supports_yaml = (True, True), supports_dict = (True, False)) _hybrid = 1 @hybrid_property def hybrid(self): return self._hybrid @hybrid.setter def hybrid(self, value): self._hybrid = value @hybrid_property def hybrid_differentiated(self): return self._hybrid @hybrid_differentiated.setter def hybrid_differentiated(self, value): self._hybrid = value keywords_basic = association_proxy('keywords_basic', 'keyword')
class User(Base): __tablename__ = 'users' id = Column(Integer, Sequence('user_id_seq'), primary_key=True) addresses = relationship("Address", backref="user", lazy="joined", supports_json=True, display_name="all-addresses")
class UserKeyword_Complex(BaseModel): __tablename__ = 'user_keywords_complex' user_id = Column('user_id', Integer, ForeignKey('users_complex.id'), primary_key=True) keyword_id = Column('keyword_id', Integer, ForeignKey('keywords.id'), primary_key=True) special_key = Column('special_key', String(50)) user = relationship(User_Complex, backref=backref('keywords_basic', cascade='all, delete-orphan')) keyword = relationship('Keyword') def __init__(self, keyword=None, user=None, special_key=None): self.user = user self.keyword = keyword self.special_key = special_key
class Geoms(DeclarativeBase, ApiModule): """ Resource Reference of Geoms """ __tablename__ = 'geoms' __serialization__ = get_serialization( AttributeConfiguration(name='name', supports_json=True), AttributeConfiguration(name='properties', supports_json=True), AttributeConfiguration(name='layers', supports_json=(False, True)), ) name = Column(Unicode(256), nullable=False, unique=True) properties = Column(JsonType()) layers = relationship('Layers', cascade='all, delete-orphan')
class Modules(DeclarativeBase, ApiModule): __tablename__ = 'modules' __serialization__ = [ AttributeConfiguration(name='id', supports_json=(False, True)), AttributeConfiguration(name='name', supports_json=(False, True)), AttributeConfiguration(name='access', supports_json=(False, True)), AttributeConfiguration(name='enable', supports_json=True), AttributeConfiguration(name='groups', supports_json=(False, True)), ] id = Column(Integer, primary_key=True) name = Column(Unicode(256), nullable=False, unique=True) access = Column(Boolean, default=False) enable = Column(Boolean, default=True) groups = relationship('ModulesPermissions', cascade='all, delete-orphan')
class Modules(DeclarativeBase, ApiModule): __tablename__ = 'modules' __http__ = ['GET', 'PUT'] __serialization__ = get_serialization( AttributeConfiguration(name='name', supports_json=(False, True)), AttributeConfiguration(name='access', supports_json=(False, True)), AttributeConfiguration(name='enable', supports_json=True), AttributeConfiguration(name='delete', supports_json=True), AttributeConfiguration(name='groups', supports_json=(False, True)), ) name = Column(Unicode(256), nullable=False, unique=True) access = Column(Boolean, default=False) enable = Column(Boolean, default=True) delete = Column(Boolean, default=False) groups = relationship('ModulesPermissions', cascade='all, delete-orphan')
class Users(DeclarativeBase, ApiModule): """ Resource Users """ __tablename__ = 'users' __serialization__ = get_serialization( AttributeConfiguration(name='name', supports_json=True), AttributeConfiguration(name='auth_name', supports_json=True), AttributeConfiguration(name='full_name', supports_json=True), AttributeConfiguration(name='auto_create', supports_json=True), AttributeConfiguration(name='groups', supports_json=(False, True)), ) name = Column(Unicode(256), nullable=False, unique=True) auth_name = Column(Unicode(256), unique=True) full_name = Column(Unicode(1024)) auto_create = Column(Boolean(), default=False) groups = relationship('UsersGroups', cascade='all, delete-orphan')
class Groups(DeclarativeBase): """ group """ __tablename__ = 'groups' id = Column( Integer, primary_key=True, supports_json=True, ) name = Column( Unicode(256), nullable=False, unique=True, supports_json=True, ) users = relationship( 'Users', back_populates='group', #backref='group', supports_json=True, )
class User_Complex_PostgreSQL(BaseModel): """Mocked class with a single primary key.""" __tablename__ = 'users_complex_postgresql' __serialization__ = [ AttributeConfiguration(name='id', supports_csv=True, csv_sequence=1, supports_json=True, supports_yaml=True, supports_dict=True), AttributeConfiguration(name='name', supports_csv=True, csv_sequence=2, supports_json=True, supports_yaml=True, supports_dict=True, on_serialize=return_serialized, on_deserialize=return_deserialized), AttributeConfiguration(name='addresses', supports_json=True, supports_yaml=(True, True), supports_dict=(True, False)), AttributeConfiguration(name='hybrid', supports_csv=True, supports_json=True, supports_yaml=True, supports_dict=True, display_name='hybrid_value'), AttributeConfiguration(name='password', supports_csv=(True, False), csv_sequence=3, supports_json=(True, False), supports_yaml=(True, False), supports_dict=(True, False)), AttributeConfiguration(name='time_delta', supports_csv=True, supports_json=False, supports_yaml=False, supports_dict=False) ] id = Column('id', Integer, primary_key=True) name = Column('username', String(50)) addresses = relationship('Address_Complex_PostgreSQL', backref='user') password = Column('password', String(50)) hidden = Column('hidden_column', String(50)) smallint_column = Column('smallint_column', sqlite.SMALLINT, supports_csv=True, csv_sequence=4) _hybrid = 1 time_delta = Column('time_delta', Interval) @hybrid_property def hybrid(self): return self._hybrid @hybrid.setter def hybrid(self, value): self._hybrid = value @hybrid_property def hybrid_differentiated(self): return self._hybrid @hybrid_differentiated.setter def hybrid_differentiated(self, value): self._hybrid = value keywords_basic = association_proxy('keywords_basic', 'keyword')