sqlite-utils-litecli


Namesqlite-utils-litecli JSON
Version 0.1.1 PyPI version JSON
download
home_page
SummaryInteractive shell using litecli
upload_time2023-07-26 21:36:41
maintainer
docs_urlNone
authorSimon Willison
requires_python
licenseApache-2.0
keywords
VCS
bugtrack_url
requirements No requirements were recorded.
Travis-CI No Travis.
coveralls test coverage No coveralls.
            # sqlite-utils-litecli

[![PyPI](https://img.shields.io/pypi/v/sqlite-utils-litecli.svg)](https://pypi.org/project/sqlite-utils-litecli/)
[![Changelog](https://img.shields.io/github/v/release/simonw/sqlite-utils-litecli?include_prereleases&label=changelog)](https://github.com/simonw/sqlite-utils-litecli/releases)
[![Tests](https://github.com/simonw/sqlite-utils-litecli/workflows/Test/badge.svg)](https://github.com/simonw/sqlite-utils-litecli/actions?query=workflow%3ATest)
[![License](https://img.shields.io/badge/license-Apache%202.0-blue.svg)](https://github.com/simonw/sqlite-utils-litecli/blob/main/LICENSE)

Interactive shell for [sqlite-utils](https://sqlite-utils.datasette.io/) using [litecli](https://github.com/dbcli/litecli).

## Installation

Install this plugin in the same environment as `sqlite-utils`.
```bash
sqlite-utils install sqlite-utils-litecli
```

## Usage

Start running the shell like this:
```bash
sqlite-utils litecli data.db
```
This will start a `litecli` interactive shell session.

Custom SQL functions provided by other plugins will be available in the shell.

<img src="https://raw.githubusercontent.com/simonw/sqlite-utils-litecli/main/screenshot.jpg" width="483" height="474" alt="Screenshot showing the plugin in action - it includes autocomplete of SQLite table names">

## Development

To set up this plugin locally, first checkout the code. Then create a new virtual environment:
```bash
cd sqlite-utils-litecli
python3 -m venv venv
source venv/bin/activate
```
Now install the dependencies and test dependencies:
```bash
pip install -e '.[test]'
```
To run the tests:
```bash
pytest
```

            

Raw data

            {
    "_id": null,
    "home_page": "",
    "name": "sqlite-utils-litecli",
    "maintainer": "",
    "docs_url": null,
    "requires_python": "",
    "maintainer_email": "",
    "keywords": "",
    "author": "Simon Willison",
    "author_email": "",
    "download_url": "https://files.pythonhosted.org/packages/72/a3/551e2d9090e69b8aa95e43ca44f8407372bc3509c6750b91707aa9e59d07/sqlite-utils-litecli-0.1.1.tar.gz",
    "platform": null,
    "description": "# sqlite-utils-litecli\n\n[![PyPI](https://img.shields.io/pypi/v/sqlite-utils-litecli.svg)](https://pypi.org/project/sqlite-utils-litecli/)\n[![Changelog](https://img.shields.io/github/v/release/simonw/sqlite-utils-litecli?include_prereleases&label=changelog)](https://github.com/simonw/sqlite-utils-litecli/releases)\n[![Tests](https://github.com/simonw/sqlite-utils-litecli/workflows/Test/badge.svg)](https://github.com/simonw/sqlite-utils-litecli/actions?query=workflow%3ATest)\n[![License](https://img.shields.io/badge/license-Apache%202.0-blue.svg)](https://github.com/simonw/sqlite-utils-litecli/blob/main/LICENSE)\n\nInteractive shell for [sqlite-utils](https://sqlite-utils.datasette.io/) using [litecli](https://github.com/dbcli/litecli).\n\n## Installation\n\nInstall this plugin in the same environment as `sqlite-utils`.\n```bash\nsqlite-utils install sqlite-utils-litecli\n```\n\n## Usage\n\nStart running the shell like this:\n```bash\nsqlite-utils litecli data.db\n```\nThis will start a `litecli` interactive shell session.\n\nCustom SQL functions provided by other plugins will be available in the shell.\n\n<img src=\"https://raw.githubusercontent.com/simonw/sqlite-utils-litecli/main/screenshot.jpg\" width=\"483\" height=\"474\" alt=\"Screenshot showing the plugin in action - it includes autocomplete of SQLite table names\">\n\n## Development\n\nTo set up this plugin locally, first checkout the code. Then create a new virtual environment:\n```bash\ncd sqlite-utils-litecli\npython3 -m venv venv\nsource venv/bin/activate\n```\nNow install the dependencies and test dependencies:\n```bash\npip install -e '.[test]'\n```\nTo run the tests:\n```bash\npytest\n```\n",
    "bugtrack_url": null,
    "license": "Apache-2.0",
    "summary": "Interactive shell using litecli",
    "version": "0.1.1",
    "project_urls": {
        "CI": "https://github.com/simonw/sqlite-utils-litecli/actions",
        "Changelog": "https://github.com/simonw/sqlite-utils-litecli/releases",
        "Homepage": "https://github.com/simonw/sqlite-utils-litecli",
        "Issues": "https://github.com/simonw/sqlite-utils-litecli/issues"
    },
    "split_keywords": [],
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "blake2b_256": "f370242814fa0fc9b8003fa62084b96523a11e3effd9be5e43b1be3f8cb78a91",
                "md5": "056333988a974e2796107ecb9365be2d",
                "sha256": "6ceb77db87b4e17e764daab58f3409fd0cfa995daec88cc3ad3b05de2bfd0cb8"
            },
            "downloads": -1,
            "filename": "sqlite_utils_litecli-0.1.1-py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "056333988a974e2796107ecb9365be2d",
            "packagetype": "bdist_wheel",
            "python_version": "py3",
            "requires_python": null,
            "size": 6811,
            "upload_time": "2023-07-26T21:36:39",
            "upload_time_iso_8601": "2023-07-26T21:36:39.935095Z",
            "url": "https://files.pythonhosted.org/packages/f3/70/242814fa0fc9b8003fa62084b96523a11e3effd9be5e43b1be3f8cb78a91/sqlite_utils_litecli-0.1.1-py3-none-any.whl",
            "yanked": false,
            "yanked_reason": null
        },
        {
            "comment_text": "",
            "digests": {
                "blake2b_256": "72a3551e2d9090e69b8aa95e43ca44f8407372bc3509c6750b91707aa9e59d07",
                "md5": "4b038e421ca9ecf5b2d372ddd194a211",
                "sha256": "39ec7d8548472a2176fc7cd0b2a799a09d1e934eea4c5bf4171b87dfbd6f35be"
            },
            "downloads": -1,
            "filename": "sqlite-utils-litecli-0.1.1.tar.gz",
            "has_sig": false,
            "md5_digest": "4b038e421ca9ecf5b2d372ddd194a211",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 6316,
            "upload_time": "2023-07-26T21:36:41",
            "upload_time_iso_8601": "2023-07-26T21:36:41.318371Z",
            "url": "https://files.pythonhosted.org/packages/72/a3/551e2d9090e69b8aa95e43ca44f8407372bc3509c6750b91707aa9e59d07/sqlite-utils-litecli-0.1.1.tar.gz",
            "yanked": false,
            "yanked_reason": null
        }
    ],
    "upload_time": "2023-07-26 21:36:41",
    "github": true,
    "gitlab": false,
    "bitbucket": false,
    "codeberg": false,
    "github_user": "simonw",
    "github_project": "sqlite-utils-litecli",
    "travis_ci": false,
    "coveralls": false,
    "github_actions": true,
    "lcname": "sqlite-utils-litecli"
}
        
Elapsed time: 0.31268s