How to export my SQL table as a CSV fie using PYTHON

Question

I have quite a small table, with 5 columns (inlcuding the primary key) and I am trying to export the data into a CSV file

import csv
with DbManager(#MY DATA BASE INFO) as db:
            SQLview = 'SELECT * FROM mytable;'
            db.cursor.execute(SQLview)
            writer = csv.writer(db)
            writer.writerow([ i[0] for i in cursor.description ]) 
            writer.writerows(cursor.fetchall())

However I am getting the error

writer = csv.writer(db)
TypeError: argument 1 must have a "write" method

TIA for any help or if you can point me in the right direction :)

What do you expect csv.writer(db) to do? You want to write to a file, not back to the database. — Alex Hall
– Alex Hall, Commented Aug 19, 2017 at 11:38
@AlexHall I used the documentation and thought that would create the file using the db data? — M.Weiss
– M.Weiss, Commented Aug 19, 2017 at 11:40

PRMoureu · Accepted Answer · 2017-08-19 11:42:36Z

4

You need to open a file to output the data :

with DbManager(#MY DATA BASE INFO) as db:
    SQLview = 'SELECT * FROM mytable;'
    cursor = db.cursor()
    cursor.execute(SQLview)
    with open('output.csv', 'w') as csvfile:
        writer = csv.writer(csvfile)
        writer.writerow([ i[0] for i in cursor.description ]) 
        writer.writerows(cursor.fetchall())

answered Aug 19, 2017 at 11:42

PRMoureu

13.4k6 gold badges46 silver badges52 bronze badges

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

1 Comment

M.Weiss Over a year ago

I will accept your answer in two minutes when the timer allows me :)

Collectives™ on Stack Overflow

How to export my SQL table as a CSV fie using PYTHON

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related