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
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
Built Distribution
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
Algorithm | Hash digest | |
---|---|---|
SHA256 | 356b0b37a8377105f929fa053f3a25878ca61bbeb928c047c4f9644217a62f1a |
|
MD5 | bb6317d0e0337a52f810d386cd6bccd2 |
|
BLAKE2b-256 | 515d8506dea4020012e82d8e3aa5eb56d1d9ed88427953133d9a53bdc3b7cb9b |
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
Algorithm | Hash digest | |
---|---|---|
SHA256 | 6daf019d3fd027b5dc0209dea35f6e6ccda045813ff384c0c5c6cf2ff9c85b32 |
|
MD5 | 8001ff3c2446b45ac12064ea556b1c90 |
|
BLAKE2b-256 | 18051f214e61d203601c008712dbc0a443c3d951ba55744fc9009edc82040c54 |