{
    "info": {
        "author": "Bryan A. Jones",
        "author_email": "bjones@ece.msstate.edu",
        "bugtrack_url": null,
        "classifiers": [
            "Development Status :: 5 - Production/Stable",
            "Intended Audience :: Developers",
            "License :: OSI Approved :: GNU General Public License v3 or later (GPLv3+)",
            "Operating System :: OS Independent",
            "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",
            "Programming Language :: Python :: 3.6",
            "Topic :: Database"
        ],
        "description": ".. License\n\n   Copyright 2017 Bryan A. Jones\n\n   Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the \"Software\"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:\n\n   The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.\n\n   THE SOFTWARE IS PROVIDED \"AS IS\", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.\n\nThe `pythonic_sqlalchemy_query module <http://pythonic-sqlalchemy-query.readthedocs.io/en/latest/pythonic_sqlalchemy_query/__init__.py.html>`_ provides concise, Pythonic query syntax for SQLAlchemy. For example, these two queries produce identical results:\n\n.. code-block:: Python3\n\n    pythonic_query = session.User['jack'].addresses['jack@google.com']\n    traditional_query = (\n        # Ask for the Address...\n        session.query(Address).\n        # by querying a User named 'jack'...\n        select_from(User).filter(User.name == 'jack').\n        # then joining this to the Address 'jack@google.com`.\n        join(Address).filter(Address.email_address == 'jack@google.com')\n\nInstallation\n============\n``pip install pythonic_sqlalchemy_query``\n\nUse with SQLAlchemy\n===================\nFor most cases:\n\n.. code-block:: Python3\n\n    from pythonic_sqlalchemy_query import QueryMakerSession\n\n    # Construct an engine as usual.\n    engine = create_engine(...)\n    # Create a session aware of this module.\n    Session = sessionmaker(bind=engine, class_=QueryMakerSession)\n    session = Session()\n\n    # After defining some declarative classes, query away:\n    for result in session.User['jack'].addresses:\n        # Do some processing on result...\n\nThe `examples <http://pythonic-sqlalchemy-query.readthedocs.io/en/latest/tests/test_pythonic_sqlalchemy_query.py.html>`__ provide full, working code.\n\nUse with Flask-SQLAlchemy\n=========================\nFor most cases:\n\n.. code-block:: Python3\n\n    from pythonic_sqlalchemy_query.flask import SQLAlchemyPythonicQuery\n\n    app = Flask(__name__)\n    db = SQLAlchemyPythonicQuery(app)\n\n    # After defining some declarative classes, query away:\n    for result in User['jack'].addresses:\n        # Do some processing on result...\n\nThe `examples <http://pythonic-sqlalchemy-query.readthedocs.io/en/latest/tests/test_flask.py.html>`__ provide full, working code.\n\nDocumentation\n=============\nSee the `pythonic_sqlalchemy_query module`_.\n\nLicense\n=======\nThis software is distributed under the terms of the `MIT license <http://pythonic-sqlalchemy-query.readthedocs.io/en/latest/license.html>`_.\n\n\n",
        "description_content_type": null,
        "docs_url": null,
        "download_url": "",
        "downloads": {
            "last_day": -1,
            "last_month": -1,
            "last_week": -1
        },
        "home_page": "http://pythonic_sqlalchemy_query.readthedocs.io/en/latest/",
        "keywords": "SQLAlchemy,query helper",
        "license": "GPLv3+",
        "maintainer": "",
        "maintainer_email": "",
        "name": "pythonic-sqlalchemy-query",
        "package_url": "https://pypi.org/project/pythonic-sqlalchemy-query/",
        "platform": "",
        "project_url": "https://pypi.org/project/pythonic-sqlalchemy-query/",
        "project_urls": {
            "Homepage": "http://pythonic_sqlalchemy_query.readthedocs.io/en/latest/"
        },
        "release_url": "https://pypi.org/project/pythonic-sqlalchemy-query/1.2.0/",
        "requires_dist": [
            "SQLAlchemy",
            "pytest; extra == 'test'",
            "Flask-SQLAlchemy; extra == 'test'"
        ],
        "requires_python": "",
        "summary": "Provide concise, Pythonic query syntax for SQLAlchemy",
        "version": "1.2.0"
    },
    "last_serial": 3481897,
    "releases": {
        "1.0.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "f93cdd6e06066a76561d0377110745a6",
                    "sha256": "cff316eeba94e34e5c3c8bd9be1ee65c122b442e57f8516bf493e5554c16f576"
                },
                "downloads": -1,
                "filename": "pythonic_sqlalchemy_query-1.0.0-py2.py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "f93cdd6e06066a76561d0377110745a6",
                "packagetype": "bdist_wheel",
                "python_version": "py2.py3",
                "requires_python": null,
                "size": 8292,
                "upload_time": "2017-11-03T18:51:03",
                "url": "https://files.pythonhosted.org/packages/8a/ed/779a5a762e23f890fc77c858002e78d72cdae79af0dda4ad526868e2ada2/pythonic_sqlalchemy_query-1.0.0-py2.py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "fa16721698bf0c4085c3d3fd0d4862fd",
                    "sha256": "88b7fc99a5cd1aa3bbf660ede52cda5a0e5b87069014f242313c6d341693d9a2"
                },
                "downloads": -1,
                "filename": "pythonic_sqlalchemy_query-1.0.0.tar.gz",
                "has_sig": false,
                "md5_digest": "fa16721698bf0c4085c3d3fd0d4862fd",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 7598,
                "upload_time": "2017-11-03T16:33:13",
                "url": "https://files.pythonhosted.org/packages/fd/f4/e3eb49bcd3adba8c563a73aeac00ab9be8684bb63415215e67aa51fc3599/pythonic_sqlalchemy_query-1.0.0.tar.gz"
            }
        ],
        "1.0.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "c92f4e57e556ae28c4a8912e52777879",
                    "sha256": "6febae8aeb52ba5a2ffd44c9f974da5bcfd72c31f07e102c9ad6bdf8db3190d0"
                },
                "downloads": -1,
                "filename": "pythonic_sqlalchemy_query-1.0.1-py2.py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "c92f4e57e556ae28c4a8912e52777879",
                "packagetype": "bdist_wheel",
                "python_version": "py2.py3",
                "requires_python": null,
                "size": 8602,
                "upload_time": "2017-11-03T20:30:24",
                "url": "https://files.pythonhosted.org/packages/f6/20/86e3816e4d55ea68ffa248406b5f3002cffa1ab62fabdc1f5cdd2c20671f/pythonic_sqlalchemy_query-1.0.1-py2.py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "a4faa104a10b4387d46566f749bc23c3",
                    "sha256": "cfc9e9d7dbb73ab33548af6a48a0b970d9215bfe33e932732fad427e95586f5d"
                },
                "downloads": -1,
                "filename": "pythonic_sqlalchemy_query-1.0.1.tar.gz",
                "has_sig": false,
                "md5_digest": "a4faa104a10b4387d46566f749bc23c3",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 7960,
                "upload_time": "2017-11-03T20:30:51",
                "url": "https://files.pythonhosted.org/packages/5e/49/9575a06d4f121194ac24158bfca3fc5cb717da2ff7a2779ad52a27ae2079/pythonic_sqlalchemy_query-1.0.1.tar.gz"
            }
        ],
        "1.0.2": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "46b58cd11fde6b1a042151e289f1f0f3",
                    "sha256": "c999f6f1d6aa2581e6c77e3d8f503d1c32287184a33b2c3df951fb3319ecfdcd"
                },
                "downloads": -1,
                "filename": "pythonic_sqlalchemy_query-1.0.2-py2.py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "46b58cd11fde6b1a042151e289f1f0f3",
                "packagetype": "bdist_wheel",
                "python_version": "py2.py3",
                "requires_python": null,
                "size": 8637,
                "upload_time": "2017-11-03T20:53:54",
                "url": "https://files.pythonhosted.org/packages/f6/f9/ae992fec7082c40d27286412bd51bbff2274393aa63cc7d32af76f2a6c34/pythonic_sqlalchemy_query-1.0.2-py2.py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "bd48a1e6d07f0f5ff1e392d7e9372ed2",
                    "sha256": "e6ed27945a673c1c8119c089563e839902381a2e62386f1d0080e27b4490f58b"
                },
                "downloads": -1,
                "filename": "pythonic_sqlalchemy_query-1.0.2.tar.gz",
                "has_sig": false,
                "md5_digest": "bd48a1e6d07f0f5ff1e392d7e9372ed2",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 7997,
                "upload_time": "2017-11-03T20:53:55",
                "url": "https://files.pythonhosted.org/packages/2e/df/225031cb085aafb3243cd57ad100816c7224943c8838a27f66ee968bb058/pythonic_sqlalchemy_query-1.0.2.tar.gz"
            }
        ],
        "1.0.3": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "4ae060e226a87b0fdb52dd662d3e2246",
                    "sha256": "e9fe9a9dca9f4974c0030876e07dd24df73176e05fd5c1c5d1aa311482f5c5b8"
                },
                "downloads": -1,
                "filename": "pythonic_sqlalchemy_query-1.0.3-py2.py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "4ae060e226a87b0fdb52dd662d3e2246",
                "packagetype": "bdist_wheel",
                "python_version": "py2.py3",
                "requires_python": null,
                "size": 8643,
                "upload_time": "2017-11-03T21:09:24",
                "url": "https://files.pythonhosted.org/packages/fb/f2/1a103ac515a4b361e450102c2634c7e6995faf9f0b5d427ca5589cc604cb/pythonic_sqlalchemy_query-1.0.3-py2.py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "ee387da9c08866c71515f0d72742087a",
                    "sha256": "615bc373218b5fca1d3e104d28ea6835d3082ea27bdedb710ab0f081771c9d44"
                },
                "downloads": -1,
                "filename": "pythonic_sqlalchemy_query-1.0.3.tar.gz",
                "has_sig": false,
                "md5_digest": "ee387da9c08866c71515f0d72742087a",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 7988,
                "upload_time": "2017-11-03T21:09:25",
                "url": "https://files.pythonhosted.org/packages/05/e4/1925a66334809048f7e10bdd982816edd1f2059f5581a1318ce59f6efa25/pythonic_sqlalchemy_query-1.0.3.tar.gz"
            }
        ],
        "1.0.4": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "4777425c79a459769d6b9e555a3abcf4",
                    "sha256": "5db9d4b179d895728b09c082af0c30dbf4cf4f6548f9a113363df08d9dff83d2"
                },
                "downloads": -1,
                "filename": "pythonic_sqlalchemy_query-1.0.4-py2.py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "4777425c79a459769d6b9e555a3abcf4",
                "packagetype": "bdist_wheel",
                "python_version": "py2.py3",
                "requires_python": null,
                "size": 10040,
                "upload_time": "2017-11-06T22:43:59",
                "url": "https://files.pythonhosted.org/packages/f1/2c/58aa2950fe05738778489e266ba67044554871e5e22b2c98bebcce615403/pythonic_sqlalchemy_query-1.0.4-py2.py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "7f2eabe5613f621031a71e01339b6a4d",
                    "sha256": "15552b20f28845d07ac8c380695b0a10e2facb4d998c716f5fac0c78e5b22a25"
                },
                "downloads": -1,
                "filename": "pythonic_sqlalchemy_query-1.0.4.tar.gz",
                "has_sig": false,
                "md5_digest": "7f2eabe5613f621031a71e01339b6a4d",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 8289,
                "upload_time": "2017-11-06T22:44:00",
                "url": "https://files.pythonhosted.org/packages/9a/de/6d5e335d21120d75b2ba3f3ba5eb49d566dd3c54c5e8ca7b30380175b860/pythonic_sqlalchemy_query-1.0.4.tar.gz"
            }
        ],
        "1.1.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "f410f12bfd38e5faacf0cbb5b64c3c4c",
                    "sha256": "96b465920b856dcbf99506d2953b41a217e33fd6e5f9d596deb1bfb2a863304b"
                },
                "downloads": -1,
                "filename": "pythonic_sqlalchemy_query-1.1.0-py2.py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "f410f12bfd38e5faacf0cbb5b64c3c4c",
                "packagetype": "bdist_wheel",
                "python_version": "py2.py3",
                "requires_python": null,
                "size": 17787,
                "upload_time": "2017-11-13T21:24:21",
                "url": "https://files.pythonhosted.org/packages/34/04/1a935091087bffa864023969ffed7ff0f0105ba98d4fb0e764dba7ad8e69/pythonic_sqlalchemy_query-1.1.0-py2.py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "dc19d0004c1c10f14130bcc51d1f9760",
                    "sha256": "8be270bdb09e4b4e2d6debe5a55da15a870aebef513b5c728fb1fc5622156365"
                },
                "downloads": -1,
                "filename": "pythonic_sqlalchemy_query-1.1.0.tar.gz",
                "has_sig": false,
                "md5_digest": "dc19d0004c1c10f14130bcc51d1f9760",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 9665,
                "upload_time": "2017-11-13T21:24:24",
                "url": "https://files.pythonhosted.org/packages/1a/67/dce111b5895289a0d9c9c028b02cc3718c6ff118a92b1ecc2a841c428d83/pythonic_sqlalchemy_query-1.1.0.tar.gz"
            }
        ],
        "1.1.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "84b7b58215ab4fb8ce6f7fd6e7e4c7f1",
                    "sha256": "7e783c52ea7a801f28415e67b00c1f4d09e38c5dfa96e3db10dc204158953aa1"
                },
                "downloads": -1,
                "filename": "pythonic_sqlalchemy_query-1.1.1-py2.py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "84b7b58215ab4fb8ce6f7fd6e7e4c7f1",
                "packagetype": "bdist_wheel",
                "python_version": "py2.py3",
                "requires_python": null,
                "size": 18177,
                "upload_time": "2017-11-16T21:05:03",
                "url": "https://files.pythonhosted.org/packages/96/45/a1e1750dad23b0612bfc6a68939a360e10b4be1b646ea886274cfc31ebf7/pythonic_sqlalchemy_query-1.1.1-py2.py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "eaf2b699d2ea7889f615935b74d0c7fd",
                    "sha256": "c2478de9a7c7156170293db0f0b5eb01fe570e8a94959eb3ff98a3274bea41bd"
                },
                "downloads": -1,
                "filename": "pythonic_sqlalchemy_query-1.1.1.tar.gz",
                "has_sig": false,
                "md5_digest": "eaf2b699d2ea7889f615935b74d0c7fd",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 9986,
                "upload_time": "2017-11-16T21:05:05",
                "url": "https://files.pythonhosted.org/packages/6b/c9/3d1a2c246cdc8731a69183328807421eceafde16ffbaf6ba0c80a3b31821/pythonic_sqlalchemy_query-1.1.1.tar.gz"
            }
        ],
        "1.2.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "32e16de6cb3c341b410f5a93d5a8f3a6",
                    "sha256": "cf66f682cc3a5aefbad4a64fc81c4232cc5878c65c198c0f53f417e1f0748df7"
                },
                "downloads": -1,
                "filename": "pythonic_sqlalchemy_query-1.2.0-py2.py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "32e16de6cb3c341b410f5a93d5a8f3a6",
                "packagetype": "bdist_wheel",
                "python_version": "py2.py3",
                "requires_python": null,
                "size": 18086,
                "upload_time": "2018-01-11T19:49:01",
                "url": "https://files.pythonhosted.org/packages/15/6c/c41559ed69b91013aec86bf5b5b8d64a9c1e7aa09c8703bc76d5cfd2e119/pythonic_sqlalchemy_query-1.2.0-py2.py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "52ca94026a6a5df14d86b5ba1b52ac14",
                    "sha256": "6eab85d7f640291a980cc00ee8cdd8aa12dc65b830969a1b684eb2583f475b48"
                },
                "downloads": -1,
                "filename": "pythonic_sqlalchemy_query-1.2.0.tar.gz",
                "has_sig": false,
                "md5_digest": "52ca94026a6a5df14d86b5ba1b52ac14",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 9803,
                "upload_time": "2018-01-11T19:49:04",
                "url": "https://files.pythonhosted.org/packages/54/50/103d56209e89a63e57039a9d5365cec8da74c8b73443c13c5e5d846b3055/pythonic_sqlalchemy_query-1.2.0.tar.gz"
            }
        ]
    },
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "32e16de6cb3c341b410f5a93d5a8f3a6",
                "sha256": "cf66f682cc3a5aefbad4a64fc81c4232cc5878c65c198c0f53f417e1f0748df7"
            },
            "downloads": -1,
            "filename": "pythonic_sqlalchemy_query-1.2.0-py2.py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "32e16de6cb3c341b410f5a93d5a8f3a6",
            "packagetype": "bdist_wheel",
            "python_version": "py2.py3",
            "requires_python": null,
            "size": 18086,
            "upload_time": "2018-01-11T19:49:01",
            "url": "https://files.pythonhosted.org/packages/15/6c/c41559ed69b91013aec86bf5b5b8d64a9c1e7aa09c8703bc76d5cfd2e119/pythonic_sqlalchemy_query-1.2.0-py2.py3-none-any.whl"
        },
        {
            "comment_text": "",
            "digests": {
                "md5": "52ca94026a6a5df14d86b5ba1b52ac14",
                "sha256": "6eab85d7f640291a980cc00ee8cdd8aa12dc65b830969a1b684eb2583f475b48"
            },
            "downloads": -1,
            "filename": "pythonic_sqlalchemy_query-1.2.0.tar.gz",
            "has_sig": false,
            "md5_digest": "52ca94026a6a5df14d86b5ba1b52ac14",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 9803,
            "upload_time": "2018-01-11T19:49:04",
            "url": "https://files.pythonhosted.org/packages/54/50/103d56209e89a63e57039a9d5365cec8da74c8b73443c13c5e5d846b3055/pythonic_sqlalchemy_query-1.2.0.tar.gz"
        }
    ]
}