db_firebird.py

import re
import fdb as dr

# get connection
def get_con(data_set_find = ()):        
    con = dr.connect(host=data_set_find[1],
                     user=data_set_find[4],
                     password=data_set_find[5],
                     port=data_set_find[2],
                     database=data_set_find[3])    
    return con

# add curs db
def add_db(data_db = [], curr_code = '', data_set_find = (), type_db = ''):
    try:
        # connect
        with get_con(data_set_find) as con:        
            cursor = con.cursor()            
            # insert data
            for mas in data_db:
                params = (mas[0].strftime("%Y-%m-%d"), curr_code, mas[1])
                cursor.execute(
                    "EXECUTE PROCEDURE " + data_set_find[7] + "('" + params[0] + "','" 
                    + params[1] + "',"+ str(params[2]) + ");")
            con.commit()
    except Exception as err:
        print(type_db + ': ' + re.sub("^\s+|\n|\r|\s+$", '', str(err)))


# load data report
def load_data_report(data_set_find = (), type_db = ''):
    data_report = []
    try:
        # connect
        with get_con(data_set_find) as con:        
            cursor = con.cursor()
            cursor.execute(
                "select CURS_DATE, CURR_CODE, CAST(RATE AS VARCHAR(10)) AS RATE, " + 
                "CAST(AVG_RATE AS VARCHAR(20)) AS AVG_RATE FROM " + data_set_find[8])
            data = cursor.fetchall()
            #            
            data_report.append(["Дата курса", "Код валюти","Курс","Відхилення,%"])
            for mas in data:
                dat = mas[0].strftime("%d.%m.%Y")
                rate = float(mas[2])
                rate_avg = float(mas[3])
                data_report.append([dat, mas[1], rate, rate_avg])                
    except Exception as err:
        print(type_db + ': ' + re.sub("^\s+|\n|\r|\s+$", '', str(err)))
    return data_report