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(**kwargs)

Group table.

GroupRoleName(**kwargs)

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'
__repr__()[source]

Return repr(self).

__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'
__repr__()[source]

Return repr(self).

__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