sqlite2csv

sqlite2csv

Export data from a SQLite database to CSV files.

Installation

You can install this library using PyPI:

pip install sqlite2csv

Usage

Retrieve all tables

from sqlite2csv import SqliteToCSV

database = "sqlite:///db/test.db"
dest_dir = ".output"

app = SqliteToCSV(database=database, dest_dir=dest_dir)
app.export()

Retrieve an arbitrary tables

from sqlite2csv import SqliteToCSV

database = "sqlite:///db/test.db"
dest_dir = ".output"
table_names = ["users", "projects"]

app = SqliteToCSV(database=database, dest_dir=dest_dir, table_names=table_names)
app.export()

License

This project is licensed under the MIT License - see the LICENSE file for details.