def insert_account(account: Account):
query = '''
INSERT INTO [DE5.tkrv_DWH_DIM_accounts] (account_num, valid_to, client, create_dt, update_dt)
VALUES(?,?,?,?,?);
'''
connection = DefaultRepository()
executor = connection.cursor
executor.execute(query, [
account.account_number, account.valid_to, account.client_id,
account.created, account.updated
])
connection.commit()
def insert_event(e: FraudReportEntry, datetime):
connection = DefaultRepository()
connection.cursor.execute(
'''INSERT INTO [DE5.tkrv_REP_FRAUD] (
event_dt,
passport,
fio,
phone,
event_type,
report_dt
)
VALUES (
?,
?,
?,
?,
?,
?
);''',
[e.event_datetime, e.passport, e.fio, e.phone, e.event_type, datetime])
connection.commit()