def insert_client(entry: Client): query = ''' INSERT INTO [DE5.tkrv_DWH_DIM_clients] (client_id , first_name , last_name , patrinymic , date_of_birth , passport_num , passport_valid_to , phone , create_dt , update_dt) VALUES(?,?,?,?,?,?,?,?,?,?); ''' executor = DefaultRepository().cursor executor.execute(query, [ entry.client_id, entry.first_name, entry.last_name, entry.patrinymic, entry.date_of_birth, entry.passport_num, entry.passport_valid_to, entry.phone, entry.created, entry.updated ]) DefaultRepository().commit()
def get_events(sql): connection = DefaultRepository() connection.cursor.execute(sql) rows = connection.cursor.fetchall() events = [] for d in rows: event = FraudReportEntry() event.event_datetime = d[1] event.passport = d[2] event.fio = d[3] event.phone = d[4] event.event_type = d[5] events.append(event) return events
def terminal_already_exists(terminal_id): return DefaultRepository() \ .check_existence('''SELECT * FROM [DE5.tkrv_DWH_DIM_terminals] AS tl WHERE tl.terminal_id = ? ''' , [terminal_id])
def account_already_exists(account_number): return DefaultRepository() \ .check_existence('''SELECT * FROM [DE5.tkrv_DWH_DIM_accounts] AS acc WHERE acc.account_num = ? ''' , [account_number])
def passport_already_exists(passport_id): return DefaultRepository() \ .check_existence('''SELECT * FROM [DE5.tkrv_DWH_FACT_passport_blacklist] AS bp WHERE bp.passport_num = ? ''' , [passport_id])
from application.ExcelParser import fill_transactions, fill_passport_blacklist from application.PackageHelper import install_package from application.DefaultRepository import DefaultRepository from application.ReportBuilder import build_report, get_report print('Установка пакета xlrd') install_package("xlrd") connection = DefaultRepository() new_trans_files_count = fill_transactions() new_passports_files_count = fill_passport_blacklist() # строим отчет на текущую дату, если были загрружены новые файлы need_build_report = new_trans_files_count > 0 or new_passports_files_count > 0 if need_build_report: build_report() get_report()
def card_already_exists(card_number): return DefaultRepository() \ .check_existence('''SELECT * FROM [DE5.tkrv_DWH_DIM_cards] AS crd WHERE crd.card_num = ? ''' , [card_number])
def client_already_exists(client_id): return DefaultRepository() \ .check_existence('''SELECT * FROM [DE5.tkrv_DWH_DIM_clients] AS cl WHERE cl.client_id = ? ''' , [client_id])