FilesExpand file tree

 master

/

24_sql2csv.py

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

executable file

·

17 lines (13 loc) · 360 Bytes

 master

/

24_sql2csv.py

Copy path

Top

File metadata and controls

• Code
• Blame

executable file

·

17 lines (13 loc) · 360 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

import sys

import csv

import sqlite3

if len(sys.argv) < 3:

print("Use: {0} DATABASE_NAME TABLE_NAME".format(sys.argv[0]))

exit()

conn = sqlite3.connect(sys.argv[1])

cur = conn.cursor()

data = cur.execute("SELECT * FROM {0}".format(sys.argv[2]))

with open('output.csv', 'wb') as f:

writer = csv.writer(f)

writer.writerows(data)

conn.close()