Accepts an sql database and converts all tables to separate csv files.

sql_to_csv.py

#! /usr/bin/env python3
"""sql_to_csv.py
Accepts an sql database and converts all tables to separate csv files.
"""

import sqlite3
import csv
import sys

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

with conn:
    cmd = '''select name from sqlite_master where type="table";'''
    table_names = conn.execute(cmd).fetchall()

    for table_name in table_names:
        cmd = '''select * from {};'''.format(table_name[0])
        csv_out = conn.execute(cmd).fetchall()
        with open(table_name[0] + '.csv', 'w') as w:
            writer = csv.writer(w)
            writer.writerows(csv_out)