{
    "info": {
        "author": "Raf",
        "author_email": "",
        "bugtrack_url": null,
        "classifiers": [
            "License :: OSI Approved :: MIT License",
            "Programming Language :: Python :: 3.7"
        ],
        "description": "# Rsql\n\n\u0427\u0438\u0441\u0442\u044b\u0435 \u0438 \u0431\u044b\u0441\u0442\u0440\u044b\u0435\u0435 sql \u0437\u0430\u043f\u0440\u043e\u0441\u044b \u0434\u043b\u044f python. \u0415\u0441\u043b\u0438 \u0432\u044b \u043f\u043e \u043a\u0430\u043a\u043e\u0439 \u0442\u043e \u043f\u0440\u0438\u0447\u0438\u043d\u0435 \u043d\u0435 \u0445\u043e\u0442\u0438\u0442\u0435 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c ORM, \u0442\u043e \u044d\u0442\u043e\u0442 \u043f\u0430\u043a\u0435\u0442 \u0441\u043e\u0437\u0434\u0430\u043d \u0434\u043b\u044f \u0432\u0430\u0441. \u041c\u0438\u043d\u0438\u043c\u0430\u043b\u044c\u043d\u044b\u0439 \u0432\u0435\u0441, \u0438\u043d\u0442\u0435\u0440\u0444\u0435\u0439\u0441 \u0438 \u0432\u0435\u0441\u044c SQL \u0432 \u0432\u0430\u0448\u0438\u0445 \u0440\u0443\u043a\u0430\u0445!\n\n\n# \u041f\u043e\u0434\u0434\u0435\u0440\u0436\u043a\u0430:\n\n  - MySQL 8\n  - SQLite 3\n  - Postgresql  10\n\n\n\u0412\u0441\u0435\u0433\u043e 3 \u0448\u0430\u0433\u0430 \u0434\u043b\u044f \u0440\u0430\u0431\u043e\u0442\u044b \u0441 \u043f\u0430\u043a\u0435\u0442\u043e\u043c:\n  - [\u0423\u0441\u0442\u0430\u043d\u043e\u0432\u043a\u0430] \u0441\u043e\u0435\u0434\u0438\u043d\u0435\u043d\u0438\u044f \u0438 \u043d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0430\n  - \u0417\u0430\u043f\u0440\u043e\u0441 \u043d\u0430 \u0432\u0441\u0435 \u0432\u0438\u0434\u044b [\u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u044f] Db.set( \"INSERT INTO ...\", (params)) \n  - \u0417\u0430\u043f\u0440\u043e\u0441 \u043d\u0430 \u0432\u0441\u0435 \u0432\u0438\u0434\u044b [\u043f\u043e\u043b\u0443\u0447\u0435\u043d\u0438\u044f] Db.get( \"SELECT * FROM ....\", (params)) \n\n\n\n> \u041f\u0430\u043a\u0435\u0442 \u0431\u0430\u0437\u0438\u0440\u0443\u0435\u0442\u0441\u044f \u043d\u0430 \u0432\u043a\u043b\u044e\u0447\u0435\u043d\u043d\u043e\u043c \u0432\n> Python \u043a\u043e\u043d\u043d\u0435\u043a\u0442\u043e\u0440 Sqlite\n> \u0421\u0442\u043e\u0440\u043e\u043d\u043d\u0438\u0445: Pymysql \u0434\u043b\u044f Mysql \u0438 \n> Psycopg \u0434\u043b\u044f Postgresql\n\n\n### Installation\n\n\u0421\u043e\u0432\u0435\u0442\u0443\u0435\u043c \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c [Python](https://www.python.org/downloads/) v.3.6+ \n\n```sh\n$ cd your project\n$ pip install Rsql \n```\n\n### Mysql\n\n```sh\n$ from Rsql.Rmysql import Rmysql\n$ db = Rmysql('0.0.0.0', 'test', 'root', 'root', 3307)\n$ db.set(\"INSERT INTO pet (name, owner, species, sex) VALUES(%s, %s, %s, %s)\", ('Rex', 'Alex', 'dogger', 1)) \n$ print(db.get(\"SELECT name FROM pet\"))\n```\n\n### Postgresql\n\n```sh\n$ from Rsql.Rpostgres import Rpostgres  \n$ db = Rpostgres('0.0.0.0', 'test', 'root', 'root', 5432)\n$ db = db.set(\"INSERT INTO users (id, name) VALUES(1, 'Alex')\" )\n$ db = db.set(\"INSERT INTO users (id, name) VALUES(%s, %s)\", (2, 'Joan'))\n$ print(db.get(\"SELECT * FROM users WHERE id > %s\", ('1')))  \n\n```\n> *\u0432\u0441\u0435\u0433\u0434\u0430 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0439\u0442\u0435 %s \u0432 \u0441\u0435\u0440\u0432\u0435\u0440\u043d\u044b\u0445 \u0431\u0430\u0437\u0430\u0445 \u0434\u0430\u043d\u043d\u044b\u0445 \u043a\u0430\u043a Mysql, Postgresql\n>\u041f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u044b \u0441\u043b\u0435\u0434\u0443\u0435\u0442 \u043f\u0438\u0441\u0430\u0442\u044c \u043e\u0442\u0434\u0435\u043b\u044c\u043d\u043e \u0434\u043b\u044f \u0438\u0437\u0431\u0435\u0436\u0435\u043d\u0438\u044f SQL \u0438\u043d\u044a\u0435\u043a\u0446\u0438\u0439\n\n### SQlite\n\n```sh\n$ from Rsql.Rsqlite import Rsqlite\n\n--- \u043d\u0435\u043e\u0431\u044f\u0437\u0430\u0442\u0435\u043b\u044c\u043d\u044b\u0439 \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440 \u0430\u0431\u0441\u043e\u043b\u044e\u0442\u043d\u043e\u0433\u043e \u043f\u0443\u0442\u0438 \u0434\u043b\u044f \u0445\u0440\u0430\u043d\u0435\u043d\u0438\u044f \u0431\u0430\u0437\u044b---\nimport os\ndir_path = os.path.dirname(os.path.realpath(__file__))\n\n$ db = Rsqlite('lend.db', path=dir_path+'/') \n$ db.set('CREATE TABLE IF NOT EXISTS users (id INTEGER PRIMARY KEY AUTOINCREMENT, name VARCHAR(40), age INT)') \n$ db.set(\"INSERT INTO users (name, age) VALUES(?, ?)\", [('Alex', 22), ('Peter', 55)]) \n$ db.set(\"INSERT INTO users (name) VALUES(?)\", [('Alex',)]) \n$ db.set(\"INSERT INTO users (name,age) VALUES('Joan', 30)\", ) \n\n$ print(db.get(\"SELECT * FROM users WHERE age < 25\"))\n$ print(db.get(\"SELECT * FROM users WHERE age > ? AND name = ?\", ('25', 'Joan') ))\n```\n\nLicense\n----\n\nMIT\n\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": "sql,sql python,clear SQL,flask SQL,MYSQL,SQLITE3,postgresql",
        "license": "MIT",
        "maintainer": "",
        "maintainer_email": "",
        "name": "Rsql",
        "package_url": "https://pypi.org/project/Rsql/",
        "platform": "",
        "project_url": "https://pypi.org/project/Rsql/",
        "project_urls": null,
        "release_url": "https://pypi.org/project/Rsql/1.1/",
        "requires_dist": [
            "PyMySQL (==0.9.3)",
            "psycopg2 (==2.7.7)",
            "psycopg2-binary (==2.7.7)"
        ],
        "requires_python": "",
        "summary": "Rsql",
        "version": "1.1"
    },
    "last_serial": 4746534,
    "releases": {
        "0.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "dbd597c23c602ec22794f6a5e1243a16",
                    "sha256": "e9b9169eb4fe2715d0dfb2fd5767c30989a4fce5fb2b6aa58be41ef1cfddcfac"
                },
                "downloads": -1,
                "filename": "Rsql-0.1.tar.gz",
                "has_sig": false,
                "md5_digest": "dbd597c23c602ec22794f6a5e1243a16",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 958,
                "upload_time": "2018-12-20T17:18:47",
                "url": "https://files.pythonhosted.org/packages/a8/85/4bfe9bc2bcfa664028301190e35b855245cfabb182ead98e7aba1a427265/Rsql-0.1.tar.gz"
            }
        ],
        "0.2": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "cfed9a12da8ac4b382e2d81808aca34c",
                    "sha256": "0b34c16507ccbefd5c3542b2dc46cb443d4238a9d8fdb18467ed77250aae3584"
                },
                "downloads": -1,
                "filename": "Rsql-0.2-py2-none-any.whl",
                "has_sig": false,
                "md5_digest": "cfed9a12da8ac4b382e2d81808aca34c",
                "packagetype": "bdist_wheel",
                "python_version": "py2",
                "requires_python": null,
                "size": 1091,
                "upload_time": "2018-12-22T19:12:37",
                "url": "https://files.pythonhosted.org/packages/53/01/7f78b9219b2212925d2e86952a1a339ec1f95fcd0a89f8cdc7620e62db8d/Rsql-0.2-py2-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "d5c4f2247d51561e0c9f9fdbbd381173",
                    "sha256": "21b05022448fe684e2c96cafea45bf4cf46913688de076cd640c2ccdad1dae30"
                },
                "downloads": -1,
                "filename": "Rsql-0.2.tar.gz",
                "has_sig": false,
                "md5_digest": "d5c4f2247d51561e0c9f9fdbbd381173",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 901,
                "upload_time": "2018-12-22T19:12:38",
                "url": "https://files.pythonhosted.org/packages/62/cf/5903aff21ae42a33c2ba9efb7aa39c7e45d08a889d70cca8fc2486c4dbc4/Rsql-0.2.tar.gz"
            }
        ],
        "0.3": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "0814988e97b7967cb3c6abd65f021ef5",
                    "sha256": "a84824f5d5aabe3deab085986165628b740925c8d85d4e163b156ba1c8394cb4"
                },
                "downloads": -1,
                "filename": "Rsql-0.3-py2-none-any.whl",
                "has_sig": false,
                "md5_digest": "0814988e97b7967cb3c6abd65f021ef5",
                "packagetype": "bdist_wheel",
                "python_version": "py2",
                "requires_python": null,
                "size": 1829,
                "upload_time": "2018-12-23T06:38:26",
                "url": "https://files.pythonhosted.org/packages/ce/47/38c74202e03a21b2dd32e39bf35412c2dbe9f660b4f9b16037aec8e6ad37/Rsql-0.3-py2-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "593504d159edb8441d03ea84b5b60c8b",
                    "sha256": "5f8d7e1aa760b12451a60d0dc7bd258101747ab2bd204de70a78ed8f31b4de2e"
                },
                "downloads": -1,
                "filename": "Rsql-0.3.tar.gz",
                "has_sig": false,
                "md5_digest": "593504d159edb8441d03ea84b5b60c8b",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 903,
                "upload_time": "2018-12-23T06:38:27",
                "url": "https://files.pythonhosted.org/packages/08/11/6649924ba5275bcfa13ce96d35519850f9a74cea736341dcca83aaf60a3b/Rsql-0.3.tar.gz"
            }
        ],
        "0.33": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "b248a3c0ca664f211cffd94b1bfa42a0",
                    "sha256": "1ec3c6ad445964c775d97e5ba62e4006eee599012670d7187d928d99ef9ba1cf"
                },
                "downloads": -1,
                "filename": "Rsql-0.33-py2-none-any.whl",
                "has_sig": false,
                "md5_digest": "b248a3c0ca664f211cffd94b1bfa42a0",
                "packagetype": "bdist_wheel",
                "python_version": "py2",
                "requires_python": null,
                "size": 3177,
                "upload_time": "2018-12-23T07:29:36",
                "url": "https://files.pythonhosted.org/packages/64/c1/0ff162f686cddf2f28f93dfe9577cfdb1f4ee49f27441adec057e183a93b/Rsql-0.33-py2-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "2e4dbeb69c9a21b8fcd2b88244229820",
                    "sha256": "8fada77a4f0f513c568ee7be1f6328afe2615221bea90f6e9eafed79594bb6ba"
                },
                "downloads": -1,
                "filename": "Rsql-0.33.tar.gz",
                "has_sig": false,
                "md5_digest": "2e4dbeb69c9a21b8fcd2b88244229820",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 903,
                "upload_time": "2018-12-23T07:16:35",
                "url": "https://files.pythonhosted.org/packages/e7/cc/e8cef223ae4aac408e61c11a79be75a947534b104ac7890543491462b1d2/Rsql-0.33.tar.gz"
            }
        ],
        "0.4": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "5971fe46b1395c001c41a1518359ad25",
                    "sha256": "6ab7aab547f516f5511fddc3517526aec1bd8b460200b0363190a9191f565e97"
                },
                "downloads": -1,
                "filename": "Rsql-0.4-py2-none-any.whl",
                "has_sig": false,
                "md5_digest": "5971fe46b1395c001c41a1518359ad25",
                "packagetype": "bdist_wheel",
                "python_version": "py2",
                "requires_python": null,
                "size": 3159,
                "upload_time": "2018-12-23T07:30:25",
                "url": "https://files.pythonhosted.org/packages/2a/45/b7a4223228a4da490c7e2c448d2ad55e6187ccba1411a669ae02472f62c2/Rsql-0.4-py2-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "2fe1cbb0d899ddb447f4b86fe1c01c2c",
                    "sha256": "9434fa0b6e6e8057b46108ef86db13731696d9d063733460d9e60a5f4430f3d0"
                },
                "downloads": -1,
                "filename": "Rsql-0.4.tar.gz",
                "has_sig": false,
                "md5_digest": "2fe1cbb0d899ddb447f4b86fe1c01c2c",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 1422,
                "upload_time": "2018-12-23T07:30:26",
                "url": "https://files.pythonhosted.org/packages/91/00/082fffb20e46481a92d50aa4eb88d46988989139f1c12c66487ae3b4a189/Rsql-0.4.tar.gz"
            }
        ],
        "0.45": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "76caccdbc01ce1ca51fa01a2839c5e8d",
                    "sha256": "33215b48ecf924ca35c19b3bb3c14935dd2ca8e94ad4011ee9b7b9a85e66a9b0"
                },
                "downloads": -1,
                "filename": "Rsql-0.45.tar.gz",
                "has_sig": false,
                "md5_digest": "76caccdbc01ce1ca51fa01a2839c5e8d",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 1435,
                "upload_time": "2018-12-23T07:36:46",
                "url": "https://files.pythonhosted.org/packages/7d/80/d567941aeda74737f4eb97186356a5baac07683c9b5438e1f186e7bb09c3/Rsql-0.45.tar.gz"
            }
        ],
        "0.5": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "814954a1d4497a834652c078306791d2",
                    "sha256": "4734bed9660c1fa7d4f5b0b6247e4841ac6c2abdd6d6e18829c36e4a4a1873bd"
                },
                "downloads": -1,
                "filename": "Rsql-0.5.tar.gz",
                "has_sig": false,
                "md5_digest": "814954a1d4497a834652c078306791d2",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 1490,
                "upload_time": "2018-12-23T11:41:48",
                "url": "https://files.pythonhosted.org/packages/0a/e0/ea75ed713566edddcf40d0e7874d87ba09e4e6f88b74a13261e581d025eb/Rsql-0.5.tar.gz"
            }
        ],
        "1.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "cea3fd3ed2604cb00f149de7a01d0522",
                    "sha256": "2b35ae757c723ae72073c6d694b7c73cf735ad361c344e402ffb3a9c14059294"
                },
                "downloads": -1,
                "filename": "Rsql-1.0-py2-none-any.whl",
                "has_sig": false,
                "md5_digest": "cea3fd3ed2604cb00f149de7a01d0522",
                "packagetype": "bdist_wheel",
                "python_version": "py2",
                "requires_python": null,
                "size": 6930,
                "upload_time": "2019-01-27T16:05:14",
                "url": "https://files.pythonhosted.org/packages/12/3a/91262c2228ecf1773d3e32f8960251ad4c14cda8c45328deb9316b71c9cb/Rsql-1.0-py2-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "3f7c293faa62f5946141bd5ddccdaa81",
                    "sha256": "7586ecd9d33db7ce531be8aaf42c14e55f89c2da49f40cb56c425c56e9532881"
                },
                "downloads": -1,
                "filename": "Rsql-1.0-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "3f7c293faa62f5946141bd5ddccdaa81",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 4929,
                "upload_time": "2019-01-27T17:02:10",
                "url": "https://files.pythonhosted.org/packages/1d/31/4ab953135ca203456935facb72a3e044db8de1788556fbdd0103236dbeb0/Rsql-1.0-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "e7786aff823969c23cda22d870547cfb",
                    "sha256": "016c516f8d14dac8b7f194d4886f5f6cf523ce6cd8b0126a099590cdd1b8777b"
                },
                "downloads": -1,
                "filename": "Rsql-1.0.tar.gz",
                "has_sig": false,
                "md5_digest": "e7786aff823969c23cda22d870547cfb",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 3331,
                "upload_time": "2019-01-27T16:05:16",
                "url": "https://files.pythonhosted.org/packages/78/6e/ee9a6266f3e6c2f941443c7ec8988760db759f92f9fe86305d486763415a/Rsql-1.0.tar.gz"
            }
        ],
        "1.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "f228dd141a6b83c2c56b1a3ce7890c7a",
                    "sha256": "3ea252ef8d4ae45935ff0a260e157c304a08289869ee6f72305f0eaddb816b1e"
                },
                "downloads": -1,
                "filename": "Rsql-1.1-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "f228dd141a6b83c2c56b1a3ce7890c7a",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 4927,
                "upload_time": "2019-01-27T17:02:52",
                "url": "https://files.pythonhosted.org/packages/33/80/b9fdfa664274cdfe8faa96fa6a561cada405c37ad3793c287f0279584734/Rsql-1.1-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "af2ac47087485883e0a06dc1c1bfafb8",
                    "sha256": "889db0d9a38d4a936e32095281a62aa1ffda39f55ffb17c7cd7a52b46bdae588"
                },
                "downloads": -1,
                "filename": "Rsql-1.1.tar.gz",
                "has_sig": false,
                "md5_digest": "af2ac47087485883e0a06dc1c1bfafb8",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 3349,
                "upload_time": "2019-01-27T17:02:54",
                "url": "https://files.pythonhosted.org/packages/fb/c6/65d81f6a231d12869efa013659935639f8236bab57e8cf5a05ad417bf0c9/Rsql-1.1.tar.gz"
            }
        ]
    },
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "f228dd141a6b83c2c56b1a3ce7890c7a",
                "sha256": "3ea252ef8d4ae45935ff0a260e157c304a08289869ee6f72305f0eaddb816b1e"
            },
            "downloads": -1,
            "filename": "Rsql-1.1-py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "f228dd141a6b83c2c56b1a3ce7890c7a",
            "packagetype": "bdist_wheel",
            "python_version": "py3",
            "requires_python": null,
            "size": 4927,
            "upload_time": "2019-01-27T17:02:52",
            "url": "https://files.pythonhosted.org/packages/33/80/b9fdfa664274cdfe8faa96fa6a561cada405c37ad3793c287f0279584734/Rsql-1.1-py3-none-any.whl"
        },
        {
            "comment_text": "",
            "digests": {
                "md5": "af2ac47087485883e0a06dc1c1bfafb8",
                "sha256": "889db0d9a38d4a936e32095281a62aa1ffda39f55ffb17c7cd7a52b46bdae588"
            },
            "downloads": -1,
            "filename": "Rsql-1.1.tar.gz",
            "has_sig": false,
            "md5_digest": "af2ac47087485883e0a06dc1c1bfafb8",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 3349,
            "upload_time": "2019-01-27T17:02:54",
            "url": "https://files.pythonhosted.org/packages/fb/c6/65d81f6a231d12869efa013659935639f8236bab57e8cf5a05ad417bf0c9/Rsql-1.1.tar.gz"
        }
    ]
}