Untitled

mail@pastecode.io avatar
unknown
plain_text
2 years ago
722 B
2
Indexable
Never
   # process notification --> metabase >< middleware
    def process_notification(self):
        logging.info('Start Process Notification')
        conf = configuration.config()
        conn = configuration.connection_metabase_db(conf)
        cr = conn.cursor()
        start_date = datetime(2021, 11, 1)
        #PREPARE_NOTIFICATION = os.environ['PREPARE_NOTIFICATION']
        #self.execute_sql_file(BASE_DIR + PREPARE_NOTIFICATION, cr)
        cr.execute("select insert_into_table_temporary('usmh_middleware', '5432', '10.130.0.2', 'odoo', 'USMHOdoostore2021', %s);", (start_date.strftime('%Y-%m-%d')))
        conn.commit()
        cr.close()
        conn.close()
        logging.info('Finish Process Notification')