MambuPy.orm.schema_activities

Schema tables for Mambu Activities.

Classes

`Activity`(**kwargs)	Activity table.
`FieldChangeItem`(**kwargs)	Fieldchangeitem table.

class MambuPy.orm.schema_activities.Activity(**kwargs)[source]

Bases: Base

Activity 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 0x7f0448550190; Activity>

__module__ = 'MambuPy.orm.schema_activities'

__repr__()[source]: Return repr(self).

__table__ = Table('activity', MetaData(bind=None), Column('encodedKey', String(), table=<activity>, primary_key=True, nullable=False), Column('lineOfCreditKey', String(), table=<activity>), Column('centreKey', String(), table=<activity>), Column('loanProductKey', String(), table=<activity>), Column('savingsAccountKey', String(), table=<activity>), Column('savingsProductKey', String(), table=<activity>), Column('assignedCentreKey', String(), table=<activity>), Column('taskKey', String(), table=<activity>), Column('glAccountKey', String(), table=<activity>), Column('glAccountsClosureKey', String(), table=<activity>), Column('entityKey', String(), table=<activity>), Column('transactionId', Integer(), table=<activity>), Column('entityType', String(), table=<activity>), Column('parent_key', String(), table=<activity>), Column('fieldChangeName', String(), table=<activity>), Column('activityChanges_integer_idx', Integer(), table=<activity>), Column('timestamp', DateTime(), table=<activity>), Column('notes', String(), table=<activity>), Column('type', String(), table=<activity>), Column('loanAccountKey', String(), ForeignKey('mambu_db.loanaccount.encodedKey'), table=<activity>), Column('branchKey', String(), ForeignKey('mambu_db.branch.encodedKey'), table=<activity>), Column('clientKey', String(), ForeignKey('mambu_db.client.encodedKey'), table=<activity>), Column('groupKey', String(), ForeignKey('mambu_db.group.encodedKey'), table=<activity>), Column('userKey', String(), ForeignKey('mambu_db.user.encodedKey'), table=<activity>), Column('assignedUserKey', String(), ForeignKey('mambu_db.user.encodedKey'), table=<activity>), schema='mambu_db')

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

__tablename__ = 'activity'

_sa_class_manager = {'activityChanges_integer_idx': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'assignedCentreKey': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'assignedUser': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'assignedUserKey': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'branch': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'branchKey': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'centreKey': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'client': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'clientKey': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'encodedKey': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'entityKey': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'entityType': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'fieldChangeName': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'fieldChanges': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'glAccountKey': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'glAccountsClosureKey': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'group': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'groupKey': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'lineOfCreditKey': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'loan': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'loanAccountKey': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'loanProductKey': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'notes': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'parent_key': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'savingsAccountKey': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'savingsProductKey': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'taskKey': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'timestamp': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'transactionId': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'type': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'user': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'userKey': <sqlalchemy.orm.attributes.InstrumentedAttribute object>}

activityChanges_integer_idx

assignedCentreKey

assignedUser

assignedUserKey

branch

branchKey

centreKey

client

clientKey

encodedKey

entityKey

entityType

fieldChangeName

fieldChanges

glAccountKey

glAccountsClosureKey

group

groupKey

lineOfCreditKey

loan

loanAccountKey

loanProductKey

notes

parent_key

savingsAccountKey

savingsProductKey

taskKey

timestamp

transactionId

type

user

userKey

class MambuPy.orm.schema_activities.FieldChangeItem(**kwargs)[source]

Bases: Base

Fieldchangeitem 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 0x7f0448557dc0; FieldChangeItem>

__module__ = 'MambuPy.orm.schema_activities'

__repr__()[source]: Return repr(self).

__table__ = Table('fieldchangeitem', MetaData(bind=None), Column('id', String(), table=<fieldchangeitem>, primary_key=True, nullable=False), Column('fieldChangeName', String(), table=<fieldchangeitem>), Column('fieldDetailName', String(), table=<fieldchangeitem>), Column('fieldDetailKey', String(), table=<fieldchangeitem>), Column('newValue', String(), table=<fieldchangeitem>), Column('originalValue', String(), table=<fieldchangeitem>), Column('fieldchanges_integer_idx', Integer(), table=<fieldchangeitem>), Column('fieldchanges_encodedkey_own', String(), ForeignKey('mambu_db.activity.encodedKey'), table=<fieldchangeitem>), schema='mambu_db')

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

__tablename__ = 'fieldchangeitem'

_sa_class_manager = {'activity': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'fieldChangeName': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'fieldDetailKey': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'fieldDetailName': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'fieldchanges_encodedkey_own': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'fieldchanges_integer_idx': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'id': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'newValue': <sqlalchemy.orm.attributes.InstrumentedAttribute object>, 'originalValue': <sqlalchemy.orm.attributes.InstrumentedAttribute object>}

activity

fieldChangeName

fieldDetailKey

fieldDetailName

fieldchanges_encodedkey_own

fieldchanges_integer_idx

id

newValue

originalValue