{
    "info": {
        "author": "Gorka Eguileor",
        "author_email": "gorka@eguileor.com",
        "bugtrack_url": null,
        "classifiers": [
            "Development Status :: 2 - Pre-Alpha",
            "Intended Audience :: Developers",
            "License :: OSI Approved :: Apache Software License",
            "Natural Language :: English",
            "Programming Language :: Python :: 2",
            "Programming Language :: Python :: 2.7",
            "Programming Language :: Python :: 3",
            "Programming Language :: Python :: 3.3",
            "Programming Language :: Python :: 3.4",
            "Programming Language :: Python :: 3.5"
        ],
        "description": "===============================\nSQL to Excel converter\n===============================\n\n\n.. image:: https://img.shields.io/pypi/v/sqlexceller.svg\n        :target: https://pypi.python.org/pypi/sqlexceller\n\n.. image:: https://img.shields.io/pypi/pyversions/sqlexceller.svg\n         :target: https://pypi.python.org/pypi/sqlexceller\n\n.. image:: https://img.shields.io/:license-apache-blue.svg\n         :target: http://www.apache.org/licenses/LICENSE-2.0\n\nCommand line program that executes SQL queries and stores results in Excel files\n\n\n* Free software: Apache Software License 2.0\n\n\nFeatures\n--------\n\n* Support for PostgreSQL, MySQL, Oracle, MSSQL, and SQLite\n* Accepts multiple SQL query files\n* Each SQL query will be written into a different sheet\n* Parametrized queries\n* Parametrized output filename\n\nInstallation\n------------\n\nTo install all you need to do is run:\n\n.. code-block:: bash\n\n    $ pip install --upgrade sqlexceller\n\nUsage Help\n----------\n::\n\n  usage: sqlexceller [-h] [-v] [--output OUTPUT] [--db_connection_info URL]\n                     [--param PARAMS]\n                     file [file ...]\n\n  sqlexceller tool\n      The tool will execute SQL queries and generate an Excel file with the\n      results.\n\n  positional arguments:\n    file                  SQL Query file\n\n  optional arguments:\n    -h, --help            show this help message and exit\n    -v, --version         show program's version number and exit\n    --output OUTPUT, -o OUTPUT\n                          Output file\n    --db_connection_info URL, -d URL\n                          DB connection information as an URL in the form of\n                            dialect[+driver]://username:password@host:port/database.\n    --param PARAMS, -p PARAMS\n                          Adds a parameter for the SQL queries. Parameter must\n                          be specified as a key=value pair.  This argument can\n                          be repeated as many times as necessary.\n\n  Available dialects and drivers are:\n    - postgresql:\n      - psycopg2\n      - pg8000\n    - mysql:\n      - mysqldb\n      - mysqlconnector\n      - oursql\n    - oracle:\n      - cx_oracle\n    - mssql:\n      - pyodbc\n      - pymssql\n    - sqlite\n\n  There are some default parameters that will always be present:\n    - NUM_QUERY\n    - QUERY_NAME\n    - DATE\n    - DAY\n    - MONTH\n    - YEAR\n\n  Usage examples:\n    - Execute a simple query on a SQLite DB.\n        sqlexceller query.sql -d sqlite:///example.db\n\n    - Execute multiple queries with 2 different parameters and a custom output\n      file on a PostgreSQL DB:\n\n        Contents of query1.sql:\n          SELECT *\n          FROM stocks\n          where transaction = :transaction;\n\n        Contents of query2.sql:\n          SELECT *\n          FROM stocks\n          where transaction = :transaction and product = :product;\n\n        sqlexceller query1.sql query2.sql -p transaction=BUY -p product=HAT \\\n            -o \"report :trans (:MONTH-:DAY).xlsx\" \\\n            -d postgresql://user:password@localhost/mydatabase\n\n        Generated file will be something like: \"report BUY (10-16).xlsx\"\n\nReporting an issue\n------------------\n\nIf you've found an issue with sqlexceller here's how you can report the problem:\n\n- Preferred method is filing a bug on GitHub:\n\n  1. Go to project's `issue tracker on GitHub`_\n  2. Search for existing issues using the search field at the top of the page\n  3. File a new issue with information on the problem\n  4. Thanks for helping make sqlexceller better\n\n- If you don't have a GitHub account and don't wish to create one you can just\n  drop me an email.\n\n\n.. _issue tracker on GitHub: https://github.com/Akrog/sqlexceller/issues\n\n\n=======\nHistory\n=======\n\n0.1.1 (2018-03-17)\n------------------\n\n* Fix #1: Exception on empty result set from query\n\n0.1.0 (2016-10-16)\n------------------\n\n* First release on PyPI.\n",
        "description_content_type": "",
        "docs_url": null,
        "download_url": "",
        "downloads": {
            "last_day": -1,
            "last_month": -1,
            "last_week": -1
        },
        "home_page": "https://github.com/akrog/sqlexceller",
        "keywords": "sqlexceller",
        "license": "Apache Software License 2.0",
        "maintainer": "",
        "maintainer_email": "",
        "name": "sqlexceller",
        "package_url": "https://pypi.org/project/sqlexceller/",
        "platform": "",
        "project_url": "https://pypi.org/project/sqlexceller/",
        "project_urls": {
            "Homepage": "https://github.com/akrog/sqlexceller"
        },
        "release_url": "https://pypi.org/project/sqlexceller/0.1.1/",
        "requires_dist": null,
        "requires_python": "",
        "summary": "Command line program that executes SQL queries and stores results in Excel files",
        "version": "0.1.1"
    },
    "last_serial": 3678853,
    "releases": {
        "0.1.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "e7edba22278db35ef0386205008af516",
                    "sha256": "4c563216d8535456d1435c09b12f19364bdd0de3d9f0ac8312e06b47f56f1cc6"
                },
                "downloads": -1,
                "filename": "sqlexceller-0.1.0-py2.py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "e7edba22278db35ef0386205008af516",
                "packagetype": "bdist_wheel",
                "python_version": "2.7",
                "requires_python": null,
                "size": 8600,
                "upload_time": "2016-10-16T17:05:22",
                "url": "https://files.pythonhosted.org/packages/01/bf/1245cf83447fcfaed821aeba737cf03ed5369c72c5a71671332f597f2eb0/sqlexceller-0.1.0-py2.py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "576ebcb9e4d4238d69b2db853597374f",
                    "sha256": "3a82fec986bb958b487685679bb25871005777e5f9f0b5a0184323d1d3943058"
                },
                "downloads": -1,
                "filename": "sqlexceller-0.1.0.tar.gz",
                "has_sig": false,
                "md5_digest": "576ebcb9e4d4238d69b2db853597374f",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 14455,
                "upload_time": "2016-10-16T17:05:19",
                "url": "https://files.pythonhosted.org/packages/8a/f2/37f3d91ce76c7c85a93e9d2b23f42c1f3076e7105d99d75a8938f370aa08/sqlexceller-0.1.0.tar.gz"
            }
        ],
        "0.1.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "20373ed46f4246a7dc3877338aa64d41",
                    "sha256": "9aeaad58b242a362c5bf8394a8a5e7ac3f52f42f4809e02c46e968f08e5b3cbb"
                },
                "downloads": -1,
                "filename": "sqlexceller-0.1.1-py2.py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "20373ed46f4246a7dc3877338aa64d41",
                "packagetype": "bdist_wheel",
                "python_version": "2.7",
                "requires_python": null,
                "size": 8754,
                "upload_time": "2018-03-17T13:32:30",
                "url": "https://files.pythonhosted.org/packages/48/1b/f230dceea1550b6c60ed62f7957b6cb3274fc738ab2520c2ff71370230e1/sqlexceller-0.1.1-py2.py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "04fd285aa77ff07902965f3ae7671ee0",
                    "sha256": "ae36d0311e59b2a27ce76dfa4a7745d63777208a40d13d4f70dbcd3147647365"
                },
                "downloads": -1,
                "filename": "sqlexceller-0.1.1.tar.gz",
                "has_sig": false,
                "md5_digest": "04fd285aa77ff07902965f3ae7671ee0",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 20866,
                "upload_time": "2018-03-17T13:32:27",
                "url": "https://files.pythonhosted.org/packages/fb/7b/da7e8191dce5416bd7549c527bbfc6c343cd19e5aaada91939aad5860a25/sqlexceller-0.1.1.tar.gz"
            }
        ]
    },
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "20373ed46f4246a7dc3877338aa64d41",
                "sha256": "9aeaad58b242a362c5bf8394a8a5e7ac3f52f42f4809e02c46e968f08e5b3cbb"
            },
            "downloads": -1,
            "filename": "sqlexceller-0.1.1-py2.py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "20373ed46f4246a7dc3877338aa64d41",
            "packagetype": "bdist_wheel",
            "python_version": "2.7",
            "requires_python": null,
            "size": 8754,
            "upload_time": "2018-03-17T13:32:30",
            "url": "https://files.pythonhosted.org/packages/48/1b/f230dceea1550b6c60ed62f7957b6cb3274fc738ab2520c2ff71370230e1/sqlexceller-0.1.1-py2.py3-none-any.whl"
        },
        {
            "comment_text": "",
            "digests": {
                "md5": "04fd285aa77ff07902965f3ae7671ee0",
                "sha256": "ae36d0311e59b2a27ce76dfa4a7745d63777208a40d13d4f70dbcd3147647365"
            },
            "downloads": -1,
            "filename": "sqlexceller-0.1.1.tar.gz",
            "has_sig": false,
            "md5_digest": "04fd285aa77ff07902965f3ae7671ee0",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 20866,
            "upload_time": "2018-03-17T13:32:27",
            "url": "https://files.pythonhosted.org/packages/fb/7b/da7e8191dce5416bd7549c527bbfc6c343cd19e5aaada91939aad5860a25/sqlexceller-0.1.1.tar.gz"
        }
    ]
}