{ "info": { "author": "Jakub Jane\u010dek", "author_email": "Jakub.Janecek@firma.seznam.cz", "bugtrack_url": null, "classifiers": [], "description": "WrappyDatabase\n==========\n\nPython module with universal interface for PostgreSQL and MySQL.\n\n```python\nfrom WrappyDatabase import Database\n\n\n# DSN\nd = Database(\"scheme://user[:pass]@host[:port]/my_db\")\n# DSN for MySQL\nmysql = Database(\"mysql://root@localhost/mysql\")\n# DSN for PostgreSQL\npostgres = Database(\"postgresql://root:toot@dbsrv:5432/db\")\n\n# Or arguments\ndb = Database(host=\"host\", usr=\"root\", passwd=\"\", db=\"test\", driver=Database.POSTGRESQL)\n\n# Use\ndb.query(\"SELECT * FROM my_tbl WHERE deleted = %s\", [0]).fetch()\ndb.query(\"SELECT * FROM my_tbl WHERE deleted = %(deleted)s\", {\"deleted\": 0}).fetch_all()\n\n# SqlBuilder\ndb.table(\"my_tbl\").fetch()\ndb.table(\"my_tbl\").where(\"id IN %(ids)s\", {\"ids\": [1, 2, 3]}).delete()\ndb.table(\"my_tbl\").insert({\n \"a\": 1,\n \"b\": \"string\",\n})\ndb.table(\"my_tbl\").where(\"author = %s\", [1]).update({\n \"author\": 2\n})\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": "https://github.com/geekmoss/WrappyDatabase", "keywords": "", "license": "MIT", "maintainer": "", "maintainer_email": "", "name": "WrappyDatabase", "package_url": "https://pypi.org/project/WrappyDatabase/", "platform": "", "project_url": "https://pypi.org/project/WrappyDatabase/", "project_urls": { "Homepage": "https://github.com/geekmoss/WrappyDatabase" }, "release_url": "https://pypi.org/project/WrappyDatabase/1.0.3/", "requires_dist": [ "psycopg2-binary", "pymysql" ], "requires_python": "", "summary": "Python module with universal interface for PostgreSQL and MySQL.", "version": "1.0.3" }, "last_serial": 4716071, "releases": { "1.0.1": [ { "comment_text": "", "digests": { "md5": "aee231aff2e27a3b2182dfa1d65a47bf", "sha256": "5b1cd7f57b5360a2ddcacadbc9acb8e82e6f872ac6014a3cdd2a584c0e16728d" }, "downloads": -1, "filename": "WrappyDatabase-1.0.1.tar.gz", "has_sig": false, "md5_digest": "aee231aff2e27a3b2182dfa1d65a47bf", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4827, "upload_time": "2018-11-18T14:45:48", "url": "https://files.pythonhosted.org/packages/d2/03/680b5bb55cf19e074aa9ffc88bdb90a97b3a4626785e582b87145501cfe7/WrappyDatabase-1.0.1.tar.gz" } ], "1.0.2": [ { "comment_text": "", "digests": { "md5": "30fdf3fa373c9278c64e47bbf67bbc6d", "sha256": "b31786c8c70913284d14e2a7046c7d07aa3ca028543f7dcfc0acfc1a639d749c" }, "downloads": -1, "filename": "WrappyDatabase-1.0.2-py3-none-any.whl", "has_sig": false, "md5_digest": "30fdf3fa373c9278c64e47bbf67bbc6d", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 7668, "upload_time": "2018-12-30T14:48:58", "url": "https://files.pythonhosted.org/packages/89/be/d85ee7a0703578c09dd11a492ffabbd603c512fe275e9ab68b67586c9554/WrappyDatabase-1.0.2-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "1ed9e6e6061e753c1bb9f734b1b3a40c", "sha256": "3094989b1f5618a397ccd068c09e58d77b9bfd75cf20bae06cabe5cf3ed6ce50" }, "downloads": -1, "filename": "WrappyDatabase-1.0.2.tar.gz", "has_sig": false, "md5_digest": "1ed9e6e6061e753c1bb9f734b1b3a40c", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4870, "upload_time": "2018-12-30T14:49:00", "url": "https://files.pythonhosted.org/packages/72/98/70b2ece68b6684a9a3de1ca100aa3c6ab25641e63b5c51b7ca8f9afbd2bd/WrappyDatabase-1.0.2.tar.gz" } ], "1.0.3": [ { "comment_text": "", "digests": { "md5": "4a1ddbe80d5265d54bc51a7cd9b61c9b", "sha256": "2ebb11664e366cf5a7d9ccdd924e4e60249bd4a76ec56df71fbd8b2fe9bd8ef5" }, "downloads": -1, "filename": "WrappyDatabase-1.0.3.linux-x86_64.tar.gz", "has_sig": false, "md5_digest": "4a1ddbe80d5265d54bc51a7cd9b61c9b", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 11314, "upload_time": "2019-01-19T16:36:46", "url": "https://files.pythonhosted.org/packages/29/10/d4847ae45c9409b7dc0481b36976247f172cf4b836a4aabcab225b930764/WrappyDatabase-1.0.3.linux-x86_64.tar.gz" }, { "comment_text": "", "digests": { "md5": "a5289b17e79d127608fd845cfaeeacdb", "sha256": "88a6ac50a04904ce15935597d1373a358db1118c1f21cf7b98884051467f0030" }, "downloads": -1, "filename": "WrappyDatabase-1.0.3-py3-none-any.whl", "has_sig": false, "md5_digest": "a5289b17e79d127608fd845cfaeeacdb", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 7813, "upload_time": "2019-01-19T16:36:44", "url": "https://files.pythonhosted.org/packages/06/e3/9ea216efa735f018ab889b5581baaf522f1a20974873b1edd316e549c810/WrappyDatabase-1.0.3-py3-none-any.whl" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "4a1ddbe80d5265d54bc51a7cd9b61c9b", "sha256": "2ebb11664e366cf5a7d9ccdd924e4e60249bd4a76ec56df71fbd8b2fe9bd8ef5" }, "downloads": -1, "filename": "WrappyDatabase-1.0.3.linux-x86_64.tar.gz", "has_sig": false, "md5_digest": "4a1ddbe80d5265d54bc51a7cd9b61c9b", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 11314, "upload_time": "2019-01-19T16:36:46", "url": "https://files.pythonhosted.org/packages/29/10/d4847ae45c9409b7dc0481b36976247f172cf4b836a4aabcab225b930764/WrappyDatabase-1.0.3.linux-x86_64.tar.gz" }, { "comment_text": "", "digests": { "md5": "a5289b17e79d127608fd845cfaeeacdb", "sha256": "88a6ac50a04904ce15935597d1373a358db1118c1f21cf7b98884051467f0030" }, "downloads": -1, "filename": "WrappyDatabase-1.0.3-py3-none-any.whl", "has_sig": false, "md5_digest": "a5289b17e79d127608fd845cfaeeacdb", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 7813, "upload_time": "2019-01-19T16:36:44", "url": "https://files.pythonhosted.org/packages/06/e3/9ea216efa735f018ab889b5581baaf522f1a20974873b1edd316e549c810/WrappyDatabase-1.0.3-py3-none-any.whl" } ] }