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
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
Filter files by name, interpreter, ABI, and platform.
If you're not sure about the file name format, learn more about wheel file names.
Copy a direct link to the current filters
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
|
