{
    "info": {
        "author": "Beto Dealmeida, Devesh Agrawal",
        "author_email": "beto@dealmeida.net, devesh.agrawal@gmail.com",
        "bugtrack_url": null,
        "classifiers": [
            "License :: OSI Approved :: MIT License",
            "Programming Language :: Python",
            "Programming Language :: Python :: 2.6",
            "Programming Language :: Python :: 2.7",
            "Programming Language :: Python :: 3",
            "Programming Language :: Python :: 3.3",
            "Programming Language :: Python :: 3.4",
            "Programming Language :: Python :: 3.5",
            "Programming Language :: Python :: 3.6",
            "Programming Language :: Python :: Implementation :: CPython",
            "Programming Language :: Python :: Implementation :: PyPy"
        ],
        "description": "# Python DB-API and SQLAlchemy dialect for Pinot #\n\nThis module allows accessing Pinot via its [SQL API](https://github.com/linkedin/pinot/wiki/Pinot-Query-Language).\n\n## Usage ##\n\nUsing the DB API:\n\n```python\nfrom pinotdb import connect\n\nconn = connect(host='localhost', port=8099, path='/query', scheme='http')\ncurs = conn.cursor()\ncurs.execute(\"\"\"\n    SELECT place,\n           CAST(REGEXP_EXTRACT(place, '(.*),', 1) AS FLOAT) AS lat,\n \u00a0 \u00a0 \u00a0     CAST(REGEXP_EXTRACT(place, ',(.*)', 1) AS FLOAT) AS lon\n      FROM places\n     LIMIT 10\n\"\"\")\nfor row in curs:\n    print(row)\n```\n\nUsing SQLAlchemy:\n\n```python\nfrom sqlalchemy import *\nfrom sqlalchemy.engine import create_engine\nfrom sqlalchemy.schema import *\n\nengine = create_engine('pinot://localhost:8099/query?server=http://localhost:9000/')  # uses HTTP by default :(\n# engine = create_engine('pinot+http://localhost:8099/query?server=http://localhost:9000/')\n# engine = create_engine('pinot+https://localhost:8099/query?server=http://localhost:9000/')\n\nplaces = Table('places', MetaData(bind=engine), autoload=True)\nprint(select([func.count('*')], from_obj=places).scalar())\n```\n\n\n\n",
        "description_content_type": "text/markdown",
        "docs_url": null,
        "download_url": "",
        "downloads": {
            "last_day": -1,
            "last_month": -1,
            "last_week": -1
        },
        "home_page": "https://github.com/python-pinot-dbapi/pinot-dbapi",
        "keywords": "",
        "license": "MIT",
        "maintainer": "",
        "maintainer_email": "",
        "name": "pinotdb",
        "package_url": "https://pypi.org/project/pinotdb/",
        "platform": "",
        "project_url": "https://pypi.org/project/pinotdb/",
        "project_urls": {
            "Homepage": "https://github.com/python-pinot-dbapi/pinot-dbapi"
        },
        "release_url": "https://pypi.org/project/pinotdb/0.2.4/",
        "requires_dist": [
            "requests",
            "six",
            "nose ; extra == 'dev'",
            "pipreqs ; extra == 'dev'",
            "twine ; extra == 'dev'",
            "sqlalchemy ; extra == 'sqlalchemy'"
        ],
        "requires_python": "",
        "summary": "Python DB-API and SQLAlchemy dialect for Pinot.",
        "version": "0.2.4"
    },
    "last_serial": 5209282,
    "releases": {
        "0.1.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "f093846f62075b49656463be0e3ce03e",
                    "sha256": "a6aa9bd413aa946ee7e6e73f40d6d61339e5294518b7a15f587ee8126190b0f5"
                },
                "downloads": -1,
                "filename": "pinotdb-0.1.0-py2.py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "f093846f62075b49656463be0e3ce03e",
                "packagetype": "bdist_wheel",
                "python_version": "py2.py3",
                "requires_python": null,
                "size": 9572,
                "upload_time": "2018-01-09T19:59:15",
                "url": "https://files.pythonhosted.org/packages/4d/76/2925044255444868b8e5f1071bf100eafd0e61502bde2b3ab804906c02fa/pinotdb-0.1.0-py2.py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "8721f1daa400793d9ad57105dea7923c",
                    "sha256": "f6cb0ae9c0688b7f9b55695f2aee7a2362a38c99e95071cca544835e6eb9923b"
                },
                "downloads": -1,
                "filename": "pinotdb-0.1.0.tar.gz",
                "has_sig": false,
                "md5_digest": "8721f1daa400793d9ad57105dea7923c",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 8813,
                "upload_time": "2018-01-09T19:59:17",
                "url": "https://files.pythonhosted.org/packages/d8/b6/0e1b1064c30b382230016cb253dd7f098a098121a144ced405bbfb8fc54d/pinotdb-0.1.0.tar.gz"
            }
        ],
        "0.1.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "b28ee597c427db4d08caa1b572083471",
                    "sha256": "a467a16888542b5f402ef65dc49438e1fdae6012874928e276be09df9cdf6933"
                },
                "downloads": -1,
                "filename": "pinotdb-0.1.1-py2.py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "b28ee597c427db4d08caa1b572083471",
                "packagetype": "bdist_wheel",
                "python_version": "py2.py3",
                "requires_python": null,
                "size": 9585,
                "upload_time": "2018-01-10T00:10:28",
                "url": "https://files.pythonhosted.org/packages/32/61/9cf8d6c139bd9f1efa8a1aeef1a1b30192e7e1e4cadf811db28096760836/pinotdb-0.1.1-py2.py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "4c700396c67ed27007461e7d58c351e1",
                    "sha256": "8f759c37c22077126296934140f21fdf73ac5309522bd90f9be8ce499f8b66a5"
                },
                "downloads": -1,
                "filename": "pinotdb-0.1.1.tar.gz",
                "has_sig": false,
                "md5_digest": "4c700396c67ed27007461e7d58c351e1",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 8827,
                "upload_time": "2018-01-10T00:10:30",
                "url": "https://files.pythonhosted.org/packages/f6/5b/353ced4b60308e5d8123ae6f21dfe51072b9aceb9942c4c3241703857249/pinotdb-0.1.1.tar.gz"
            }
        ],
        "0.2.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "f9fe9d6012d45710400ffc068e8dbc95",
                    "sha256": "36368d2d695a35b96619fe87c3a29d7ee304aedd263106ee32e1a8a526460b2e"
                },
                "downloads": -1,
                "filename": "pinotdb-0.2.1-py2.py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "f9fe9d6012d45710400ffc068e8dbc95",
                "packagetype": "bdist_wheel",
                "python_version": "py2.py3",
                "requires_python": null,
                "size": 10174,
                "upload_time": "2019-02-12T19:11:37",
                "url": "https://files.pythonhosted.org/packages/1a/24/7be4324ea900c0fb5af77a33632991d39100d38e2f06870500af3116299c/pinotdb-0.2.1-py2.py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "6d43f4659850124be457ed704281b24d",
                    "sha256": "007a086f5642f1a43e50b6e17d6ea05966aed42b257e76f184a391f2a4294efd"
                },
                "downloads": -1,
                "filename": "pinotdb-0.2.1.tar.gz",
                "has_sig": false,
                "md5_digest": "6d43f4659850124be457ed704281b24d",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 9898,
                "upload_time": "2019-02-12T19:11:39",
                "url": "https://files.pythonhosted.org/packages/f6/42/05d97cc1d8932a7acf3e4fe1f962674f8451e393b0d4be51d62759520c11/pinotdb-0.2.1.tar.gz"
            }
        ],
        "0.2.2": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "952566fe9d39e5babcfa4ea0006da561",
                    "sha256": "6b46f8aeaa701bf4f586001d9f1ed55bc5eec70daa4b69417f6184ea5af420b1"
                },
                "downloads": -1,
                "filename": "pinotdb-0.2.2-py2.py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "952566fe9d39e5babcfa4ea0006da561",
                "packagetype": "bdist_wheel",
                "python_version": "py2.py3",
                "requires_python": null,
                "size": 10686,
                "upload_time": "2019-02-12T19:19:29",
                "url": "https://files.pythonhosted.org/packages/90/bd/e84d454119116ddd862fb53290ae464235877f5fc0e5a37983c6e60355c7/pinotdb-0.2.2-py2.py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "1c2f22758e9e366a775a4d5ccacfdf55",
                    "sha256": "89831a1941f0c7e864668addac519a5c1b0dd6fc7746c8b5ed48c1c637dd7f3f"
                },
                "downloads": -1,
                "filename": "pinotdb-0.2.2.tar.gz",
                "has_sig": false,
                "md5_digest": "1c2f22758e9e366a775a4d5ccacfdf55",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 10135,
                "upload_time": "2019-02-12T19:19:30",
                "url": "https://files.pythonhosted.org/packages/3d/bb/3f936fb853443ec5377bce2cd36f9e058ffeae0daf94e4d58a49fc0cd65d/pinotdb-0.2.2.tar.gz"
            }
        ],
        "0.2.3": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "5f318fe27b8adc185d01e892282c5952",
                    "sha256": "711ea50ad1bc70c3bbe31d338232b9fc198876d96fb9273b86b8b03f326663b4"
                },
                "downloads": -1,
                "filename": "pinotdb-0.2.3-py2.py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "5f318fe27b8adc185d01e892282c5952",
                "packagetype": "bdist_wheel",
                "python_version": "py2.py3",
                "requires_python": null,
                "size": 11144,
                "upload_time": "2019-04-05T21:19:39",
                "url": "https://files.pythonhosted.org/packages/43/8e/29578a22851ac365d77470fcb59f39498647d0183f76d909979683c842ba/pinotdb-0.2.3-py2.py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "937caf58c2cbdbf543ef764996c8b276",
                    "sha256": "ffef998c4d774fc1720fb6e28b389a5c6fec8b39c2c621dea87d3b9e8b6f3153"
                },
                "downloads": -1,
                "filename": "pinotdb-0.2.3.tar.gz",
                "has_sig": false,
                "md5_digest": "937caf58c2cbdbf543ef764996c8b276",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 11325,
                "upload_time": "2019-04-05T21:19:40",
                "url": "https://files.pythonhosted.org/packages/06/c4/3291c0ecf0bf0b932d4a1e73f15bd2f5a5cab188e09143eba5722cad4cde/pinotdb-0.2.3.tar.gz"
            }
        ],
        "0.2.4": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "9a4b66e0b0fd2963899c4f64c38d81e3",
                    "sha256": "a8b5f04b90a5a5601a45a1371911730e4f5a787b774427070519bdb98656e741"
                },
                "downloads": -1,
                "filename": "pinotdb-0.2.4-py2.py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "9a4b66e0b0fd2963899c4f64c38d81e3",
                "packagetype": "bdist_wheel",
                "python_version": "py2.py3",
                "requires_python": null,
                "size": 11146,
                "upload_time": "2019-04-30T17:11:19",
                "url": "https://files.pythonhosted.org/packages/e2/dd/1c4aaf587de378d17791f6dd7e73d96cfcc59147763ed40fbb6f7c69cfd4/pinotdb-0.2.4-py2.py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "06afe8c2d774948678bf7472b3caf2f9",
                    "sha256": "a8753aca2c6b14e6c40b059dbc6f7ea98e6b3c4a16faa0a5fe6369aabbc151b9"
                },
                "downloads": -1,
                "filename": "pinotdb-0.2.4.tar.gz",
                "has_sig": false,
                "md5_digest": "06afe8c2d774948678bf7472b3caf2f9",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 11326,
                "upload_time": "2019-04-30T17:11:24",
                "url": "https://files.pythonhosted.org/packages/75/4d/537baefd2d8f748018f1d9df310de12bad27334aa3991c850a532d7d5411/pinotdb-0.2.4.tar.gz"
            }
        ]
    },
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "9a4b66e0b0fd2963899c4f64c38d81e3",
                "sha256": "a8b5f04b90a5a5601a45a1371911730e4f5a787b774427070519bdb98656e741"
            },
            "downloads": -1,
            "filename": "pinotdb-0.2.4-py2.py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "9a4b66e0b0fd2963899c4f64c38d81e3",
            "packagetype": "bdist_wheel",
            "python_version": "py2.py3",
            "requires_python": null,
            "size": 11146,
            "upload_time": "2019-04-30T17:11:19",
            "url": "https://files.pythonhosted.org/packages/e2/dd/1c4aaf587de378d17791f6dd7e73d96cfcc59147763ed40fbb6f7c69cfd4/pinotdb-0.2.4-py2.py3-none-any.whl"
        },
        {
            "comment_text": "",
            "digests": {
                "md5": "06afe8c2d774948678bf7472b3caf2f9",
                "sha256": "a8753aca2c6b14e6c40b059dbc6f7ea98e6b3c4a16faa0a5fe6369aabbc151b9"
            },
            "downloads": -1,
            "filename": "pinotdb-0.2.4.tar.gz",
            "has_sig": false,
            "md5_digest": "06afe8c2d774948678bf7472b3caf2f9",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 11326,
            "upload_time": "2019-04-30T17:11:24",
            "url": "https://files.pythonhosted.org/packages/75/4d/537baefd2d8f748018f1d9df310de12bad27334aa3991c850a532d7d5411/pinotdb-0.2.4.tar.gz"
        }
    ]
}