python sequence item 0_python – TypeError：sequence item 0：expected string,int found

我试图将数据从字典插入数据库。我想迭代这些值并相应地格式化它们，具体取决于数据类型。这里是我使用的代码片段：

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

当我使用一些示例数据(见下面)运行算法时，我得到错误：

TypeError: sequence item 0: expected string, int found

给出以上错误的value_list数据的示例是：

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]

我究竟做错了什么？