{
    "info": {
        "author": "TheDevFromKer",
        "author_email": "",
        "bugtrack_url": null,
        "classifiers": [
            "Operating System :: OS Independent",
            "Programming Language :: Python :: 3.6",
            "Programming Language :: Python :: 3.7"
        ],
        "description": "# aio_ormsql\nSimple asynchronous MySQL ORM class.\n\n## Easy install\n`pip3 install aio_ormsql`\n\n## Required\n- `pip3 install asyncio aiomysql`  \n- Python 3.6+\n\n## Example usage\n1. Do imports:\n```python3\nfrom aio_ormsql.db import DataBase\nfrom aio_ormsql.classes Table, Column, WHERE\n```\nWhere:\n- `DataBase` - class for working with MySQL\n- `Table` - class for creating a new table\n- `Column` - class for creating a columns\n- `WHERE` - class for creating where statements\n2. Follow examples ans see their output:\n\n## Examples\n### Creating table\n```python3\ntbl = Table(\n    'tests',\n    Column('id', int),\n    Column('tname', str)\n)\n```\n### Connection to database\n```python3\ndb = DataBase('admin', 'admin', 'tests')\nawait db.connect()\n```\n### Simple WHERE statement\n```python3\nwhere = WHERE(\n    tbl.tname == 'admin'\n)\nprint(where)\n\n# Output:\n# WHERE `tname`='admin'\n```\n### Another WHERE statement\n```python3\nwhere2 = WHERE(\n    (tbl.id >= 20) | (tbl.tname == 'admin')\n)\nprint(where2)\n\n# Output:\n# WHERE `id`>=20 OR `tname`='admin'\n```\n### SELECT example\n```python3\nstatement = await db.select(\n    [tbl.id, tbl.tname], where=where, table=tbl, back=True\n)\nprint(statement)\n\n# Output:\n# SELECT DISTINCT `id`, `tname` FROM `tests` WHERE `tname`='admin'\n```\n### SELECT example 2\n```python3\nstatement2 = await db.select(\n    [tbl.id, tbl.tname], False, where2, table=tbl, back=True\n)\nprint(statement2)\n\n# Output:\n# SELECT`id`, `tname` FROM `tests` WHERE `id`>=20 OR `tname`='admin'\n```\n### INSERT example\n```python3\nstatement3 = await db.insert(\n    {\n        tbl.id: 123,\n        tbl.tname: 'Johan'\n    },\n    tbl,\n    back=True\n)\nprint(statement3)\n\n# Output:\n# INSERT INTO `tests` (`id`, `tname`) VALUES (123, 'Johan')\n```\n### INSERT example 2\n```python3\nstatement4 = await db.update(\n    {\n        tbl.id: '123',\n        tbl.tname: 'Admin'\n    },\n    WHERE(tbl.tname == 'Johan'),\n    tbl,\n    back=True\n)\nprint(statement4)\n\n# Output:\n# UPDATE `tests` SET `id`=123, `tname`='Admin' WHERE `tname`='Johan'\n```\n### Working with large DB\n```python3\narray = db.fetch_gen(await db.select(\n    [tbl.id, tbl.tname], back=True\n))\n\nasync for item in array:\n    print('New pair:', item)\n    # And you can see row-by-row output\n```\n###  Closing connection and wait for completing tasks\n```python3\nawait db.close()\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/TheDevFromKer/aio_ormsql",
        "keywords": "python mysql,async mysql python,mysql python,python async orm,async orm,mysql async orm",
        "license": "GNU 3.0",
        "maintainer": "",
        "maintainer_email": "",
        "name": "aio-ormsql",
        "package_url": "https://pypi.org/project/aio-ormsql/",
        "platform": "",
        "project_url": "https://pypi.org/project/aio-ormsql/",
        "project_urls": {
            "Homepage": "https://github.com/TheDevFromKer/aio_ormsql"
        },
        "release_url": "https://pypi.org/project/aio-ormsql/0.0.5/",
        "requires_dist": null,
        "requires_python": "",
        "summary": "Simple asynchronous MySQL ORM class.",
        "version": "0.0.5",
        "yanked": false,
        "yanked_reason": null
    },
    "last_serial": 6064733,
    "releases": {
        "0.0.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "fd8cb34b85d1a38671ee78eb5ee73cec",
                    "sha256": "fa99b6072d6c70d952600e1611ec3788ae6498610a71cfbc54dcbe4c56fffdb4"
                },
                "downloads": -1,
                "filename": "aio_ormsql-0.0.1.tar.gz",
                "has_sig": false,
                "md5_digest": "fd8cb34b85d1a38671ee78eb5ee73cec",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 4390,
                "upload_time": "2019-10-23T10:39:40",
                "upload_time_iso_8601": "2019-10-23T10:39:40.059596Z",
                "url": "https://files.pythonhosted.org/packages/09/72/eb05f5094645ce3551c2679dd63b61d01378994b460e2f98321e70df86b6/aio_ormsql-0.0.1.tar.gz",
                "yanked": false,
                "yanked_reason": null
            }
        ],
        "0.0.5": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "78edc3e200b5923e228eb4655e9a2311",
                    "sha256": "93380358dbb502c599367f68a99d6aef4974ecbd296bd95e2b8951ca160219f5"
                },
                "downloads": -1,
                "filename": "aio_ormsql-0.0.5.tar.gz",
                "has_sig": false,
                "md5_digest": "78edc3e200b5923e228eb4655e9a2311",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 4650,
                "upload_time": "2019-11-01T15:57:18",
                "upload_time_iso_8601": "2019-11-01T15:57:18.451895Z",
                "url": "https://files.pythonhosted.org/packages/6d/f3/9979f047351c503f531ae392f6e486bce23a7f3ebae960a2cc0f378553b9/aio_ormsql-0.0.5.tar.gz",
                "yanked": false,
                "yanked_reason": null
            }
        ]
    },
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "78edc3e200b5923e228eb4655e9a2311",
                "sha256": "93380358dbb502c599367f68a99d6aef4974ecbd296bd95e2b8951ca160219f5"
            },
            "downloads": -1,
            "filename": "aio_ormsql-0.0.5.tar.gz",
            "has_sig": false,
            "md5_digest": "78edc3e200b5923e228eb4655e9a2311",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 4650,
            "upload_time": "2019-11-01T15:57:18",
            "upload_time_iso_8601": "2019-11-01T15:57:18.451895Z",
            "url": "https://files.pythonhosted.org/packages/6d/f3/9979f047351c503f531ae392f6e486bce23a7f3ebae960a2cc0f378553b9/aio_ormsql-0.0.5.tar.gz",
            "yanked": false,
            "yanked_reason": null
        }
    ],
    "vulnerabilities": []
}