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';"
(note filedata is loaded into a table called "csv").
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.2.0.tar.gz
(4.2 kB
view details)
Built Distribution
File details
Details for the file cqlite-0.2.0.tar.gz
.
File metadata
- Download URL: cqlite-0.2.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 | 692782cf6d673811548a8fe05bedc599051aa67584283b0fa858c1a8c662a194 |
|
MD5 | fff6c2d68b48c4007ae29704e6bc3026 |
|
BLAKE2b-256 | bce04fdc0264f1521c80062860f649095164a503224c00d1eeba8f33420618a6 |
File details
Details for the file cqlite-0.2.0-py3-none-any.whl
.
File metadata
- Download URL: cqlite-0.2.0-py3-none-any.whl
- Upload date:
- Size: 4.6 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 | f067fdff4a9e1a7cbe4986082b68dfe41de99958eb0840776b4d3d8e159b9b4e |
|
MD5 | a9f5edc5a42323ae3fbdb12585da185a |
|
BLAKE2b-256 | c1b8afae9385a546c0aedbdbb634af6ada721b004e445d0bc5e310864d57f218 |