CLI tool for exporting tables or queries from any SQL database to a SQLite file
Project description
db-to-sqlite
CLI tool for exporting tables or queries from any SQL database to a SQLite file.
This is in extremely early stages of development - very much a 0.1.
Usage: db-to-sqlite [OPTIONS] PATH
Run a SQL query against any database and save the results to SQLite.
https://github.com/simonw/db-to-sqlite
Options:
--version Show the version and exit.
--connection TEXT SQLAlchemy connection string [required]
--sql TEXT SQL query to run [required]
--table TEXT Name of SQLite table to save the results [required]
--pk TEXT Optional column to use as a primary key
--help Show this message and exit.
For example, to save the content of the blog_entry
table from a PostgreSQL database to a local file called blog.db
you could do this:
db-to-sqlite blog.db \
--connection="postgresql://localhost/myblog" \
--sql="select * from blog_entry" \
--table=blog_entry \
--pk=id
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distributions
No source distribution files available for this release.See tutorial on generating distribution archives.
Built Distribution
Close
Hashes for db_to_sqlite-0.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | e1807a0683a3ab7aaac4f0e19e2d99759f51f6f2f6cda1906eacda300ecef90c |
|
MD5 | 1ed03fa64ba1e9329e74025d325bd50f |
|
BLAKE2b-256 | 1c42b14789a7b3972931b2dd5652615e3a96b5666c919e7442c406e6ce1eba55 |