m_db.py 文件源码

def insert_data(self,tablename,clmn):
        lenr = len(clmn)
        if lenr == 0:
            print('go')
            return
        lenc = len(clmn[0])
        sqlline =''
        for indr in range(lenr):
            #print(np.array_str(clmn[indr]).replace('[','').replace(']','').replace(' ',','))
            sqlline = np.array_str(clmn[indr]).replace('[','').replace(']','').replace(' ',',')
            sql = 'insert into '+tablename+' VALUES ('+ sqlline+');'
            #print(sql)
            try:
                # print('insert into '+tablename+' VALUES ('+ sqlline+');')
                self.cur.execute(sql)
            except Exception as e:
                print('err:',e)
            sqlline=''
        return