python - 将行作为循环的一部分添加到列表中 Python

Question

我正在从 Oracle 数据库获取数据。一些数据采用 clob 格式(第 8 列)，因此我必须循环遍历每一行并进行转换。我想追加转换后的每一行以再次形成原始表。给我带来麻烦的行是 Complete_data = [Complete_data,fixed_data]

import cx_Oracle
# USE THIS CONNECTION STRING FOR PRODUCTION
production_username = ''
production_password = ''

con_string = '%s/%s@host' % (production_username, production_password)
con = cx_Oracle.connect(con_string)
cursor = con.cursor()
querystring = ("Select * from SalesDatabase")
cursor.execute(querystring)
data = cursor.fetchall()

#loop through and convert clobs to readable content
for currentrow in data:
    Product = currentrow[8].read()
    fixed_data = ([currentrow[0], currentrow[1], currentrow[2], currentrow[3], currentrow[4], currentrow[5], currentrow[6], currentrow[7], Product, currentrow[9]])
    Complete_data = [Complete_data, fixed_data]

 con.close()
 print Complete_data

Answer 1

填充列表的传统方法是首先创建一个空列表，然后在循环中追加项到其中。

Complete_data = []
for currentrow in data:
    Product = currentrow[8].read()
    fixed_data = ([currentrow[0], currentrow[1], currentrow[2], currentrow[3], currentrow[4], currentrow[5], currentrow[6], currentrow[7], Product, currentrow[9]])
    Complete_data.append(fixed_data)