Skip to main content

SQLITE3 CLI wrapper build on python.

Project description

🍥 aoi

A simple python based sqlite3 CLI.

$python -m pip install aoi

Usage

$aoi [-c "path to connect"]
# if the above fails try executing using full python path. ( read note below image. )
$python -m aoi [-c "path to connect"]

using the -c/--connect option will connect the application to the provided db file path.

If no option is provided, :memory: ( in memory database ) will be used.

Additional Features

Apart from normal sqlite queries you can run the following commands within the CLI:

:h/:help: Get help for commands.

:q/:quit: Exit the CLI.

:r/:recent [amount=5]: Show last [amount=5] queries.

:t/:tables: Shows the tables inside the database

NOTE

The aoi command may fail if the executeable's path wasn't added to the terminal's/system's PATH, however running the library as a module ( python -m aoi ) will always work as long as python is added to path.


Installation

  • Requires Python (3.8 or later)

Installing aoi in your environment using pip, poetry or any favourable package manager

# pip
$pip install aoi # from pypi
$python -m pip install git+https://github.com/sarthhh/aoi.git # from source
# poetry
$poetry add aoi # from pypi
$poetry add git+https://github.com/sarthhh/aoi.git # from source

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

aoi-0.1.2.tar.gz (5.4 kB view details)

Uploaded Source

Built Distribution

aoi-0.1.2-py3-none-any.whl (6.4 kB view details)

Uploaded Python 3

File details

Details for the file aoi-0.1.2.tar.gz.

File metadata

  • Download URL: aoi-0.1.2.tar.gz
  • Upload date:
  • Size: 5.4 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: poetry/1.3.1 CPython/3.10.8 Linux/6.0.8-arch1-1

File hashes

Hashes for aoi-0.1.2.tar.gz
Algorithm Hash digest
SHA256 356b0b37a8377105f929fa053f3a25878ca61bbeb928c047c4f9644217a62f1a
MD5 bb6317d0e0337a52f810d386cd6bccd2
BLAKE2b-256 515d8506dea4020012e82d8e3aa5eb56d1d9ed88427953133d9a53bdc3b7cb9b

See more details on using hashes here.

File details

Details for the file aoi-0.1.2-py3-none-any.whl.

File metadata

  • Download URL: aoi-0.1.2-py3-none-any.whl
  • Upload date:
  • Size: 6.4 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: poetry/1.3.1 CPython/3.10.8 Linux/6.0.8-arch1-1

File hashes

Hashes for aoi-0.1.2-py3-none-any.whl
Algorithm Hash digest
SHA256 6daf019d3fd027b5dc0209dea35f6e6ccda045813ff384c0c5c6cf2ff9c85b32
MD5 8001ff3c2446b45ac12064ea556b1c90
BLAKE2b-256 18051f214e61d203601c008712dbc0a443c3d951ba55744fc9009edc82040c54

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