Forum Archive

'''conn = sqlite3.connect('Logbook.db')
c = conn.cursor()
with open('backup.csv', 'w') as csvfile:
spamwriter = csv.writer(csvfile, delimiter=',',
quotechar=' ', quoting=csv.QUOTE_MINIMAL)
for row in c.execute('SELECT * FROM logbook ORDER BY ID'):
savedline = row
spamwriter.writerow(savedline)'''

I don't know why but this saves a CSV file just like I want only every line it takes out of the database it saves it double in the CSV file. Can anyone help? I am not sure what It am doing wrong.

@RomSpy Since this has nothing to do with Pythonista itself, why don't you try asking on StackOverflow? That's a much larger community, and you're more likely to get an answer there ;)

I am writing the app in pythonista so I wasn't sure if it was related.

Disregard I figured out the problem.