csv-to-sqlite

csv-to-sqlite

This is a simple, datatype-guessing script that takes CSV files as input and copies their contents into a SQLite database.
(Column names are taken from the headers (first row) in the csv file.)
Intended for Python 3. (I know it did run on Py2 as some people tried, but I haven't tested it.)

Links

• Source on GitHub
• PyPI page
• Introductory blog post with basic intro + a how-to
• Other related blog posts

Overview

Installs via

 pip install csv-to-sqlite

To find out more, run

 csv-to-sqlite --help

If you've installed the package as a dependency for your own script, you can use it like this:

import csv_to_sqlite 

# all the usual options are supported
options = csv_to_sqlite.CsvOptions(typing_style="full", encoding="windows-1250") 
input_files = ["abilities.csv", "moves.csv"] # pass in a list of CSV files
csv_to_sqlite.write_csv(input_files, "output.sqlite", options)