{
    "info": {
        "author": "dotcoo",
        "author_email": "dotcoo@163.com",
        "bugtrack_url": null,
        "classifiers": [
            "License :: OSI Approved :: MIT License",
            "Operating System :: OS Independent",
            "Programming Language :: Python :: 3"
        ],
        "description": "# pyorm\n\nPython ORM Module\n\n## basic\n\nimport module\n\n\tfrom pyorm import orm\n\nconfig connection\n\n\tdatabase_driver = \"pymysql\"\n\tdatabase_params = []\n\tdatabase_config = {\n\t\t\"host\": \"127.0.0.1\",\n\t\t\"user\": \"root\", \n\t\t\"password\": \"123456\",\n\t\t\"db\": \"test\",\n\t\t\"charset\": \"utf8mb4\",\n\t}\n\torm.config(database_driver, *database_params, **database_config)\n\ncreate table\n\n\tcreate_table_user = '''CREATE TABLE `table_user` (\n\t\t`id` int(11) NOT NULL AUTO_INCREMENT,\n\t\t`username` varchar(45) NOT NULL,\n\t\t`password` varchar(45) NOT NULL,\n\t\t`nickname` varchar(45) NOT NULL,\n\t\t`num` int(11) NOT NULL,\n\t\tPRIMARY KEY (`id`)\n\t\t) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4'''\n\torm.execute(create_table_user)\n\nprefix table\n\n\torm.prefix(\"table_\")\n\n## OrmSqlBuilder quick method\n\nfind by pk\n\n\torm.user.find(5)\n\nadd\n\n\torm.user.add(user).lastrowid\n\nedit\n\n\torm.user.edit(user).rowcount\n\nremove by id\n\n\torm.user.remove(11).rowcount\n\nsave\n\n\torm.user.save(user)\n\n## OrmSqlBuilder method\n\ninsert\n\n\torm.user.insert(data)\n\nupdate\n\n\torm.user.where(\"username = ?\", \"admin1\").update(data)\n\ndelete\n\n\torm.user.where(\"id = ?\", 4).delete()\n\nselect where\n\n\torm.user.columns(\"id\", \"username\").where(\"id > \", 10).where(\"num IN (?)\", [8, 9, 10]).select().fetch_all()\n\ngroup having\n\n\torm.user.group(\"num\").select()\n\norder\n\n\torm.user.order(\"num DESC\", \"id\").select()\n\nlimit offset\n\n\torm.user.limit(10).offset(20).select()\n\npage\n\n\torm.user.page(4, 10).select()\n\ncount\n\n\torm.user.where(\"id < ?\", 10).count()\n\nplus\n\n\torm.user.where(\"`id` = ?\", 2).plus(\"num\", 1, \"num\", -1)\n\n## Cursor method\n\nfetch_all\n\n\torm.user.select().fetch_all()\n\nfetch\n\n\torm.user.select().fetch()\n\nfetch_one\n\n\torm.user.select().fetch_one(\"id\")\n\nfetch_column\n\n\torm.user.select().fetch_column(\"id\")\n\nfetch_unique\n\n\torm.user.select().fetch_unique(\"id\")\n\nfetch_key_pair\n\n\torm.user.select().fetch_key_pair(\"id\", \"username\")\n\n## ORM method\n\ninsert\n\n\torm.insert(\"INSERT INTO `table_user` (`username`, `password`, `nickname`, `num`) VALUES (?, ?, ?, ?)\", \"admin1\", \"admin1\", \"admin1\", 1).lastrowid\n\nupdate\n\n\torm.update(\"UPDATE `table_user` SET `password` = ?, `nickname` = ?, `num` = ? WHERE username = ?\", \"admin123\", \"admin123\", 123, \"admin1\").rowcount\n\ndelete\n\n\torm.delete(\"DELETE FROM `table_user` WHERE id = ?\", 1).rowcount\n\nselect\n\n\torm.select(\"SELECT * FROM `table_user` WHERE id = ?\", 1).fetch_all()\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/dotcoo/pypyorm",
        "keywords": "",
        "license": "",
        "maintainer": "",
        "maintainer_email": "",
        "name": "pypyorm",
        "package_url": "https://pypi.org/project/pypyorm/",
        "platform": "",
        "project_url": "https://pypi.org/project/pypyorm/",
        "project_urls": {
            "Homepage": "https://github.com/dotcoo/pypyorm"
        },
        "release_url": "https://pypi.org/project/pypyorm/0.1.1/",
        "requires_dist": [
            "pymysql"
        ],
        "requires_python": "",
        "summary": "Easy ORM package",
        "version": "0.1.1"
    },
    "last_serial": 4155326,
    "releases": {
        "0.1.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "a9d02c4f591cde2a5318b60787452714",
                    "sha256": "54eaefaa45e10b700cbbd396025d489693a9a5d903bbd4c1318f083e1821ec21"
                },
                "downloads": -1,
                "filename": "pypyorm-0.1.1-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "a9d02c4f591cde2a5318b60787452714",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 8706,
                "upload_time": "2018-08-10T04:31:53",
                "url": "https://files.pythonhosted.org/packages/33/f2/961f67a141ea6f614cb903c42f41e716baa0cdbd456d19f4d95c760120a3/pypyorm-0.1.1-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "139ce3212338d6c548c937d2b3bb05aa",
                    "sha256": "bf3d09dfdc0015a40be4548e5893382b1125ad9900ce04cf25f75625ff396e50"
                },
                "downloads": -1,
                "filename": "pypyorm-0.1.1.tar.gz",
                "has_sig": false,
                "md5_digest": "139ce3212338d6c548c937d2b3bb05aa",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 8992,
                "upload_time": "2018-08-10T04:31:55",
                "url": "https://files.pythonhosted.org/packages/37/5e/02e178aafebe66bfef53b06ed0cbd0a8d801c4308128de06d45677793157/pypyorm-0.1.1.tar.gz"
            }
        ]
    },
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "a9d02c4f591cde2a5318b60787452714",
                "sha256": "54eaefaa45e10b700cbbd396025d489693a9a5d903bbd4c1318f083e1821ec21"
            },
            "downloads": -1,
            "filename": "pypyorm-0.1.1-py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "a9d02c4f591cde2a5318b60787452714",
            "packagetype": "bdist_wheel",
            "python_version": "py3",
            "requires_python": null,
            "size": 8706,
            "upload_time": "2018-08-10T04:31:53",
            "url": "https://files.pythonhosted.org/packages/33/f2/961f67a141ea6f614cb903c42f41e716baa0cdbd456d19f4d95c760120a3/pypyorm-0.1.1-py3-none-any.whl"
        },
        {
            "comment_text": "",
            "digests": {
                "md5": "139ce3212338d6c548c937d2b3bb05aa",
                "sha256": "bf3d09dfdc0015a40be4548e5893382b1125ad9900ce04cf25f75625ff396e50"
            },
            "downloads": -1,
            "filename": "pypyorm-0.1.1.tar.gz",
            "has_sig": false,
            "md5_digest": "139ce3212338d6c548c937d2b3bb05aa",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 8992,
            "upload_time": "2018-08-10T04:31:55",
            "url": "https://files.pythonhosted.org/packages/37/5e/02e178aafebe66bfef53b06ed0cbd0a8d801c4308128de06d45677793157/pypyorm-0.1.1.tar.gz"
        }
    ]
}