Skip to main content

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


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)

Uploaded Source

Built Distribution

cqlite-0.1.0-py3-none-any.whl (4.5 kB view details)

Uploaded Python 3

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

Hashes for cqlite-0.1.0.tar.gz
Algorithm Hash digest
SHA256 0821dd01bc488fbd90af6ce384f370ce545df1c0ba522eb70af96a9e32e3d084
MD5 3aa1808fc89eb1771587f696364ffe22
BLAKE2b-256 dba009886b688d2218f6fb0baa3dadccd383779433a8499ae93908d8639963f7

See more details on using hashes here.

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

Hashes for cqlite-0.1.0-py3-none-any.whl
Algorithm Hash digest
SHA256 b086f5a345adacfd4e6f0078767b40ad8636d48997ce164360275fe3515c491a
MD5 5e0c756047ead195d504c31778bc5632
BLAKE2b-256 c429bc7b516b7a9388dae46b2d9b7c850a8c8256aa5790902051a67da78716da

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