MambuPy.orm.schema_users

Schema tables for Mambu Users.

Todo

this are just very basic schemas for users.

Classes

Role(**kwargs)	Role table.
User(**kwargs)	User table.

class MambuPy.orm.schema_users.Role(**kwargs)

Bases: Base

Role table. Related with user

__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 0x7f044864ae20; Role>

__module__ = 'MambuPy.orm.schema_users'

__repr__()

Return repr(self).

__table__ = Table('role', MetaData(bind=None), Column('encodedKey', String(), table=<role>, primary_key=True, nullable=False), Column('name', String(), table=<role>), schema='mambu_db')

__table_args__ = {'keep_existing': True, 'schema': 'mambu_db'}

__tablename__ = 'role'

_sa_class_manager = {'encodedKey': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'name': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'users': <sqlalchemy.orm.attributes.InstrumentedAttribute object>}

encodedKey

name

users

class MambuPy.orm.schema_users.User(**kwargs)

Bases: Base

User 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 0x7f0448655c40; User>

__module__ = 'MambuPy.orm.schema_users'

__repr__()

Return repr(self).

__table__ = Table('user', MetaData(bind=None), Column('encodedKey', String(), table=<user>, primary_key=True, nullable=False), Column('id', String(), table=<user>), Column('firstName', String(), table=<user>), Column('lastName', String(), table=<user>), Column('userName', String(), table=<user>), Column('homePhone', String(), table=<user>), Column('mobilePhone1', String(), table=<user>), Column('userState', String(), table=<user>), Column('email', String(), table=<user>), Column('creationDate', DateTime(), table=<user>), Column('isCreditOfficer', Integer(), table=<user>), Column('assignedBranchKey', String(), ForeignKey('mambu_db.branch.encodedKey'), table=<user>), Column('role_encodedKey_oid', String(), ForeignKey('mambu_db.role.encodedKey'), table=<user>), schema='mambu_db')

__table_args__ = {'keep_existing': True, 'schema': 'mambu_db'}

__tablename__ = 'user'

_sa_class_manager = {'activities': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'assignedActivities': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'assignedBranchKey': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'assignedTasks': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'branch': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'createdTasks': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'creationDate': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'customInformation': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'email': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'encodedKey': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'firstName': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'groups': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'homePhone': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'id': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'isCreditOfficer': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'lastName': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'loans': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'mobilePhone1': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'role': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'role_encodedKey_oid': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'userName': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'userState': <sqlalchemy.orm.attributes.InstrumentedAttribute object>}

activities

assignedActivities

assignedBranchKey

assignedTasks

branch

createdTasks

creationDate

customInformation

email

encodedKey

firstName

groups

homePhone

id

isCreditOfficer

lastName

loans

mobilePhone1

property name

role

role_encodedKey_oid

userName

userState