def delete_mortgages_not_current(institution_code, date, forcedelete, logger):
logger = logging.getLogger('retrieve')
logger.info('In delete_mortgages_not_current')
themortgagemeter_db.cursor.execute(sql_count_jrnl_institution_there,
(institution_code, ))
row = themortgagemeter_db.cursor.fetchone()
count = int(row[0])
deletecount = 0
logger.info('There are %s mortgages currently', count)
themortgagemeter_db.cursor.execute(sql_get_mortgages_not_retrieved_on_date,
(institution_code, date))
for row in themortgagemeter_db.cursor.fetchall():
mortgage_id = row[0]
logger.info('Deleting current mortgage: %s %s %s', institution_code,
date, mortgage_id)
themortgagemeter_db.run_sql(sql_update_mortgage_jrnl_delete,
(date, mortgage_id))
deletecount += 1
main.update_changes(True, institution_code, logger)
logger.info('%s mortgages deleted', (int(deletecount)))
if count > 0 and deletecount == count and forcedelete == False:
themortgagemeter_utils.record_error(
'ERROR: Would have deleted all mortgages for ' + institution_code +
', check logs', logger, themortgagemeter_db.db_connection,
themortgagemeter_db.cursor)
exit()
return
def delete_mortgages_not_current(institution_code,date,forcedelete,logger):
logger = logging.getLogger('retrieve')
logger.info('In delete_mortgages_not_current')
themortgagemeter_db.cursor.execute(sql_count_jrnl_institution_there,(institution_code,))
row = themortgagemeter_db.cursor.fetchone()
count = int(row[0])
deletecount = 0
logger.info('There are %s mortgages currently',count)
themortgagemeter_db.cursor.execute(sql_get_mortgages_not_retrieved_on_date,(institution_code,date))
for row in themortgagemeter_db.cursor.fetchall():
mortgage_id = row[0]
logger.info('Deleting current mortgage: %s %s %s', institution_code, date, mortgage_id)
themortgagemeter_db.run_sql(sql_update_mortgage_jrnl_delete,(date, mortgage_id))
deletecount += 1
main.update_changes(True,institution_code,logger)
logger.info('%s mortgages deleted',(int(deletecount)))
if count > 0 and deletecount == count and forcedelete == False:
themortgagemeter_utils.record_error('ERROR: Would have deleted all mortgages for ' + institution_code + ', check logs',logger,themortgagemeter_db.db_connection,themortgagemeter_db.cursor)
exit()
return
def record_error(s,cursor=None):
logger = logging.getLogger('retrieve')
if cursor == None:
cursor = db_connection.cursor()
themortgagemeter_utils.record_error(s,logger,db_connection,cursor)
def record_error(s, cursor=None):
logger = logging.getLogger('retrieve')
if cursor == None:
cursor = db_connection.cursor()
themortgagemeter_utils.record_error(s, logger, db_connection, cursor)
