{
    "info": {
        "author": "Mohamed El-Kalioby",
        "author_email": "mkalioby@mkalioby.com",
        "bugtrack_url": null,
        "classifiers": [],
        "description": "# jsonLookup\nSearching in MySQL JSON field in Django\n\n# Challenge\n\nMySQL has introduced JSON fields in MySQL Server 5.7, Currently it works well with [jsonfield](https://github.com/bradjasper/django-jsonfield) for Data Saving and retrieval. The problem that Searching can only be done through LIKE operator which isn't convinent for all function.\n\n# Objective\n\nCreating a new custom lookup operator \"has\" for Django that will support JSON Search in MySQL.\n\n# Installation\n\n### Install the Package\n```sh\n$ pip install jsonLookup\n```\n\n### Register to JSONFields\n\n```python\nfrom jsonLookup import hasLookup,jcontainsLookup\nJSONField.register_lookup(hasLookup)\nJSONField.register_lookup(jcontainsLookup)\n```\n\n### Write your JSON queries\n\n```python\n# Create test objects\nUser.objects.create(name=\"Ahmed\",properties={\"city\":\"Giza\",\"Address\":{\"district\":\"Ahram\",\"Code\":11263}})\nUser.objects.create(name=\"Mohamed\",properties={\"city\":\"Cairo\",\"Address\":{\"district\":\"Helipolis\",\"Code\":11351}})\n# Run first query\nq = User.objects.filter(properties__has=\"$.city=Giza\")\nprint q[0].name\n\"Ahmed\"\n# Run Second query\nq= User.objects.filter(properties__has=\"$.Address.Code=11351\")\nprint q[0].name\n\"Mohamed\"\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/mkalioby/jsonLookup",
        "keywords": "django,django,mysql",
        "license": "",
        "maintainer": "",
        "maintainer_email": "",
        "name": "jsonLookup",
        "package_url": "https://pypi.org/project/jsonLookup/",
        "platform": "",
        "project_url": "https://pypi.org/project/jsonLookup/",
        "project_urls": {
            "Homepage": "https://github.com/mkalioby/jsonLookup"
        },
        "release_url": "https://pypi.org/project/jsonLookup/0.7.5/",
        "requires_dist": null,
        "requires_python": "",
        "summary": "Search MySQL JSON fields in Django",
        "version": "0.7.5"
    },
    "last_serial": 5905706,
    "releases": {
        "0.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "ce1d660bb4d2de01355608501ea1d8e4",
                    "sha256": "5b2647a5adfaf22fc2d64e9ecac2164bb1930417c0bcb7180ae175ef6572a64e"
                },
                "downloads": -1,
                "filename": "jsonLookup-0.1.tar.gz",
                "has_sig": false,
                "md5_digest": "ce1d660bb4d2de01355608501ea1d8e4",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 850,
                "upload_time": "2016-05-04T22:32:52",
                "url": "https://files.pythonhosted.org/packages/17/27/fa535540e1d763ba102e7b970bec63d26afeb6445c54167bdba261aabb67/jsonLookup-0.1.tar.gz"
            }
        ],
        "0.1.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "fcf13dcbdea479d228a0ed992fc5076b",
                    "sha256": "ad554ccde47f2563d7cdff3a26f30c4a80bddb7ef66ca96fb01d16d06f8e862b"
                },
                "downloads": -1,
                "filename": "jsonLookup-0.1.1.tar.gz",
                "has_sig": false,
                "md5_digest": "fcf13dcbdea479d228a0ed992fc5076b",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 864,
                "upload_time": "2016-05-04T22:42:40",
                "url": "https://files.pythonhosted.org/packages/07/f1/9226b2f76178a4f2be27b3a510cd235c5d270beebf4c67887b52be31b2c3/jsonLookup-0.1.1.tar.gz"
            }
        ],
        "0.2.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "8b53b702ad437528d7d9dfe7d5c32136",
                    "sha256": "af6a0ebcd2e09859329aba127700737b4316d4819be4efc8ead7ee06c675ba35"
                },
                "downloads": -1,
                "filename": "jsonLookup-0.2.0.tar.gz",
                "has_sig": false,
                "md5_digest": "8b53b702ad437528d7d9dfe7d5c32136",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 963,
                "upload_time": "2016-05-30T12:00:45",
                "url": "https://files.pythonhosted.org/packages/c9/d8/3fadb0c3bc7e4a1f0bb28510aa977a9f157fa36422c393a624f7d642bd57/jsonLookup-0.2.0.tar.gz"
            }
        ],
        "0.2.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "663a816194e5513c207b20f12c4b6b41",
                    "sha256": "697c6f3d959b02c71aefbae92e8902a8b3606fed1d6e850e36afe131baa50dbf"
                },
                "downloads": -1,
                "filename": "jsonLookup-0.2.1.tar.gz",
                "has_sig": false,
                "md5_digest": "663a816194e5513c207b20f12c4b6b41",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 954,
                "upload_time": "2016-06-15T13:36:21",
                "url": "https://files.pythonhosted.org/packages/c2/cf/2cc9dff3b7a8b7bd248e5110125a559d5fb5eae7bb9ebf81643ab4b6d428/jsonLookup-0.2.1.tar.gz"
            }
        ],
        "0.3.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "26a7ea785c898aa24cccf85018856003",
                    "sha256": "526b9b641303643bde052e0928cfab8dcb6e1d92686985c7ccba344afa10a3d9"
                },
                "downloads": -1,
                "filename": "jsonLookup-0.3.0.tar.gz",
                "has_sig": false,
                "md5_digest": "26a7ea785c898aa24cccf85018856003",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 1018,
                "upload_time": "2016-07-20T14:36:45",
                "url": "https://files.pythonhosted.org/packages/9e/47/711232709c11824956c1671de3831221f95850ab800a443b0ed92a736bdc/jsonLookup-0.3.0.tar.gz"
            }
        ],
        "0.3.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "9dabe3996572c040e13b62b945491221",
                    "sha256": "7ab05ddd5d942bd7500c8e476e64e2d4d527ab1fd3e63f62e52768878ee09bc0"
                },
                "downloads": -1,
                "filename": "jsonLookup-0.3.1.tar.gz",
                "has_sig": false,
                "md5_digest": "9dabe3996572c040e13b62b945491221",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 991,
                "upload_time": "2016-07-20T14:38:22",
                "url": "https://files.pythonhosted.org/packages/56/85/1052f5605fc14be0ca02573d1dc29ed7188cdee0953b36bddfcf9f6f849a/jsonLookup-0.3.1.tar.gz"
            }
        ],
        "0.4.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "81a9b492b32a4cf6d7a01d486a2cd7d0",
                    "sha256": "2499b0b9a25ef3072d84b056623ffc8f4accd7394b9ad49189dfd848c703a697"
                },
                "downloads": -1,
                "filename": "jsonLookup-0.4.0.tar.gz",
                "has_sig": false,
                "md5_digest": "81a9b492b32a4cf6d7a01d486a2cd7d0",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 1012,
                "upload_time": "2018-04-22T12:53:54",
                "url": "https://files.pythonhosted.org/packages/d2/78/d4c68d8d11324f1d038f99b7a3cbc3bd572a7b4c841c9abfb8c36fd70711/jsonLookup-0.4.0.tar.gz"
            }
        ],
        "0.5.2": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "33b169642a6e6dcaae36df7b79458d10",
                    "sha256": "04129089aac5339917a1d9f094fdc8bbe7df3a95cc75dfcdb8cdcdfe4726430b"
                },
                "downloads": -1,
                "filename": "jsonLookup-0.5.2-py2.py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "33b169642a6e6dcaae36df7b79458d10",
                "packagetype": "bdist_wheel",
                "python_version": "py2.py3",
                "requires_python": null,
                "size": 4890,
                "upload_time": "2019-01-23T07:38:32",
                "url": "https://files.pythonhosted.org/packages/41/28/c23e212258167e14312bd299c2a68d2eba2f0ff8a710f547f7251047527a/jsonLookup-0.5.2-py2.py3-none-any.whl"
            }
        ],
        "0.6.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "11b3a793f447622b2967fbc66451ff13",
                    "sha256": "4337a03fb73a79380f469ea6d7797fac8a423c624fc84d296e51768deb97f758"
                },
                "downloads": -1,
                "filename": "jsonLookup-0.6.0.tar.gz",
                "has_sig": false,
                "md5_digest": "11b3a793f447622b2967fbc66451ff13",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 2263,
                "upload_time": "2019-07-25T13:31:03",
                "url": "https://files.pythonhosted.org/packages/fe/8e/1e46b03d800c6692bc4e32a49815ed8542f2a8255b17b57b60177ecbf233/jsonLookup-0.6.0.tar.gz"
            }
        ],
        "0.7.5": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "5c876e007f1fbede6ba5dd7838a23dd2",
                    "sha256": "3f88add5f8f3d596ba817f024444eb49bb85815add7d564f46b5aaf926403b29"
                },
                "downloads": -1,
                "filename": "jsonLookup-0.7.5.tar.gz",
                "has_sig": false,
                "md5_digest": "5c876e007f1fbede6ba5dd7838a23dd2",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 2332,
                "upload_time": "2019-09-30T08:59:36",
                "url": "https://files.pythonhosted.org/packages/e8/fb/0a4ceee2ce6210599edf962924a77ba536458803ebed070bd1ef4103a1b9/jsonLookup-0.7.5.tar.gz"
            }
        ]
    },
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "5c876e007f1fbede6ba5dd7838a23dd2",
                "sha256": "3f88add5f8f3d596ba817f024444eb49bb85815add7d564f46b5aaf926403b29"
            },
            "downloads": -1,
            "filename": "jsonLookup-0.7.5.tar.gz",
            "has_sig": false,
            "md5_digest": "5c876e007f1fbede6ba5dd7838a23dd2",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 2332,
            "upload_time": "2019-09-30T08:59:36",
            "url": "https://files.pythonhosted.org/packages/e8/fb/0a4ceee2ce6210599edf962924a77ba536458803ebed070bd1ef4103a1b9/jsonLookup-0.7.5.tar.gz"
        }
    ]
}