我正在使用python访问sqlite数据库。我正在访问Firefox cookie数据库的副本
我试着遵循jjm在这里给出的建议: http://stackoverflow.com/questions/12325234/python-tuple-indices-must-be-integers-not-str-when-selecting-from-mysql-table
我想把行变量解压成简单的变量名。我不明白什么类型的变量,我得到的行。是数组吗
with con:
cur = con.cursor()
#
cur.execute("SELECT \
name, \
value, \
host, \
datetime((expiry/1000000), 'unixepoch'), \
expiry, \
datetime((lastAccessed/1000000), 'unixepoch'), \
datetime((creationTime/1000000), 'unixepoch') \
FROM moz_cookies \
WHERE baseDomain = 'apple.com' AND name = 's_ppv'")
rows = cur.fetchall()
print ( len(rows) )
for row in rows:
if debug >= 1:
# Indexes are 0 offset.
print ("row is = ")
print (row)
aName, aValue, aHost, aDisplayExpire, aExpire = row
在“aName,aValue,aHost,aDisplayExpire,aExpire=row”上失败 变量debug设置为1。 这是输出
1
row is =
(u's_ppv', u'acs%253A%253Aadf%253A%253Aprofile%253Auser%2520profile%2520%2528en_US%2529%2C78%2C78%2C576%2C', u'.apple.com', u'2015-07-01 01:47:46', 1435715266000000L, u'2015-07-01 01:27:46', u'2015-06-15 16:12:15')
Traceback (most recent call last):
File "./adjust-ASC-Time.bash", line 188, in <module>
aName, aValue, aHost, aDisplayExpire, aExpire = row
ValueError: too many values to unpack
我切掉了向量的末端
aName,aValue,aHost,aDisplayExpire,aExpire=行[:5]
相关问题 更多 >
编程相关推荐