我正在嘗試將字典中的數(shù)據(jù)插入數(shù)據(jù)庫。我想遍歷值并根據(jù)數(shù)據(jù)類型對它們進行相應(yīng)的格式化。這是我正在使用的代碼的片段:def _db_inserts(dbinfo): try: rows = dbinfo['datarows'] for row in rows: field_names = ",".join(["'{0}'".format(x) for x in row.keys()]) value_list = row.values() for pos, value in enumerate(value_list): if isinstance(value, str): value_list[pos] = "'{0}'".format(value) elif isinstance(value, datetime): value_list[pos] = "'{0}'".format(value.strftime('%Y-%m-%d')) values = ",".join(value_list) sql = "INSERT INTO table_foobar ({0}) VALUES ({1})".format(field_names, values) except Exception as e: print 'BARFED with msg:',e當我使用一些示例數(shù)據(jù)運行算法(見下文)時,出現(xiàn)錯誤:TypeError:序列項0:預期的字符串,找到的int出現(xiàn)上述錯誤的value_list數(shù)據(jù)示例如下:value_list = [377, -99999, -99999, 'f', -99999, -99999, -99999, 1108.0999999999999, 0, 'f', -99999, 0, 'f', -99999, 'f', -99999, 1108.0999999999999, -99999, 'f', -99999, 'f', -99999, 'f', 'f', 0, 1108.0999999999999, -99999, -99999, 'f', 'f', 'f', -99999, 'f', '1984-04-02', -99999, 'f', -99999, 'f', 1108.0999999999999] 我究竟做錯了什么?
3 回答

胡說叔叔
TA貢獻1804條經(jīng)驗 獲得超8個贊
更換
values = ",".join(value_list)
與
values = ','.join([str(i) for i in value_list])
要么
values = ','.join(str(value_list)[1:-1])
添加回答
舉報
0/150
提交
取消