Skip to main content

Export data from a SQLite database to CSV files.

Project description

sqlite-to-csv

PyPI version build License

Export data from a SQLite database to CSV files.

Installation

You can install this library using PyPI:

pip install sqlite-to-csv

Usage

Retrieve all tables

from sqlite_to_csv 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 sqlite_to_csv 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.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

sqlite2csv-0.1.0.tar.gz (6.7 MB view details)

Uploaded Source

Built Distribution

sqlite2csv-0.1.0-py3-none-any.whl (6.2 kB view details)

Uploaded Python 3

File details

Details for the file sqlite2csv-0.1.0.tar.gz.

File metadata

  • Download URL: sqlite2csv-0.1.0.tar.gz
  • Upload date:
  • Size: 6.7 MB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/4.0.2 CPython/3.12.2

File hashes

Hashes for sqlite2csv-0.1.0.tar.gz
Algorithm Hash digest
SHA256 0263685d41c256ffe8dd9847548c9036493dd6a81d8aba3307b70d75bae734c9
MD5 9f8684f103e9a8e50b3b001f5da4ed84
BLAKE2b-256 251a1d9fe9aa0927fbbcfa2df1deb09ee49fe61d35e2c98f5f42306888755f28

See more details on using hashes here.

File details

Details for the file sqlite2csv-0.1.0-py3-none-any.whl.

File metadata

  • Download URL: sqlite2csv-0.1.0-py3-none-any.whl
  • Upload date:
  • Size: 6.2 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/4.0.2 CPython/3.12.2

File hashes

Hashes for sqlite2csv-0.1.0-py3-none-any.whl
Algorithm Hash digest
SHA256 ec7f750d2846efbaf1c3b9685a7ed7a9216bf5b7b5c79abdc8914a3eaf5fdd62
MD5 1e880c9ae340db941cb7c9aa415ffa8f
BLAKE2b-256 7a43b7501470c00ba95cd0e0f14c8ca7eba79cadb6d86b72ed833f94b4d43e3e

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page