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])