sqlcli

A SQL IDE in your terminal

Using

Python package: to add and install this package as a dependency of your project, run poetry add sqlcli.

Python CLI: to view this app's CLI commands once it's installed, run sqlcli --help.

Contributing

Prerequisites

1. Set up Git to use SSH

Generate an SSH key and add the SSH key to your GitHub account.

Configure SSH to automatically load your SSH keys:

cat << EOF >> ~/.ssh/config
Host *
  AddKeysToAgent yes
  IgnoreUnknown UseKeychain
  UseKeychain yes
EOF

2. Install Docker

Install Docker Desktop.
- Enable Use Docker Compose V2 in Docker Desktop's preferences window.
- Linux only:
  - Configure Docker to use the BuildKit build system. On macOS and Windows, BuildKit is enabled by default in Docker Desktop.
  - Export your user's user id and group id so that files created in the Dev Container are owned by your user:
```
cat << EOF >> ~/.bashrc
export UID=$(id --user)
export GID=$(id --group)
EOF
```

3. Install VS Code or PyCharm

Install VS Code and VS Code's Dev Containers extension. Alternatively, install PyCharm.
Optional: install a Nerd Font such as FiraCode Nerd Font and configure VS Code or configure PyCharm to use it.

Development environments

The following development environments are supported:

⭐️ GitHub Codespaces: click on Code and select Create codespace to start a Dev Container with GitHub Codespaces.
⭐️ Dev Container (with container volume): click on Open in Dev Containers to clone this repository in a container volume and create a Dev Container with VS Code.
Dev Container: clone this repository, open it with VS Code, and run Ctrl/⌘ + ⇧ + P → Dev Containers: Reopen in Container.
PyCharm: clone this repository, open it with PyCharm, and configure Docker Compose as a remote interpreter with the dev service.
Terminal: clone this repository, open it with your terminal, and run docker compose up --detach dev to start a Dev Container in the background, and then run docker compose exec dev zsh to open a shell prompt in the Dev Container.

Developing

This project follows the Conventional Commits standard to automate Semantic Versioning and Keep A Changelog with Commitizen.
Run poe from within the development environment to print a list of Poe the Poet tasks available to run on this project.
Run poetry add {package} from within the development environment to install a run time dependency and add it to pyproject.toml and poetry.lock. Add --group test or --group dev to install a CI or development dependency, respectively.
Run poetry update from within the development environment to upgrade all dependencies to the latest versions allowed by pyproject.toml.
Run cz bump to bump the package's version, update the CHANGELOG.md, and create a git tag.

Metadata

Release files for sqlcli.sh 0.1.0

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for sqlcli.sh 0.1.0
File	Size	Uploaded
sqlcli_sh-0.1.0.tar.gz	20.4 kB	Nov 30, 2023	Details

Built distribution (wheel)

Table of built distributions (wheels) for sqlcli.sh 0.1.0
File	Interpreter	ABI	Platform	Reset
sqlcli_sh-0.1.0-py3-none-any.whl 21.5 kB Nov 30, 2023	Python 3	none	any	Details

Total release size: 41.8 kB

Release files / sqlcli_sh-0.1.0.tar.gz

Download URL	sqlcli_sh-0.1.0.tar.gz
Size	20.4 kB
Tags	Source
SHA-256 checksum How to use checksums	`cca3233bcec84919f0c89293123c81d3edbc7977e8e2189272bd376672e78ee1`
BLAKE2b-256 checksum How to use checksums	`90ecfa6a3cdae480e789cfe7be88ea667a609eca7de16e27838f899a978acbe1`
Upload date	Nov 30, 2023
Uploaded using Trusted Publishing? What is trusted publishing?	No
Uploaded via	`poetry/1.7.0 CPython/3.11.6 Darwin/23.1.0`

Release files / sqlcli_sh-0.1.0-py3-none-any.whl

Download URL	sqlcli_sh-0.1.0-py3-none-any.whl
Size	21.5 kB
Tags	Python 3
SHA-256 checksum How to use checksums	`36f6be34d750d8d4ad70a9a7dd79e6dc66655f23dc3da36b18564e435b309dc3`
BLAKE2b-256 checksum How to use checksums	`ec349951144535edb4e9dddc6ab93ffb5a354140a30b1d66078e5f413b4f4607`
Upload date	Nov 30, 2023
Uploaded using Trusted Publishing? What is trusted publishing?	No
Uploaded via	`poetry/1.7.0 CPython/3.11.6 Darwin/23.1.0`

Release history Release notifications | RSS feed

This release

0.1.0 This release

Nov 30, 2023 2 release files

sqlcli.sh 0.1.0