120 lines
2.8 KiB
Python
120 lines
2.8 KiB
Python
from logging_config import get_logger
|
|
|
|
logger = get_logger(__name__)
|
|
|
|
|
|
class Repository:
|
|
|
|
|
|
|
|
def __init__(self, db):
|
|
self.db = db
|
|
|
|
def fetch_expired_records(self):
|
|
|
|
sql = """
|
|
SELECT
|
|
PACS_ID,
|
|
KEY_1,
|
|
MARK_TELLER_ID
|
|
FROM BULK_ACCT_MARK
|
|
WHERE STATUS='R'
|
|
AND SEND_DT < TRUNC(SYSDATE)-5
|
|
"""
|
|
|
|
with self.db.get_connection() as con:
|
|
cur = con.cursor()
|
|
cur.execute(sql)
|
|
|
|
rows = cur.fetchall()
|
|
|
|
logger.info(
|
|
"Total expired records found : %s",
|
|
len(rows)
|
|
)
|
|
|
|
return rows
|
|
|
|
def process_record(self, pacs_id, key_1):
|
|
|
|
with self.db.get_connection() as con:
|
|
|
|
cur = con.cursor()
|
|
|
|
logger.info(
|
|
"Processing PACS_ID=%s KEY_1=%s",
|
|
pacs_id,
|
|
key_1
|
|
)
|
|
|
|
insert_hist = """
|
|
INSERT INTO BULK_ACCT_MARK_HIST
|
|
(
|
|
PACS_ID,
|
|
KEY_1,
|
|
MARK_TELLER_ID,
|
|
TRAN_DT,
|
|
TRAN_TYM,
|
|
STATUS,
|
|
REMARKS,
|
|
SEND_TELLER_ID,
|
|
SEND_DT,
|
|
SEND_TYM
|
|
)
|
|
SELECT
|
|
PACS_ID,
|
|
KEY_1,
|
|
MARK_TELLER_ID,
|
|
TRAN_DT,
|
|
TRAN_TYM,
|
|
STATUS,
|
|
'AUTO UNMARK AFTER 5 DAYS',
|
|
SEND_TELLER_ID,
|
|
(SELECT SYSTEM_DATE FROM SYSTEM_DATE),
|
|
TO_CHAR(
|
|
SYSTIMESTAMP,
|
|
'DD-MON-RRHH12:MI:SS'
|
|
)
|
|
FROM BULK_ACCT_MARK
|
|
WHERE PACS_ID=:1
|
|
AND KEY_1=:2
|
|
"""
|
|
|
|
cur.execute(
|
|
insert_hist,
|
|
[
|
|
pacs_id,
|
|
key_1
|
|
]
|
|
)
|
|
|
|
update_sql = """
|
|
UPDATE BULK_ACCT_MARK
|
|
SET STATUS='RBB'
|
|
WHERE PACS_ID=:1
|
|
AND KEY_1=:2
|
|
"""
|
|
|
|
cur.execute(
|
|
update_sql,
|
|
[pacs_id, key_1]
|
|
)
|
|
|
|
delete_sql = """
|
|
DELETE FROM BULK_ACC_TRICKLEFEED_FILE_AUTO
|
|
WHERE PACS_ID=:1
|
|
AND ADD_1=:2
|
|
"""
|
|
|
|
deleted = cur.execute(
|
|
delete_sql,
|
|
[pacs_id, key_1]
|
|
)
|
|
|
|
con.commit()
|
|
|
|
logger.info(
|
|
"Unmarked PACS_ID=%s KEY_1=%s successfully",
|
|
pacs_id,
|
|
key_1
|
|
) |