How do I write data to a file that I have taken from an SQL database in Python? (sqlite3)

Question

c.execute("SELECT * FROM Student WHERE Forename =:forename AND Surname =:surname AND YearGroup =:yeargroup AND FormNumber =:formnumber BETWEEN :startdate AND :enddate", {"forename": forename, "surname": surname, "yeargroup": yeargroup, "formnumber": formnumber, "startdate": startdate, "enddate": enddate})

studentRequest = c.fetchall()
records = studentRequest

#write to file

f = open('Student Report', 'w')
f.write(name)
f.write(' Form Number: ' + (yeargroup +'/'+ formnumber))
f.write(str(records))
f.close()

This is my code but it doesn't seem to write the data from the database to the file. The name, Forum Number etc is written though.

Can anyone help?

try printing out 'records' to the terminal. I'm guessing it is a list or a tuple so you would need to access individual records by iterating through it. for item in record... — Cam
– Cam, Commented Feb 18, 2014 at 16:10

Community · Accepted Answer · 2017-05-23 12:28:43Z

1

Does your output have "[]" in it? It sounds like your query doesn't find any matches.

If this isn't so, prepare a complete, runnable example showing the problem.

edited May 23, 2017 at 12:28

CommunityBot

11 silver badge

answered Feb 18, 2014 at 16:09

Mike Graham

77.2k16 gold badges105 silver badges131 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Jambofun Over a year ago

Yes it does return a [] when attempted. Maybe this is a problem with inputting data to the database then?

wflynny Over a year ago

I think your problem is your query syntax. Try starting with a small piece of it and see if that returns anything. Then build it from there.

Mike Graham Over a year ago

@Jambofun, Yes, or your select query isn't the one you really want. A very common error people make when adding data to a database is forgetting to commit.

Jambofun Over a year ago

I think that I may of found the issue thank you Bill. However, i'm learning as I'm programming so am unsure of how to tackle it. I believe its to do with the 'BETWEEN' in my query as I have not related it in any way to the Date column in my table. How do I do this?

Mike Graham Over a year ago

Perhaps the query you're looking for is more like

SELECT * FROM Student WHERE Forename =:forename AND Surname =:surname AND YearGroup =:yeargroup AND FormNumber =:formnumber AND Date BETWEEN :startdate AND :enddate

?

|

Collectives™ on Stack Overflow

How do I write data to a file that I have taken from an SQL database in Python? (sqlite3)

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related