{
    "info": {
        "author": "jeanku, liubing",
        "author_email": "",
        "bugtrack_url": null,
        "classifiers": [
            "License :: OSI Approved :: MIT License",
            "Operating System :: OS Independent",
            "Programming Language :: Python :: 3"
        ],
        "description": "# SimpySql\n\n\u4e00\u4e2a\u6570\u636e\u5e93orm, \u76ee\u524d\u652f\u6301`mysql`, `mongodb`\n\n[mysql\u6587\u6863](./README_mysql.md)\n, [mongo\u6587\u6863](./README_mongo.md)\n\n# \u5b89\u88c5\n```\npip install simpysql\n```\n\n# \u521d\u59cb\u5316\n\u4f60\u9700\u8981\u5728\u4f60\u7684\u9879\u76ee\u6839\u76ee\u5f55\u4e0b\u521b\u5efa\u4e00\u4e2a.env\u6587\u4ef6\uff0c\u5185\u5bb9\u5982\u4e0b:\n\n``` python\n[default]                                       #\u6570\u636e\u5e93\u914d\u7f6e\u540d\u79f0(\u5bf9\u5e94model.__database__)\nDB_TYPE=mysql                                   #\u6570\u636e\u5e93\u7c7b\u578b mysql \u6216\u8005 mongo\nDB_HOST=127.0.0.1                               #\u6570\u636e\u5e93IP                          \nDB_PORT=3306                                    #\u7aef\u53e3\nDB_NAME=test_db1                                #\u5e93\u540d\nDB_USER=root                                    #\u8d26\u53f7\nDB_PASSWORD=123456                              #\u5bc6\u7801\nDB_CHARSET=utf8mb4                              #\u6570\u636e\u5e93\u7f16\u7801\nLOG_DIR=/home/logs/python/                      #\u5f00\u542f\u65e5\u5fd7\uff0c \u65e5\u5fd7\u8def\u5f84: /home/logs/python/\n\n[test_db2]                                      #\u5176\u4ed6\u7684\u5e93\nDB_TYPE=mysql\nDB_HOST=127.0.0.1\nDB_PORT=3306\nDB_NAME=test_db2\nDB_USER=root\nDB_PASSWORD=123456\nDB_CHARSET=utf8mb4\n#LOG_DIR=/home/logs/python/                     #\u5173\u95ed\u65e5\u5fd7\n```\n\n# \u521b\u5efa\u8868model\n\n\u521b\u5efa\u6570\u636e\u5e93model \u5e76\u7ee7\u627fsimpysql.DBModel:\n\n``` python\n#!/usr/bin/python\n# -*- coding: UTF-8 -*-\nfrom simpysql.DBModel import DBModel\n\nclass ModelDemo(DBModel):\n\n    __basepath__ = '/home/project/'             # .env \u6587\u4ef6\u8def\u5f84\n    #__database__ = 'default'                   # \u5e93\u9009\u62e9\uff0c \u6ca1\u6709\u8be5\u5c5e\u6027\uff0c\u5219\u9ed8\u8ba4default\u5e93\n    __tablename__ = 'lh_test'                   # table name\n    __create_time__ = 'create_time'             # \u81ea\u52a8\u6dfb\u52a0\u521b\u5efa\u65f6\u95f4\u5b57\u6bb5create_time(\u7cbe\u786e\u5230\u79d2)\uff0c \u8bbe\u7f6e\u4e3aNone\u6216\u8005\u5220\u9664\u8be5\u5c5e\u6027\uff0c\u5219\u4e0d\u81ea\u52a8\u6dfb\u52a0 \n    __update_time__ = 'update_time'             # \u81ea\u52a8\u66f4\u65b0\u65f6\u95f4\u5b57\u6bb5update_time(\u7cbe\u786e\u5230\u79d2)\uff0c \u8bbe\u7f6e\u4e3aNone\u6216\u8005\u5220\u9664\u8be5\u5c5e\u6027\uff0c\u5219\u4e0d\u81ea\u52a8\u66f4\u65b0\n    columns = [                                 # table columns\n        'id',\n        'name',\n        'token_name',\n        'status',\n        'create_time',\n        'update_time',\n    ]\n\n    # \u53ef\u4ee5\u901a\u8fc7\u8be5\u65b9\u6cd5\u8bbe\u7f6e\u81ea\u52a8\u6dfb\u52a0\u65f6\u95f4\u5b57\u6bb5\u7684\u683c\u5f0f\n    # def fresh_timestamp(self):\n    #     return datetime.datetime.now().strftime(\"%Y%m%d\")\n```\n\n## \u64cd\u4f5c\u5b9e\u4f8b\n\n```python\nModelDemo().where('id', 4).select('id', 'name').take(5).get()\n```\n\n## \u5176\u4ed6\n\u6b22\u8fce\u5fd7\u540c\u9053\u5408\u7684\u670b\u53cb\u4e00\u8d77\u53c2\u4e0e\u672c\u9879\u76ee\u5f00\u53d1SQLServer\u3001PostgreSQL\u5f00\u53d1, \u8054\u7cfb\u65b9\u5f0f: 490573621@qq.com\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": "",
        "keywords": "util",
        "license": "",
        "maintainer": "",
        "maintainer_email": "",
        "name": "simutil",
        "package_url": "https://pypi.org/project/simutil/",
        "platform": "",
        "project_url": "https://pypi.org/project/simutil/",
        "project_urls": null,
        "release_url": "https://pypi.org/project/simutil/0.4.1/",
        "requires_dist": [
            "configparser"
        ],
        "requires_python": ">=3",
        "summary": "A simple mysql orm base on pymysql",
        "version": "0.4.1"
    },
    "last_serial": 5834374,
    "releases": {
        "0.0.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "9635037e29f883fe8b57305c9876311c",
                    "sha256": "14cfb2d27b577341edebee77b727e4fcd420b81f52c3da61371a6cf507b36cf7"
                },
                "downloads": -1,
                "filename": "simutil-0.0.1-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "9635037e29f883fe8b57305c9876311c",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": ">=3",
                "size": 10448,
                "upload_time": "2019-09-10T03:03:06",
                "url": "https://files.pythonhosted.org/packages/fd/48/d3f2329dc77bbdb000c74b0b071e38e3e38833754e7fcb5fa363ba1e7e46/simutil-0.0.1-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "5782574b4b74734ae7240f190b873d03",
                    "sha256": "3156721b166311ee09bbdbe9e61c12c3b6d9524e6ff15f91bfb34d9a54e1b134"
                },
                "downloads": -1,
                "filename": "simutil-0.0.1.tar.gz",
                "has_sig": false,
                "md5_digest": "5782574b4b74734ae7240f190b873d03",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": ">=3",
                "size": 8893,
                "upload_time": "2019-09-10T03:03:09",
                "url": "https://files.pythonhosted.org/packages/c3/16/2b5396df83245c51077c8caa0ce1dcdf7c87974574582c10aed650dc780a/simutil-0.0.1.tar.gz"
            }
        ],
        "0.3.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "7613281e581834a6f304248d71e69416",
                    "sha256": "f6ff309f3fb108560af2dfe30a70e508b95cddb5847aace898c87f378a062b87"
                },
                "downloads": -1,
                "filename": "simutil-0.3.1-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "7613281e581834a6f304248d71e69416",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": ">=3",
                "size": 10450,
                "upload_time": "2019-09-10T03:02:25",
                "url": "https://files.pythonhosted.org/packages/d6/f4/56ca05656055258eda99bee8ea585b7b76661618b45f18f5e62c9643567f/simutil-0.3.1-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "b7776dec0be764dae20c05e2d3fd8cde",
                    "sha256": "b5644a991916cd801bb8039140b82cbc614af8ef7b1b7e26d492252aecec11ee"
                },
                "downloads": -1,
                "filename": "simutil-0.3.1.tar.gz",
                "has_sig": false,
                "md5_digest": "b7776dec0be764dae20c05e2d3fd8cde",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": ">=3",
                "size": 8900,
                "upload_time": "2019-09-10T03:02:28",
                "url": "https://files.pythonhosted.org/packages/f5/d0/8ec24d2a88fc7e9856b908ae3cf252b848a05a80fb22f6a0692cf7b7b8f1/simutil-0.3.1.tar.gz"
            }
        ],
        "0.3.2": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "8eb1d200830d0efc3ae2e2095ff6aa46",
                    "sha256": "4d7400d0df6e8b8ce45a6b4aeda778b9f9372279a00dca8232bf9b9a704ff51e"
                },
                "downloads": -1,
                "filename": "simutil-0.3.2-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "8eb1d200830d0efc3ae2e2095ff6aa46",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": ">=3",
                "size": 11943,
                "upload_time": "2019-09-10T09:24:09",
                "url": "https://files.pythonhosted.org/packages/04/2c/456f15c0d0ad920d7c0caecc4813e50e6306b045fedcfad79eb067e1ef0e/simutil-0.3.2-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "9afe9a6ce30faaee94c44494b5b06679",
                    "sha256": "7ff4ac493f7dc5053619bd7473cf198547446a34647041bcee7c31e435a361d6"
                },
                "downloads": -1,
                "filename": "simutil-0.3.2.tar.gz",
                "has_sig": false,
                "md5_digest": "9afe9a6ce30faaee94c44494b5b06679",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": ">=3",
                "size": 10614,
                "upload_time": "2019-09-10T09:24:10",
                "url": "https://files.pythonhosted.org/packages/28/04/b9c6ad52f6bb404222030161924e706bab59c7f94e315da53fc9799fcd63/simutil-0.3.2.tar.gz"
            }
        ],
        "0.3.4": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "2c42477b864e729504c19962cc0e5b2d",
                    "sha256": "e2da1f939d773d6628bedfcc75c0f780174d4d8ad3f66151b4ddec8910118cef"
                },
                "downloads": -1,
                "filename": "simutil-0.3.4-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "2c42477b864e729504c19962cc0e5b2d",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": ">=3",
                "size": 12180,
                "upload_time": "2019-09-10T10:12:39",
                "url": "https://files.pythonhosted.org/packages/df/cf/ca1fdb7f04f79dbeffb31a30aba1b623dcfe0a0a224d03e7187322391505/simutil-0.3.4-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "18f82f3d3c492642c498997c7f72f66f",
                    "sha256": "1190df9d87a50099ce82079da36380398864115e34d1a34e9ee3583beea63438"
                },
                "downloads": -1,
                "filename": "simutil-0.3.4.tar.gz",
                "has_sig": false,
                "md5_digest": "18f82f3d3c492642c498997c7f72f66f",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": ">=3",
                "size": 10913,
                "upload_time": "2019-09-10T10:12:41",
                "url": "https://files.pythonhosted.org/packages/ba/1f/467ea5aa5df5015e6131e68da8be64f32b40a4f5d3384c003aa5a87d6e6c/simutil-0.3.4.tar.gz"
            }
        ],
        "0.3.6": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "a3448b0227acd9613031b8e33b64c3c3",
                    "sha256": "d57319a3c279fe6d6f839a62d52eab70feb884729fa1a0c2185f809343a19c3e"
                },
                "downloads": -1,
                "filename": "simutil-0.3.6-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "a3448b0227acd9613031b8e33b64c3c3",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": ">=3",
                "size": 13102,
                "upload_time": "2019-09-10T10:47:30",
                "url": "https://files.pythonhosted.org/packages/ac/35/19ab7f78e7c0ab0b39a1f23a4b712730d34d0dc955ed7dde334fb2707336/simutil-0.3.6-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "7d22dbeed102e6e2ce6326e4f90a008c",
                    "sha256": "7387a940641c4ed4dc854d145cdd4e7a18e0393835b82df728520a5c997624eb"
                },
                "downloads": -1,
                "filename": "simutil-0.3.6.tar.gz",
                "has_sig": false,
                "md5_digest": "7d22dbeed102e6e2ce6326e4f90a008c",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": ">=3",
                "size": 11249,
                "upload_time": "2019-09-10T10:47:32",
                "url": "https://files.pythonhosted.org/packages/e7/68/9928a977f16715eba0b61cfb9e358eff2756749232603d0d2e74f53796fd/simutil-0.3.6.tar.gz"
            }
        ],
        "0.3.7": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "1e64bf93a122460095c1662ec212c9f6",
                    "sha256": "af68dffc11dbeafc985745d1ea335fb50d023c48ce2e786a3927662f5230f3bc"
                },
                "downloads": -1,
                "filename": "simutil-0.3.7-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "1e64bf93a122460095c1662ec212c9f6",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": ">=3",
                "size": 13036,
                "upload_time": "2019-09-10T10:54:45",
                "url": "https://files.pythonhosted.org/packages/55/ac/b2ec0a27d391298c7b1749a9ea36e9cca14e90d6dd11e1af9be22e361cb6/simutil-0.3.7-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "732a77ce9e651982f4aab4b789b3252e",
                    "sha256": "ba881b934f084432bff74aa41bb66017acd73f4422d0e3de02c6e9063a173a91"
                },
                "downloads": -1,
                "filename": "simutil-0.3.7.tar.gz",
                "has_sig": false,
                "md5_digest": "732a77ce9e651982f4aab4b789b3252e",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": ">=3",
                "size": 11180,
                "upload_time": "2019-09-10T10:54:47",
                "url": "https://files.pythonhosted.org/packages/af/2d/4ba1920e8928dc3eed1581a3ca1eb4b40aabc99f0c8d5a580d36edd63b11/simutil-0.3.7.tar.gz"
            }
        ],
        "0.3.9": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "53ba51c1166a1bc0d4da2a8157f70eff",
                    "sha256": "265037de934b08f4b73908256dd6c2b2afc94ed02c0e97b49779ae1c7bc66088"
                },
                "downloads": -1,
                "filename": "simutil-0.3.9-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "53ba51c1166a1bc0d4da2a8157f70eff",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": ">=3",
                "size": 13149,
                "upload_time": "2019-09-10T11:46:19",
                "url": "https://files.pythonhosted.org/packages/a5/9e/62b32afa7f99a89580f34f65fa2ac5c64c5e61486681f00ae783d37cb845/simutil-0.3.9-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "5bb4d722e9ceaa84b972bf5d66986817",
                    "sha256": "12dc6f224da99e1559422ff8c4dc4e47fc5d858ddb34a5999fba96d4f02f9d80"
                },
                "downloads": -1,
                "filename": "simutil-0.3.9.tar.gz",
                "has_sig": false,
                "md5_digest": "5bb4d722e9ceaa84b972bf5d66986817",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": ">=3",
                "size": 11299,
                "upload_time": "2019-09-10T11:46:21",
                "url": "https://files.pythonhosted.org/packages/df/82/e77100623e9c38533635d4299c27b11b9aa9909a80170c2ab3540a1df7d9/simutil-0.3.9.tar.gz"
            }
        ],
        "0.4.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "f67a528c412d3c120971804d11e307e3",
                    "sha256": "c893182cddff10894b725b6c5c2b3d1dda6538f2c3ab1096311df769cf5e5e7e"
                },
                "downloads": -1,
                "filename": "simutil-0.4.1-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "f67a528c412d3c120971804d11e307e3",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": ">=3",
                "size": 13214,
                "upload_time": "2019-09-16T06:55:55",
                "url": "https://files.pythonhosted.org/packages/cc/2f/bf04889331f96eea273ea8d31ecaab08c949dab2edae740c1c7eda40feea/simutil-0.4.1-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "35bcce1a0cc7eec1a6b53b71f043b95d",
                    "sha256": "23645516f17b2aae64468e252826505556aea70c9d71ef06c3e104532aa01584"
                },
                "downloads": -1,
                "filename": "simutil-0.4.1.tar.gz",
                "has_sig": false,
                "md5_digest": "35bcce1a0cc7eec1a6b53b71f043b95d",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": ">=3",
                "size": 11356,
                "upload_time": "2019-09-16T06:55:57",
                "url": "https://files.pythonhosted.org/packages/94/8b/b36f27a3ce134598726e9fef92e53c289f9fc8386b0760e18f29032e3d8a/simutil-0.4.1.tar.gz"
            }
        ]
    },
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "f67a528c412d3c120971804d11e307e3",
                "sha256": "c893182cddff10894b725b6c5c2b3d1dda6538f2c3ab1096311df769cf5e5e7e"
            },
            "downloads": -1,
            "filename": "simutil-0.4.1-py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "f67a528c412d3c120971804d11e307e3",
            "packagetype": "bdist_wheel",
            "python_version": "py3",
            "requires_python": ">=3",
            "size": 13214,
            "upload_time": "2019-09-16T06:55:55",
            "url": "https://files.pythonhosted.org/packages/cc/2f/bf04889331f96eea273ea8d31ecaab08c949dab2edae740c1c7eda40feea/simutil-0.4.1-py3-none-any.whl"
        },
        {
            "comment_text": "",
            "digests": {
                "md5": "35bcce1a0cc7eec1a6b53b71f043b95d",
                "sha256": "23645516f17b2aae64468e252826505556aea70c9d71ef06c3e104532aa01584"
            },
            "downloads": -1,
            "filename": "simutil-0.4.1.tar.gz",
            "has_sig": false,
            "md5_digest": "35bcce1a0cc7eec1a6b53b71f043b95d",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": ">=3",
            "size": 11356,
            "upload_time": "2019-09-16T06:55:57",
            "url": "https://files.pythonhosted.org/packages/94/8b/b36f27a3ce134598726e9fef92e53c289f9fc8386b0760e18f29032e3d8a/simutil-0.4.1.tar.gz"
        }
    ]
}