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_tkszs(self, data):
db = DB()
sql = "select count(*) from sgba_ods_wb_hl where hl_day = '" + data[
0] + "' and hl_code='TKSZS'"
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] + ",'TKSZS','62%铁矿石普氏'," + data[1] + ")"
db.execute(sql)
db.commit()
db.close()
def insert(self, data):
db = DB()
dt = datetime.now()
ltime = time.localtime(data['f86'])
datestr = time.strftime("%Y%m%d", ltime)
if datestr != dt.strftime("%Y%m%d"):
pass
GP_ID = time.strftime("%Y%m%d%H%M%S", ltime) + str(
random.randint(100000, 999999))
sql = "delete from SGBA_ODS_WB_GP where gp_day = '" + datestr + "' and gp_code = '" + str(
data['f57']) + "'"
db.execute(sql)
db.commit()
sql = "INSERT INTO SGBA_ODS_WB_GP(GP_ID,GP_DAY,GP_CODE,GP_NAME,GP_ZSZ,GP_ZRSPJ,GP_JRKPJ,GP_JRZGJ,GP_JRZDJ,GP_SSJG) " \
"VALUES('" +GP_ID+"','"+datestr+"','"+ str(data['f57'])+ "','" + str(data['f58']).replace("'","")+ "'," +str(data['f116'])+ "," +str(data['f60'])+ "," +str(data['f46'])+ "," +str(data['f44'])+ "," +str(data['f45'])+ "," +str(data['f43'])+ ")"
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, data):
db = DB()
dt = datetime.now()
datestr = str(data['tradeDate'])
if datestr != dt.strftime('%Y%m%d'):
pass
sql = "delete from SGBA_ODS_WB_QH where qh_day = '" + datestr + "' and qh_code ='" + data[
'indexCode'] + "'"
db.execute(sql)
db.commit()
qh_id = time.strftime("%Y%m%d%H%M%S", time.localtime()) + str(
random.randint(100000, 999999))
sql = "INSERT INTO SGBA_ODS_WB_QH(QH_ID,QH_DAY,QH_CODE,QH_NAME,QH_KP,QH_ZG,QH_ZD,QH_ZX,QH_ZDS,QH_ZDF,QH_SP,QH_JS,QH_ZSP,QH_ZJS) " \
"VALUES("+qh_id +"," +datestr+",'"+ data['indexCode']+"','"+data['indexName']+"',"+data['openPrice']+","+data['highPrice']+","+data['lowPrice']+","+data['lastPrice']+","+data['netChange']+","+data['chgPercent'].replace("%","")+","+data['closePrice'].replace("--","0")+","+data['clearPrice'].replace("--","0")+","+data['lastClose']+","+data['lastClearPrice']+")"
db.execute(sql)
db.commit()
db.close()
def insert(self, data):
db = DB()
dt = datetime.now()
dtstr = dt.strftime('%Y%m%d')
datestr = self.get_date()
if dtstr != datestr :
pass
sql = "delete from SGBA_ODS_WB_QH where qh_day = '"+ datestr+"' and qh_code ='"+data['contractname']+"'"
db.execute(sql)
db.commit()
qh_id = time.strftime("%Y%m%d%H%M%S", time.localtime()) + str(random.randint(100000,999999))
sql = "INSERT INTO SGBA_ODS_WB_QH(QH_ID,QH_DAY,QH_CODE,QH_NAME,QH_KP,QH_ZG,QH_ZD,QH_ZX,QH_ZDS,QH_ZJS) VALUES" \
"("+qh_id +"," +dt.strftime('%Y%m%d')+",'"+ data['contractname']+"','螺纹钢"+data['contractname']+"',"+data['openprice'].replace("--","0")+","+data['highprice'].replace("--","0")+","+data['lowerprice'].replace("--","0")+","+data['lastprice']+","+data['upperdown']+","+data['presettlementprice']+")"
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()