{
    "info": {
        "author": "Andrew Anderson",
        "author_email": "andrew-anderson.neo@yandex.ru",
        "bugtrack_url": null,
        "classifiers": [
            "License :: OSI Approved :: MIT License",
            "Operating System :: OS Independent",
            "Programming Language :: Python :: 3"
        ],
        "description": "# db_query\nPython3 module for comfortable using of database (tested for sqlite3)\n\nUsage:\n\n    import db_query\n    table = db_query.Table(sqlite3.connect('datebase.db'), 'tablename')\n    table.where(column1=value1, column2=value2) # -> list of rows matching given equalities\n    table.where(column1=(value11, value12), column2=value2) # -> executes 'SELECT * FROM tablename WHERE (column1 = value11 OR column1 = value12) AND column2 = value2' and returns result\n    table.where_raw('column1 LIKE \"val%1\" AND column2 = \"kek\"') # \"raw\" sql query (beware of vulnerabilities)\n    table(...) # -> table.where(...)\n    table.insert(value1, value2, ...) # insert new row into table\n    table.insert(column1=value1) # this also works - can be used if columns have default values\n    table.where(...).select(column1, column2) # executes 'SELECT column1, column2 FROM tablename WHERE ...' (and returnes result)\n    table.where(...).select() # -> table.where(...)\n    table.where(...).column1 # -> [_[0] for _ in table.where(...).select('column1')]\n    table.where(...)['column1'] # same\n    table.where(...).update(column1=value1, column2=value2) # update table\n    table.where(...).column1 = new_value # -> table.where(...).update(column1=new_value)\n    table.where(...).delete() # delete matching rows\n    table.delete(*args, **kwargs) # same\n\n\n",
        "description_content_type": "",
        "docs_url": null,
        "download_url": "",
        "downloads": {
            "last_day": -1,
            "last_month": -1,
            "last_week": -1
        },
        "home_page": "https://github.com/Mr-Andersen/db_query",
        "keywords": "",
        "license": "MIT",
        "maintainer": "",
        "maintainer_email": "",
        "name": "db-query",
        "package_url": "https://pypi.org/project/db-query/",
        "platform": "",
        "project_url": "https://pypi.org/project/db-query/",
        "project_urls": {
            "Homepage": "https://github.com/Mr-Andersen/db_query"
        },
        "release_url": "https://pypi.org/project/db-query/1.3.0/",
        "requires_dist": null,
        "requires_python": "",
        "summary": "Module for comfortable using of databases (tested for sqlite3)",
        "version": "1.3.0"
    },
    "last_serial": 4922644,
    "releases": {
        "1.1.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "6a868d0a514f22475cf32b1229a6ad40",
                    "sha256": "84db290cedc5c7728fdb84065acbc6ee5c11b93eb47b82e809fd340ca22ac1f4"
                },
                "downloads": -1,
                "filename": "db_query-1.1.1-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "6a868d0a514f22475cf32b1229a6ad40",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 3888,
                "upload_time": "2018-12-12T13:33:50",
                "url": "https://files.pythonhosted.org/packages/10/5d/093fe323b930a408f20852a097b4149cea080c33314a45484320348f3edc/db_query-1.1.1-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "6950b931bcb9b6fa658cc2a6e2eac779",
                    "sha256": "f71fbcdbfee55f7c44a75053a911baf3e82ef4d4177c21f1b93f3a809bf77a4c"
                },
                "downloads": -1,
                "filename": "db_query-1.1.1.tar.gz",
                "has_sig": false,
                "md5_digest": "6950b931bcb9b6fa658cc2a6e2eac779",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 2815,
                "upload_time": "2018-12-12T13:33:52",
                "url": "https://files.pythonhosted.org/packages/7b/0b/ac70b6e26ff98f79f15bedbb3cd09c8aa0a2d95773d494ec2edc460495bc/db_query-1.1.1.tar.gz"
            }
        ],
        "1.2.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "92701024a951403db67c463d9588fb84",
                    "sha256": "974a22f256aa929c572e4771daaa500ab31b015a497518bb4d08e47cad1b0975"
                },
                "downloads": -1,
                "filename": "db_query-1.2.0-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "92701024a951403db67c463d9588fb84",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 4433,
                "upload_time": "2019-01-04T15:14:50",
                "url": "https://files.pythonhosted.org/packages/e7/ac/e397da716bb063ca9d17fbf728942d81bea03d4a8424d94c708359d0d18c/db_query-1.2.0-py3-none-any.whl"
            }
        ],
        "1.2.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "a0089629e2d9c5c421e655f5030c8276",
                    "sha256": "7be64fe8a0147d7e8a41534651b5b14dfe25c12ee273fd65ad254478fcf178ad"
                },
                "downloads": -1,
                "filename": "db_query-1.2.1-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "a0089629e2d9c5c421e655f5030c8276",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 4984,
                "upload_time": "2019-03-08T14:00:35",
                "url": "https://files.pythonhosted.org/packages/fc/b5/5f2f9ac7ec87fb43ec0870f26edaac9e1d1175d6e3db612b40ce8023c89c/db_query-1.2.1-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "c7432126ed57205d1ae1bb757b34c722",
                    "sha256": "45115f8fb3cc51850540f7ce6113c055ebc79b67977d72f84e115a3a79a94443"
                },
                "downloads": -1,
                "filename": "db_query-1.2.1.tar.gz",
                "has_sig": false,
                "md5_digest": "c7432126ed57205d1ae1bb757b34c722",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 3192,
                "upload_time": "2019-03-08T14:00:37",
                "url": "https://files.pythonhosted.org/packages/d3/98/2f4660a6972e3ec8c78cc33979bb0311a2f304ba42e37ef2170795648c0c/db_query-1.2.1.tar.gz"
            }
        ],
        "1.3.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "3917d333c8c792754fd5f37a224d7651",
                    "sha256": "9e0f2ddd76a8f96cce84d93594ba4a798e1835071a5689a0abe5c9451c805b7e"
                },
                "downloads": -1,
                "filename": "db_query-1.3.0-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "3917d333c8c792754fd5f37a224d7651",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 5098,
                "upload_time": "2019-03-10T20:54:31",
                "url": "https://files.pythonhosted.org/packages/14/5b/56deda95dacdfc2f08760bb45e343f6626532b40cce50f632a0ec9a20f5c/db_query-1.3.0-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "2928342230f62ffe0d4cd81c9ffd1562",
                    "sha256": "c908b0454367c6c5d546deab4d52f25a2cde8afeb9348b9ff6a8af7b13fdfb65"
                },
                "downloads": -1,
                "filename": "db_query-1.3.0.tar.gz",
                "has_sig": false,
                "md5_digest": "2928342230f62ffe0d4cd81c9ffd1562",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 3310,
                "upload_time": "2019-03-10T20:54:33",
                "url": "https://files.pythonhosted.org/packages/67/ff/353bb0742134b63ec2ae9bf176a49312670fde846b71dd6676a951e844f8/db_query-1.3.0.tar.gz"
            }
        ]
    },
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "3917d333c8c792754fd5f37a224d7651",
                "sha256": "9e0f2ddd76a8f96cce84d93594ba4a798e1835071a5689a0abe5c9451c805b7e"
            },
            "downloads": -1,
            "filename": "db_query-1.3.0-py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "3917d333c8c792754fd5f37a224d7651",
            "packagetype": "bdist_wheel",
            "python_version": "py3",
            "requires_python": null,
            "size": 5098,
            "upload_time": "2019-03-10T20:54:31",
            "url": "https://files.pythonhosted.org/packages/14/5b/56deda95dacdfc2f08760bb45e343f6626532b40cce50f632a0ec9a20f5c/db_query-1.3.0-py3-none-any.whl"
        },
        {
            "comment_text": "",
            "digests": {
                "md5": "2928342230f62ffe0d4cd81c9ffd1562",
                "sha256": "c908b0454367c6c5d546deab4d52f25a2cde8afeb9348b9ff6a8af7b13fdfb65"
            },
            "downloads": -1,
            "filename": "db_query-1.3.0.tar.gz",
            "has_sig": false,
            "md5_digest": "2928342230f62ffe0d4cd81c9ffd1562",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 3310,
            "upload_time": "2019-03-10T20:54:33",
            "url": "https://files.pythonhosted.org/packages/67/ff/353bb0742134b63ec2ae9bf176a49312670fde846b71dd6676a951e844f8/db_query-1.3.0.tar.gz"
        }
    ]
}