Query a CSV file from the commandline
Project description
cqlite
Query a CSV file from the commandline
Installation
pipx install cqlite
Usage
In memory query:
cqlite <csv_file> <query>
e.g.
cqlite fakedata.csv "SELECT * FROM csv WHERE name LIKE '%Tommy% AND date_of_birth < '1980-01-01';"
Save `<csv_file>.csv as a SQLite database (<csv_file>.db):
cqlite <csv_file> --persist
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 Distribution
cqlite-0.1.0.tar.gz
(4.2 kB
view details)
Built Distribution
File details
Details for the file cqlite-0.1.0.tar.gz
.
File metadata
- Download URL: cqlite-0.1.0.tar.gz
- Upload date:
- Size: 4.2 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/4.0.2 CPython/3.10.1
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | 0821dd01bc488fbd90af6ce384f370ce545df1c0ba522eb70af96a9e32e3d084 |
|
MD5 | 3aa1808fc89eb1771587f696364ffe22 |
|
BLAKE2b-256 | dba009886b688d2218f6fb0baa3dadccd383779433a8499ae93908d8639963f7 |
File details
Details for the file cqlite-0.1.0-py3-none-any.whl
.
File metadata
- Download URL: cqlite-0.1.0-py3-none-any.whl
- Upload date:
- Size: 4.5 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/4.0.2 CPython/3.10.1
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | b086f5a345adacfd4e6f0078767b40ad8636d48997ce164360275fe3515c491a |
|
MD5 | 5e0c756047ead195d504c31778bc5632 |
|
BLAKE2b-256 | c429bc7b516b7a9388dae46b2d9b7c850a8c8256aa5790902051a67da78716da |