Python RelationMap Examples

Example #1

File: tax_rebate.py Project: gordon-elliott/glod

__copyright__ = 'Copyright(c) Gordon Elliott 2017'
""" 
"""

from a_tuin.db import RelationMap, TableMap, PagedQuery, InstanceQuery

from glod.model.tax_rebate import TaxRebate, TaxRebateCollection
from glod.model.references import tax_rebate__person

from glod.db.db_column_type_map import DB_COLUMN_TYPE_MAP
from glod.db.constants import SCHEMA_NAME

TableMap(
    TaxRebate, SCHEMA_NAME, 'tax_rebate', DB_COLUMN_TYPE_MAP,
    RelationMap(tax_rebate__person,
                'person._id',
                backref='tax_rebates',
                lazy='joined'))


class TaxRebateInstanceQuery(InstanceQuery):
    def __init__(self, session):
        super().__init__(TaxRebate, TaxRebateCollection, session)


class TaxRebateQuery(PagedQuery):
    def __init__(self, session):
        super().__init__(TaxRebate, TaxRebateCollection, session)

Example #2

DB_COLUMN_TYPE_MAP[AClassStatusField] = Enum(AClassStatus)
SCHEMA_NAME = 'a_schema'

MOCK_SESSION = Mock()


def with_session(fn):
    def wrapped_with_session(self, info, **kwargs):
        context = info.context
        return fn(self, kwargs, context, info, MOCK_SESSION)

    return wrapped_with_session


TableMap(AClass, SCHEMA_NAME, 'aclass', DB_COLUMN_TYPE_MAP)


class AClassQuery(PagedQuery):
    def __init__(self, session):
        super().__init__(AClass, AClassCollection, session)


TableMap(AReferringClass, SCHEMA_NAME, 'areferringclass', DB_COLUMN_TYPE_MAP,
         RelationMap(areferringclass__aclass, 'aclass._id'))


class AReferringClassQuery(PagedQuery):
    def __init__(self, session):
        super().__init__(AReferringClass, AReferringClassCollection, session)

Example #3

""" 
"""

from a_tuin.db import TableMap, PagedQuery, InstanceQuery, RelationMap

from glod.model.communication_permission import CommunicationPermission, CommunicationPermissionCollection
from glod.model.references import communication_permission__person

from glod.db.db_column_type_map import DB_COLUMN_TYPE_MAP
from glod.db.constants import SCHEMA_NAME

TableMap(
    CommunicationPermission, SCHEMA_NAME, 'communication_permission',
    DB_COLUMN_TYPE_MAP,
    RelationMap(communication_permission__person,
                'person._id',
                backref='communication_permissions',
                lazy='selectin'))


class CommunicationPermissionInstanceQuery(InstanceQuery):
    def __init__(self, session):
        super().__init__(CommunicationPermission,
                         CommunicationPermissionCollection, session)


class CommunicationPermissionQuery(PagedQuery):
    def __init__(self, session):
        super().__init__(CommunicationPermission,
                         CommunicationPermissionCollection, session)

Example #4

File: fund.py Project: gordon-elliott/glod

__copyright__ = 'Copyright(c) Gordon Elliott 2017'
""" 
"""

from a_tuin.db import TableMap, RelationMap, PagedQuery, InstanceQuery

from glod.model.fund import Fund, FundRestriction, FundCollection
from glod.model.references import fund__account

from glod.db.db_column_type_map import DB_COLUMN_TYPE_MAP
from glod.db.constants import SCHEMA_NAME

TableMap(
    Fund, SCHEMA_NAME, 'fund', DB_COLUMN_TYPE_MAP,
    RelationMap(fund__account, 'account._id', backref='funds', lazy='joined'))


class FundInstanceQuery(InstanceQuery):
    def __init__(self, session):
        super().__init__(Fund, FundCollection, session)


class FundQuery(PagedQuery):
    def __init__(self, session):
        super().__init__(Fund, FundCollection, session)

Example #5

from glod.model.transaction import Transaction

from a_tuin.db import TableMap, RelationMap, PagedQuery, InstanceQuery

from glod.model.transaction_check import TransactionCheck, TransactionCheckCollection
from glod.model.references import transaction_check__transaction, transaction_check__statement_item

from glod.db.db_column_type_map import DB_COLUMN_TYPE_MAP
from glod.db.constants import SCHEMA_NAME


LOG = logging.getLogger(__name__)

TableMap(TransactionCheck, SCHEMA_NAME, 'transaction_check', DB_COLUMN_TYPE_MAP, RelationMap(
    transaction_check__transaction,
    'transaction._id',
    backref='checks',
    lazy='joined'
), RelationMap(
    transaction_check__statement_item,
    'statement_item._id',
    backref='transaction_checks',
    lazy='joined'
))


class TransactionCheckInstanceQuery(InstanceQuery):
    def __init__(self, session):
        super().__init__(TransactionCheck, TransactionCheckCollection, session)


class TransactionCheckQuery(PagedQuery):

Example #6

File: person_rebate_submission.py Project: gordon-elliott/glod

__copyright__ = "Copyright (c) Gordon Elliott 2020"

from a_tuin.db import TableMap, RelationMap, PagedQuery, InstanceQuery

from glod.model.person_rebate_submission import PersonRebateSubmission, PersonRebateSubmissionCollection
from glod.model.references import person_rebate_submission__person, person_rebate_submission__tax_rebate_submission

from glod.db.db_column_type_map import DB_COLUMN_TYPE_MAP
from glod.db.constants import SCHEMA_NAME

TableMap(
    PersonRebateSubmission, SCHEMA_NAME, 'person_rebate_submission',
    DB_COLUMN_TYPE_MAP,
    RelationMap(person_rebate_submission__tax_rebate_submission,
                'tax_rebate_submission._id',
                backref='people',
                lazy='joined'),
    RelationMap(person_rebate_submission__person,
                'person._id',
                backref='tax_rebate_submissions',
                lazy='joined'))


class PersonRebateSubmissionInstanceQuery(InstanceQuery):
    def __init__(self, session):
        super().__init__(PersonRebateSubmission,
                         PersonRebateSubmissionCollection, session)


class PersonRebateSubmissionQuery(PagedQuery):
    def __init__(self, session):

Example #7

File: counterparty.py Project: gordon-elliott/glod

__copyright__ = 'Copyright(c) Gordon Elliott 2017'
""" 
"""

from a_tuin.db import RelationMap, TableMap, PagedQuery, InstanceQuery

from glod.model.counterparty import Counterparty, CounterpartyCollection
from glod.model.references import counterparty__person, counterparty__organisation

from glod.db.db_column_type_map import DB_COLUMN_TYPE_MAP
from glod.db.constants import SCHEMA_NAME

TableMap(
    Counterparty, SCHEMA_NAME, 'counterparty', DB_COLUMN_TYPE_MAP,
    RelationMap(counterparty__person,
                'person._id',
                backref='counterparties',
                lazy='selectin'),
    RelationMap(counterparty__organisation,
                'organisation._id',
                backref='counterparties',
                lazy='selectin'))


class CounterpartyInstanceQuery(InstanceQuery):
    def __init__(self, session):
        super().__init__(Counterparty, CounterpartyCollection, session)


class CounterpartyQuery(PagedQuery):
    def __init__(self, session):
        super().__init__(Counterparty, CounterpartyCollection, session)

Example #8

__copyright__ = 'Copyright(c) Gordon Elliott 2017'
""" 
"""

from a_tuin.db import TableMap, RelationMap, PagedQuery, InstanceQuery

from glod.model.transaction import Transaction, PaymentMethod, IncomeExpenditure, TransactionCollection
from glod.model.references import transaction__counterparty, transaction__subject, transaction__fund

from glod.db.db_column_type_map import DB_COLUMN_TYPE_MAP
from glod.db.constants import SCHEMA_NAME

TableMap(
    Transaction, SCHEMA_NAME, 'transaction', DB_COLUMN_TYPE_MAP,
    RelationMap(transaction__counterparty,
                'counterparty._id',
                backref='transactions',
                lazy='selectin'),
    RelationMap(transaction__subject,
                'subject._id',
                backref='transactions',
                lazy='joined'),
    RelationMap(transaction__fund,
                'fund._id',
                backref='transactions',
                lazy='joined'))


class TransactionInstanceQuery(InstanceQuery):
    def __init__(self, session):
        super().__init__(Transaction, TransactionCollection, session)

Example #9

__copyright__ = 'Copyright(c) Gordon Elliott 2017'
""" 
"""

from a_tuin.db import TableMap, RelationMap, PagedQuery, InstanceQuery

from glod.model.person import Person, PersonCollection
from glod.model.references import person__organisation

from glod.db.db_column_type_map import DB_COLUMN_TYPE_MAP
from glod.db.constants import SCHEMA_NAME

TableMap(
    Person, SCHEMA_NAME, 'person', DB_COLUMN_TYPE_MAP,
    RelationMap(person__organisation,
                'organisation._id',
                backref='people',
                lazy='joined'))


class PersonInstanceQuery(InstanceQuery):
    def __init__(self, session):
        super().__init__(Person, PersonCollection, session)


class PersonQuery(PagedQuery):
    def __init__(self, session):
        super().__init__(Person, PersonCollection, session)

Example #10

__copyright__ = 'Copyright(c) Gordon Elliott 2017'
""" 
"""

from a_tuin.db import RelationMap, TableMap, PagedQuery, InstanceQuery

from glod.model.envelope import Envelope, EnvelopeCollection
from glod.model.references import envelope__counterparty, envelope__person

from glod.db.db_column_type_map import DB_COLUMN_TYPE_MAP
from glod.db.constants import SCHEMA_NAME

TableMap(
    Envelope, SCHEMA_NAME, 'envelope', DB_COLUMN_TYPE_MAP,
    RelationMap(envelope__counterparty,
                'counterparty._id',
                backref='envelopes',
                lazy='joined'),
    RelationMap(envelope__person,
                'person._id',
                backref='envelopes',
                lazy='joined'))


class EnvelopeInstanceQuery(InstanceQuery):
    def __init__(self, session):
        super().__init__(Envelope, EnvelopeCollection, session)


class EnvelopeQuery(PagedQuery):
    def __init__(self, session):
        super().__init__(Envelope, EnvelopeCollection, session)

Example #11

__copyright__ = 'Copyright(c) Gordon Elliott 2017'
""" 
"""

from a_tuin.db import RelationMap, TableMap, PagedQuery, InstanceQuery

from glod.model.statement_item import StatementItem, StatementItemDesignatedBalance
from glod.model.statement_item_collection import StatementItemCollection
from glod.model.references import statement_item__account

from glod.db.db_column_type_map import DB_COLUMN_TYPE_MAP
from glod.db.constants import SCHEMA_NAME

TableMap(
    StatementItem, SCHEMA_NAME, 'statement_item', DB_COLUMN_TYPE_MAP,
    RelationMap(statement_item__account,
                'account._id',
                backref='statement_items',
                lazy='joined'))


class StatementItemInstanceQuery(InstanceQuery):
    def __init__(self, session):
        super().__init__(StatementItem, StatementItemCollection, session)


class StatementItemQuery(PagedQuery):
    def __init__(self, session):
        super().__init__(StatementItem, StatementItemCollection, session)

Example #12

File: organisation_address.py Project: gordon-elliott/glod

""" 
"""

from a_tuin.db import TableMap, RelationMap, PagedQuery, InstanceQuery

from glod.model.organisation_address import OrganisationAddress, OrganisationAddressCollection
from glod.model.references import organisation_address__address, organisation_address__organisation

from glod.db.db_column_type_map import DB_COLUMN_TYPE_MAP
from glod.db.constants import SCHEMA_NAME

TableMap(
    OrganisationAddress, SCHEMA_NAME, 'organisation_address',
    DB_COLUMN_TYPE_MAP,
    RelationMap(organisation_address__address,
                'address._id',
                backref='organisation_addresses',
                lazy='selectin'),
    RelationMap(organisation_address__organisation,
                'organisation._id',
                backref='organisation_addresses',
                lazy='joined'))


class OrganisationAddressInstanceQuery(InstanceQuery):
    def __init__(self, session):
        super().__init__(OrganisationAddress, OrganisationAddressCollection,
                         session)


class OrganisationAddressQuery(PagedQuery):
    def __init__(self, session):