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()