Python getの例

コード例 #1

from sqlalchemy import Table, ForeignKey, Column
from sqlalchemy.types import Unicode, Integer, DateTime, Boolean
from sqlalchemy.orm import relation, synonym

from rocket.model import DeclarativeBase, metadata, DBSession
from rocket.lib.model_utils import PhatBase, common_columns, get_phat_table, get_type_table

# ********************* Payment ***********************************#

PaymentType = get_type_table(model_name='Payment', table_name='payment')
PaymentTransactionType = get_type_table(model_name='PaymentTransaction', table_name='payment_transaction')
PaymentTransactionDebitCreditType = get_type_table(model_name='PaymentTransactionDebitCredit', table_name='payment_transaction_debit_credit')

columns_tbl_payment = {
    '__tablename__': 'tbl_payment',
    'policy_id': common_columns.get('integer')(),
    'payment_date': common_columns.get('datetime')(),
    'registration_date': common_columns.get('datetime')(),
    'registration_by_id': common_columns.get('integer')(),
    'payment_type_id': common_columns.get('integer')(),
    'payment_transaction_type_id': common_columns.get('integer')(),
    'currency_id': common_columns.get('integer')(),
    'receipt_number': common_columns.get('description')(),
    'message': common_columns.get('description')(),
    'payment_post_method_id': common_columns.get('integer')(),
    'bank_reference': common_columns.get('description')()
}
Payment = get_phat_table(model_name='Payment', columndict=columns_tbl_payment)

columns_tbl_payment_link = {
    '__tablename__': 'tbl_payment_link',

コード例 #2

ファイル: sql_product_new_by_cam.py プロジェクト: MsFaceless/codezone

BenefitAllocationCalculationType = get_type_table(model_name='BenefitAllocationCalculation', table_name='benefit_allocation_calculation') # Percentage, Amount, Factor
BenefitFrequencyType = get_type_table(model_name='BenefitFrequency', table_name='benefit_frequency') # Daily, Weekly, etc.
BenefitAssuredLifeRelationshipType = get_type_table(model_name='BenefitAssuredLifeRelationship', table_name='benefit_assured_life_relationship') # Principal, Spouse, etc.
BenefitAssetType = get_type_table(model_name='BenefitAsset', table_name='benefit_asset') # Business, Employee, Vehicle, Property

# Utilities
SystemDocumentType = get_type_table(model_name='SystemDocument', table_name='system_document') # Welcome, Claim, Member, Product
LoaderQuestionPremiumEffectType = get_type_table(model_name='LoaderQuestionPremiumEffect', table_name='loader_question_premium_effect') # None, Percentage, Amount

###############################################################################
# Product
###############################################################################

columns_tbl_product = {
    '__tablename__': 'tbl_product',
    'product_type_id': common_columns.get('integer')(),
    'code': common_columns.get('code_not_nullable')(),
    'name': common_columns.get('title_not_nullable')(),
    'entity_org_product_owner_id': common_columns.get('integer')(),
    'product_state_type_id': common_columns.get('integer')(), # default: Sandbox
    'policy_number_prefix': common_columns.get('title')(),
}
Product = get_phat_table(model_name='Product', columndict=columns_tbl_product)

columns_tbl_product_history_link = {
    '__tablename__': 'tbl_product_history_link',
    'product_id': common_columns.get('integer_not_nullable')(),
    'previous_product_id': common_columns.get('integer_not_nullable')()
}
ProductHistoryLink = get_phat_table(model_name='ProductHistoryLink', columndict=columns_tbl_product_history_link)

コード例 #3

EntityType = get_type_table(model_name='Entity', table_name='entity')
EntityOrganisationType = get_type_table(model_name='EntityOrganisation',
                                        table_name='entity_organisation')
EntityOrganisationContactType = get_type_table(
    model_name='EntityOrganisationContact',
    table_name='entity_organisation_contact')
EntityOrganisationAddressType = get_type_table(
    model_name='EntityOrganisationAddress',
    table_name='entity_organisation_address')

# ********************* Entity ***********************************#

columns_tbl_entity = {
    '__tablename__': 'tbl_entity',
    'entity_type_id': common_columns.get('integer_not_nullable')(),
}
Entity = get_phat_table(model_name='Entity', columndict=columns_tbl_entity)

columns_tbl_entity_person = {
    '__tablename__': 'tbl_entity_person',
    'entity_id': common_columns.get('integer_not_nullable')(),
    'person_id': common_columns.get('integer_not_nullable')(),
    'identity_number': common_columns.get('description')(),
}
EntityPerson = get_phat_table(model_name='EntityPerson',
                              columndict=columns_tbl_entity_person)

columns_tbl_entity_person_relationship_link = {
    '__tablename__': 'tbl_entity_person_relationship_link',
    'entity_person_id': common_columns.get('integer_not_nullable')(),

コード例 #4

ファイル: sql_product_old.py プロジェクト: MsFaceless/codezone

from rocket.lib.model_utils import PhatBase, common_columns, get_type_table, get_phat_table

# ---------------------------- Product -----------------------------------

# Product, ProductType, ProductState, ProductHistoryLink

ProductType = get_type_table(
    model_name='Product',
    table_name='product')  # Voucher, Traditional, Term Life, Credit Life
ProductStateType = get_type_table(
    model_name='ProductState',
    table_name='product_state')  # Sandbox, Active, Expired

columns_tbl_product = {
    '__tablename__': 'tbl_product',
    'product_type_id': common_columns.get('integer')(),
    'code': common_columns.get('code')(),
    'name': common_columns.get('title_not_nullable')(),
    'product_owner_id': common_columns.get('integer')(),
    'product_state_id': common_columns.get('integer')(),
    'policy_number_prefix': common_columns.get('title')(),
}
Product = get_phat_table(model_name='Product', columndict=columns_tbl_product)

columns_tbl_product_history_link = {
    '__tablename__': 'tbl_product_history_link',
    'product_id': common_columns.get('integer_not_nullable')(),
    'previous_product_id': common_columns.get('integer')()
}
ProductHistoryLink = get_phat_table(
    model_name='ProductHistoryLink',

コード例 #5

ファイル: sql_policy.py プロジェクト: MsFaceless/codezone

from sqlalchemy import Table, ForeignKey, Column
from sqlalchemy.types import Unicode, Integer, DateTime, Boolean
from sqlalchemy.orm import relation, synonym

from rocket.model import DeclarativeBase, metadata, DBSession
from rocket.lib.model_utils import PhatBase, common_columns, get_phat_table, get_type_table

# ********************* Policy ***********************************#

PolicyType = get_type_table(model_name='Policy', table_name='policy')
PolicyDateType = get_type_table(model_name='PolicyDate',
                                table_name='policy_date')

columns_tbl_policy = {
    '__tablename__': 'tbl_policy',
    'policy_number': common_columns.get('title_not_nullable')(),
    'policy_type_id': common_columns.get('integer_not_nullable')(),
    'product_id': common_columns.get('integer_not_nullable')(),
    'entity_insured_id': common_columns.get('integer_not_nullable')(),
    'entity_policy_owner_id': common_columns.get('integer')(),
    'application_form_serial_no': common_columns.get('title')(),
}
Policy = get_phat_table(model_name='Policy', columndict=columns_tbl_policy)

columns_tbl_policy_intermediary_link = {
    '__tablename__':
    'tbl_policy_intermediary_link',
    'policy_id':
    common_columns.get('integer_not_nullable')(),
    'entity_organisation_intermediary_id':
    common_columns.get('integer_not_nullable')(),

コード例 #6

ファイル: sql_utilities.py プロジェクト: MsFaceless/codezone

import os
from datetime import datetime
from hashlib import sha256

from sqlalchemy import Table, ForeignKey, Column
from sqlalchemy.types import Unicode, Integer, DateTime, Boolean
from sqlalchemy.orm import relation, synonym

from rocket.model import DeclarativeBase, metadata, DBSession
from rocket.lib.model_utils import PhatBase, common_columns, get_type_table, get_phat_table

# ---------------------------- Currency -----------------------------------

columns_tbl_currency = {
    '__tablename__': 'tbl_currency',
    'code': common_columns.get('title_not_nullable')(),
    'name': common_columns.get('title_not_nullable')(),
    'is_home_currency': common_columns.get('boolean_default_false')()
}
Currency = get_phat_table(model_name='Currency',
                          columndict=columns_tbl_currency)

columns_tbl_language = {
    '__tablename__': 'tbl_language',
    'code': common_columns.get('title_not_nullable')(),
    'name': common_columns.get('title_not_nullable')()
}
Language = get_phat_table(model_name='Language',
                          columndict=columns_tbl_language)

columns_tbl_mail_merge = {

コード例 #7

ファイル: sql_batch_import.py プロジェクト: MsFaceless/codezone

from sqlalchemy import Table, ForeignKey, Column
from sqlalchemy.types import Unicode, Integer, DateTime, Boolean
from sqlalchemy.orm import relation, synonym

from rocket.model import DeclarativeBase, metadata, DBSession
from rocket.lib.model_utils import PhatBase, common_columns, get_phat_table, get_type_table

# ********************* Batch Import ***********************************#

BatchImportType = get_type_table(model_name='BatchImport',
                                 table_name='batch_import')

columns_tbl_batch_import = {
    '__tablename__': 'tbl_batch_import',
    'import_type_id': common_columns.get('integer_not_nullable')(),
    'filename': common_columns.get('description_not_nullable')(),
    'processed': common_columns.get('datetime')(),
    'total_count': common_columns.get('integer')(),
    'accepted_count': common_columns.get('integer')(),
    #pre_purchase_count: common_columns.get('integer_default')(0), # Ask Directors if this functionality is required ???? 14 Jan 2020 Trevor
    'rejected_count': common_columns.get('integer')(),
    'notes': common_columns.get('description_not_nullable')(),
    #'is_complete_load': common_columns.get('boolean_default_false')(),
    #'is_complete_update': common_columns.get('boolean_default_false')(),
    #'is_successful': common_columns.get('boolean_default_false')(),
}
BatchImport = get_phat_table(model_name='BatchImport',
                             columndict=columns_tbl_batch_import)

columns_tbl_batch_import_audit = {

コード例 #8

ファイル: sql_claim.py プロジェクト: MsFaceless/codezone

import os
from datetime import datetime
from hashlib import sha256

from sqlalchemy import Table, ForeignKey, Column
from sqlalchemy.types import Unicode, Integer, DateTime, Boolean
from sqlalchemy.orm import relation, synonym

from rocket.model import DeclarativeBase, metadata, DBSession
from rocket.lib.model_utils import PhatBase, common_columns, get_phat_table, get_type_table

# ********************* Claim ***********************************#

columns_tbl_claim = {
    '__tablename__': 'tbl_claim',
    'capture_date': common_columns.get('date')(),
    'cover_and_exclusion_type_id':
    common_columns.get('integer_not_nullable')(),
}
Claim = get_phat_table(model_name='Claim', columndict=columns_tbl_claim)

columns_tbl_claim_claimant = {
    '__tablename__': 'tbl_claim_claimant',
    'claim_id': common_columns.get('integer_not_nullable')(),
    'person_id': common_columns.get('integer_not_nullable')(),
}
ClaimClaimant = get_phat_table(model_name='ClaimClaimant',
                               columndict=columns_tbl_claim_claimant)

# ********************* Claim Status ***********************************#

コード例 #9

import os
from datetime import datetime
from hashlib import sha256

from sqlalchemy import Table, ForeignKey, Column
from sqlalchemy.types import Unicode, Integer, DateTime, Boolean
from sqlalchemy.orm import relation, synonym

from rocket.model import DeclarativeBase, metadata, DBSession
from rocket.lib.model_utils import PhatBase, common_columns, get_phat_table, get_type_table

# ********************* Member ***********************************#

columns_tbl_member = {
    '__tablename__': 'tbl_member',
    'person_id': common_columns.get('integer_unique_not_nullable')(),
    'register_date': common_columns.get('date_not_nullable')(),
    'external_id': common_columns.get('integer')()
}
Member = get_phat_table(model_name='Member', columndict=columns_tbl_member)

# ********************* Member Comment ***********************************#

columns_tbl_member_comment = {
    '__tablename__': 'tbl_member_comment',
    'member_id': common_columns.get('integer_not_nullable')(),
    'comment': common_columns.get('longtext_not_nullable')()
}
MemberComment = get_phat_table(model_name='MemberComment',
                               columndict=columns_tbl_member_comment)