def insert(self, data): db = DB() sql = "select count(*) from sgba_ods_wb_hl where hl_day = '" + data[ 0] + "' and hl_code='USD'" db.execute(sql) results = db.fetchone() if results[0] == 0: hl_id = time.strftime("%Y%m%d%H%M%S", time.localtime()) + str( random.randint(100000, 999999)) sql = "INSERT INTO SGBA_ODS_WB_hl(HL_ID,HL_DAY,HL_CODE,HL_NAME,HL_DATA) VALUES(" + hl_id + "," + data[ 0] + ",'USD','美元汇率中间价'," + data[1] + ")" db.execute(sql) db.commit() sql = "select count(*) from sgba_ods_wb_hl where hl_day = '" + data[ 0] + "' and hl_code='EUR'" db.execute(sql) results = db.fetchone() if results[0] == 0: hl_id = time.strftime("%Y%m%d%H%M%S", time.localtime()) + str( random.randint(100000, 999999)) sql = "INSERT INTO SGBA_ODS_WB_hl(HL_ID,HL_DAY,HL_CODE,HL_NAME,HL_DATA) VALUES(" + hl_id + "," + data[ 0] + ",'EUR','欧元汇率中间价'," + data[2] + ")" db.execute(sql) db.commit() db.close()
def insert(self, code, name, data): db = DB() sql = "select count(*) as cnt from sgba_ods_wb_kpi where kpi_month = '" + data[ 'date'] + "' and kpi_code='" + code + "'" db.execute(sql) results = db.fetchone() if results[0] == 0: kpi_id = time.strftime("%Y%m%d%H%M%S", time.localtime()) + str( random.randint(100000, 999999)) sql = "INSERT INTO SGBA_ODS_WB_KPI(kpi_id,KPI_MONTH,KPI_CODE,KPI_NAME,KPI_DATA) VALUES('" + kpi_id + "','" + data[ 'date'] + "','" + code + "','" + name + "'," + data[ 'strdata'] + ")" db.execute(sql) db.commit() db.close()
def insert(self, datas): j = len(datas) for i in range(0, j - 1): data=datas[i].split(",") db = DB() s_month=data[0][:7].replace("-","") sql = "select count(*) from sgba_ods_wb_kpi where kpi_month = '"+s_month+"' and kpi_code='M2'" db.execute(sql) results = db.fetchone() if results[0] == 0: kpi_id = time.strftime("%Y%m%d%H%M%S", time.localtime()) + str(random.randint(100000,999999)) sql = "INSERT INTO SGBA_ODS_WB_KPI(kpi_id,KPI_MONTH,KPI_CODE,KPI_NAME,KPI_DATA,KPI_TB,KPI_HB) VALUES("+kpi_id +"," + s_month +",'M2','货币和准货币(M2)',"+ data[1] +","+ data[2] +","+ data[3] +")" db.execute(sql) db.commit() else: db.close() break sql = "select count(*) from sgba_ods_wb_kpi where kpi_month = '"+s_month+"' and kpi_code='M1'" db.execute(sql) results = db.fetchone() if results[0] == 0: kpi_id = time.strftime("%Y%m%d%H%M%S", time.localtime()) + str(random.randint(100000,999999)) sql = "INSERT INTO SGBA_ODS_WB_KPI(kpi_id,KPI_MONTH,KPI_CODE,KPI_NAME,KPI_DATA,KPI_TB,KPI_HB) VALUES("+kpi_id +"," + s_month +",'M1','货币(M1)',"+ data[4] +","+ data[5] +","+ data[6] +")" db.execute(sql) db.commit() sql = "select count(*) from sgba_ods_wb_kpi where kpi_month = '"+s_month+"' and kpi_code='M0'" db.execute(sql) results = db.fetchone() if results[0] == 0: kpi_id = time.strftime("%Y%m%d%H%M%S", time.localtime()) + str(random.randint(100000,999999)) sql = "INSERT INTO SGBA_ODS_WB_KPI(kpi_id,KPI_MONTH,KPI_CODE,KPI_NAME,KPI_DATA,KPI_TB,KPI_HB) VALUES("+kpi_id +"," + s_month +",'M0','流通中的现金(M0)',"+ data[7] +","+ data[8] +","+ data[9] +")" db.execute(sql) db.commit() db.close()
def insert(self, data): db = DB() sql = "select count(*) from sgba_ods_wb_hl where hl_day = '" + str( data[0]) + "' and hl_code='shibor'" db.execute(sql) results = db.fetchone() if results[0] == 0: hl_id = time.strftime("%Y%m%d%H%M%S", time.localtime()) + str( random.randint(100000, 999999)) db.execute( "insert into SGBA_ODS_WB_HL(HL_ID,HL_DAY,HL_CODE,HL_NAME,HL_DATA) values('" + hl_id + "','" + str(data[0]) + "','shibor','隔夜利率(%) o/n'," + data[1] + ")") db.commit() db.close()