MambuPy.orm.schema_groups
Schema tables for Mambu Groups.
Todo
this are just very basic schemas for groups. A some fields are missing.
Classes
|
Group table. |
|
GroupRoleName table. |
- class MambuPy.orm.schema_groups.Group(**kwargs)[source]
Bases:
Base
Group table.
- __init__(**kwargs)
A simple constructor that allows initialization from kwargs.
Sets attributes on the constructed instance using the names and values in
kwargs
.Only keys that are present as attributes of the instance’s class are allowed. These could be, for example, any mapped columns or relationships.
- __mapper__ = <Mapper at 0x7f396deca160; Group>
- __module__ = 'MambuPy.orm.schema_groups'
- __table__ = Table('group', MetaData(bind=None), Column('encodedKey', String(), table=<group>, primary_key=True, nullable=False), Column('id', String(), table=<group>), Column('groupName', String(), table=<group>), Column('homePhone', String(), table=<group>), Column('mobilePhone1', String(), table=<group>), Column('loanCycle', Integer(), table=<group>), Column('creationDate', DateTime(), table=<group>), Column('notes', Text(), table=<group>), Column('assignedCentreKey', String(), ForeignKey('mambu_db.centre.encodedKey'), table=<group>), Column('assignedUserKey', String(), ForeignKey('mambu_db.user.encodedKey'), table=<group>), Column('assignedBranchKey', String(), ForeignKey('mambu_db.branch.encodedKey'), table=<group>), schema='mambu_db')
- __table_args__ = {'keep_existing': True, 'schema': 'mambu_db'}
- __tablename__ = 'group'
- _sa_class_manager = {'activities': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'addresses': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'assignedBranchKey': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'assignedCentreKey': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'assignedUserKey': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'branch': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'centre': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'clients': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'creationDate': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'customInformation': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'encodedKey': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'groupName': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'homePhone': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'id': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'loanCycle': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'loans': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'mobilePhone1': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'notes': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'roles': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'tasks': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'user': <sqlalchemy.orm.attributes.InstrumentedAttribute object>}
- activities
- addresses
- assignedBranchKey
- assignedCentreKey
- assignedUserKey
- branch
- centre
- clients
- creationDate
- customInformation
- encodedKey
- groupName
- homePhone
- id
- loanCycle
- loans
- mobilePhone1
- notes
- roles
- tasks
- user
- class MambuPy.orm.schema_groups.GroupRoleName(**kwargs)[source]
Bases:
Base
GroupRoleName table.
- __init__(**kwargs)
A simple constructor that allows initialization from kwargs.
Sets attributes on the constructed instance using the names and values in
kwargs
.Only keys that are present as attributes of the instance’s class are allowed. These could be, for example, any mapped columns or relationships.
- __mapper__ = <Mapper at 0x7f396decae50; GroupRoleName>
- __module__ = 'MambuPy.orm.schema_groups'
- __table__ = Table('grouprolename', MetaData(bind=None), Column('encodedKey', String(), table=<grouprolename>, primary_key=True, nullable=False), Column('name', String(), table=<grouprolename>), schema='mambu_db')
- __table_args__ = {'keep_existing': True, 'schema': 'mambu_db'}
- __tablename__ = 'grouprolename'
- _sa_class_manager = {'encodedKey': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'name': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'roles': <sqlalchemy.orm.attributes.InstrumentedAttribute object>}
- encodedKey
- name
- roles