def run_nris_etl(): current_app.logger.info('Starting ETL process') # Initiate Oracle ETL try: clean_nris_xml_import() import_nris_xml() current_app.logger.info('XML Import completed') # TODO: Insert update into status table clean_nris_etl_data() etl_nris_data() current_app.logger.info('NRIS ETL Completed!') except cx_Oracle.DatabaseError as e: current_app.logger.error("Error establishing connection to NRIS database: " + str(e)) except Exception as e: current_app.logger.error("Unexpected error with NRIS XML import: " + str(e))
def import_nris_raw_data(): print("Importing Raw Data from NRIS...") import_nris_xml() print("Import complete")