{
    "info": {
        "author": "Marc Abramowitz",
        "author_email": "marc@marc-abramowitz.com",
        "bugtrack_url": null,
        "classifiers": [
            "Intended Audience :: Developers",
            "Natural Language :: English",
            "Programming Language :: Python :: 2",
            "Programming Language :: Python :: 2.6",
            "Programming Language :: Python :: 2.7",
            "Programming Language :: Python :: 3",
            "Programming Language :: Python :: 3.2",
            "Programming Language :: Python :: 3.3",
            "Programming Language :: Python :: 3.4",
            "Topic :: Software Development :: Testing"
        ],
        "description": "sqlalchemy_sql_shell\n====================\n\nUsage\n-----\n\nThe program takes one argument: a SQLAlchemy database URL of the form:\n``dialect+driver://username:password@host:port/database`` (see\n`the SQLAlchemy docs on database URLs\n<http://docs.sqlalchemy.org/en/rel_0_8/core/engines.html#database-urls>`_ for\nmore info). You may need to install additional packages for your database\ndriver of choice (e.g.: mysql-python, psycopg2, pymssql, etc.)\n\nHere's some basic usage::\n\n    $ sqlalchemy_sql_shell\n    usage: sqlalchemy_sql_shell [-h] url\n    sqlalchemy_sql_shell: error: too few arguments\n\n    $ sqlalchemy_sql_shell sqlite:///\n    SQL> CREATE TABLE people ( first_name VARCHAR(128), last_name VARCHAR(128) );\n    SQL> INSERT INTO people VALUES ( 'John', 'Doe' ), ('Mike', 'Smith'), ('Guido', 'van Rossum');\n    result.rowcount = 3\n    SQL> SELECT * FROM people;\n    +------------+------------+\n    | first_name | last_name  |\n    +============+============+\n    | John       | Doe        |\n    | Mike       | Smith      |\n    | Guido      | van Rossum |\n    +------------+------------+\n\nMulti-line queries are supported; A semi-colon signifies the end of the query::\n\n    SQL> SELECT *\n    ...> FROM people\n    ...> ;\n    +------------+------------+\n    | first_name | last_name  |\n    +============+============+\n    | John       | Doe        |\n    | Mike       | Smith      |\n    | Guido      | van Rossum |\n    +------------+------------+\n\nYou can also pipe queries into the command for quick one-liners::\n\n    $ echo \"SELECT 1 + 2;\" | sqlalchemy_sql_shell sqlite:///\n    +-------+\n    | 1 + 2 |\n    +=======+\n    | 3     |\n    +-------+\n\nOr redirect stdin::\n\n    $ cat samples/queries.sql\n    SELECT 1 + 2;\n    SELECT 3 + 4;\n    SELECT 5 + 6;\n\n    $ sqlalchemy_sql_shell sqlite:/// < samples/queries.sql\n    +-------+\n    | 1 + 2 |\n    +=======+\n    | 3     |\n    +-------+\n    +-------+\n    | 3 + 4 |\n    +=======+\n    | 7     |\n    +-------+\n    +-------+\n    | 5 + 6 |\n    +=======+\n    | 11    |\n    +-------+",
        "description_content_type": null,
        "docs_url": null,
        "download_url": "UNKNOWN",
        "downloads": {
            "last_day": -1,
            "last_month": -1,
            "last_week": -1
        },
        "home_page": "https://github.com/msabramo/sqlalchemy_sql_shell",
        "keywords": "database,SQL,SQLAlchemy",
        "license": "MIT",
        "maintainer": null,
        "maintainer_email": null,
        "name": "sqlalchemy_sql_shell",
        "package_url": "https://pypi.org/project/sqlalchemy_sql_shell/",
        "platform": "UNKNOWN",
        "project_url": "https://pypi.org/project/sqlalchemy_sql_shell/",
        "project_urls": {
            "Download": "UNKNOWN",
            "Homepage": "https://github.com/msabramo/sqlalchemy_sql_shell"
        },
        "release_url": "https://pypi.org/project/sqlalchemy_sql_shell/0.0.0/",
        "requires_dist": null,
        "requires_python": null,
        "summary": "A shell for doing simple SQL queries to any database supported by SQLAlchemy",
        "version": "0.0.0"
    },
    "last_serial": 1401780,
    "releases": {
        "0.0.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "962b96a6ef5b562ccd0b7b03fed004a9",
                    "sha256": "44e680eefe63f29dad1aadc99b087039685efe69d5f90b2e562c2f0c39a56d44"
                },
                "downloads": -1,
                "filename": "sqlalchemy_sql_shell-0.0.0.tar.gz",
                "has_sig": false,
                "md5_digest": "962b96a6ef5b562ccd0b7b03fed004a9",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 3904,
                "upload_time": "2015-01-29T16:25:20",
                "url": "https://files.pythonhosted.org/packages/dd/6e/67daff62fa014ece502b8af0eb9cab1dfa2e04d356fcad1dd21aef59719c/sqlalchemy_sql_shell-0.0.0.tar.gz"
            }
        ]
    },
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "962b96a6ef5b562ccd0b7b03fed004a9",
                "sha256": "44e680eefe63f29dad1aadc99b087039685efe69d5f90b2e562c2f0c39a56d44"
            },
            "downloads": -1,
            "filename": "sqlalchemy_sql_shell-0.0.0.tar.gz",
            "has_sig": false,
            "md5_digest": "962b96a6ef5b562ccd0b7b03fed004a9",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 3904,
            "upload_time": "2015-01-29T16:25:20",
            "url": "https://files.pythonhosted.org/packages/dd/6e/67daff62fa014ece502b8af0eb9cab1dfa2e04d356fcad1dd21aef59719c/sqlalchemy_sql_shell-0.0.0.tar.gz"
        }
    ]
}