1
415829566 OP 附上代码:
def insertOracleTable(self,table_name,datas=[]): self.conndb() #insert_sql="insert into "+table_name+" values(:1,:2,:3,:4,:5,:6,:7)" print(insert_sql) print(datas) self.cursor.prepare(insert_sql) self.cursor.executemany(None,datas) self.commitdb() self.closedb() |
2
415829566 OP 附上数据:
[('数仓 1 节点', 'DW_TBL', 1214, 1136.97, 77.03, 93.65, datetime.datetime(2018, 5, 31, 10, 26, 42)), ('数仓 2 节点', 'TBS_DW_ODS_DAT', 154, 139.88, 14.12, 90.83, datetime.datetime(2018, 5, 31, 10, 26, 42))] |