{ "info": { "author": "LeCuay", "author_email": "", "bugtrack_url": null, "classifiers": [ "Development Status :: 3 - Alpha", "License :: OSI Approved :: MIT License", "Operating System :: OS Independent", "Programming Language :: Python :: 3.6", "Topic :: Software Development :: Libraries", "Topic :: Software Development :: Libraries :: Python Modules", "Topic :: Utilities" ], "description": "# DBManager.py\n\n[![PyVersion](https://img.shields.io/badge/Python-3.6+-blue.svg)](https://www.python.org/)\n\nA library for Database Management that makes our development easier.\n\n## Compatibility\n\nThis module supports connections with **MySQL**, **PostgreSQL**, **SQL Server** and **SQLite3**.\n\n## Features\n\nThe module manage almost everything by itself, this means Opening/Closing connections, cursors and managing of Commits. \nSome of its features are:\n\n* `execute(sql)`: Executes either an SQL sentence or a *.sql* file. It also can return values from a *SELECT*.\n* `select(table, columns, condition, order)`: This method will return a list of selected values or just a value if *ResultSet* turns out to be just one.\n* `insert(table, values)`: Inserts values into a table by the folowwing syntax: `insert(\"test\", id=12, name=\"LeCuay\", money=32.12)`.\n* `update(table, condition, sets)`: Updates rows by the following syntax: `update(\"test\", \"name like '%Cuai%'\", name=\"LeCuay\", id=1, money=122.53)`.\n* `create_table(table, values)`: Creates a table with the params in `values` by the following syntax: `create_table(\"test\", id=\"INTEGER PRIMARY KEY\", name=\"VARCHAR(255)\"`.\n* `create_database(dbname)`: Manage the creation of a Database and its Isolation levels.\n* `callproc(name, params)`: Calls a stored procedure from the Database.\n\n## To-do List\n\n* [ ] Add compatibility with OracleDB.\n* [ ] Add compatibility with MongoDB.\n* [ ] Add more specific features for each Connection.\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/LeCuay/DBManager.py", "keywords": "", "license": "", "maintainer": "", "maintainer_email": "", "name": "DBManager", "package_url": "https://pypi.org/project/DBManager/", "platform": "", "project_url": "https://pypi.org/project/DBManager/", "project_urls": { "Homepage": "https://github.com/LeCuay/DBManager.py" }, "release_url": "https://pypi.org/project/DBManager/0.1.3/", "requires_dist": null, "requires_python": "", "summary": "Make Database Managing easier!", "version": "0.1.3" }, "last_serial": 4249224, "releases": { "0.1": [ { "comment_text": "", "digests": { "md5": "3c729771fe9fd3d1c5b6b6e1d66cfe39", "sha256": "d277452998b8394ae21fc9099450b46707b8688d823fbe29ade0577a0b371255" }, "downloads": -1, "filename": "DBManager-0.1-py3-none-any.whl", "has_sig": false, "md5_digest": "3c729771fe9fd3d1c5b6b6e1d66cfe39", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 6714, "upload_time": "2018-09-06T11:41:35", "url": "https://files.pythonhosted.org/packages/46/d8/0de979678a4ece0966b11c4ed4334bad5623d4e6d1d16d05d4a7789a3c42/DBManager-0.1-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "55ab7b72958d82b8fffeb00763aa5638", "sha256": "fd01ccca6eb21aeca8eb07326bcc8bcf7f47a15c990e5a2b83b3f1b23a5535e7" }, "downloads": -1, "filename": "DBManager-0.1.tar.gz", "has_sig": false, "md5_digest": "55ab7b72958d82b8fffeb00763aa5638", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 6092, "upload_time": "2018-09-06T11:41:36", "url": "https://files.pythonhosted.org/packages/bb/ab/4fb3f0ed16ccc48dac8f0fb95798a0d146a028afea363b24ec09338a28b1/DBManager-0.1.tar.gz" } ], "0.1.1": [ { "comment_text": "", "digests": { "md5": "99d9b06bf9a380b3112333e361a577db", "sha256": "cca4ff495d6cd7470dd52bfd982303e4c7c2db8a2db060df1d771a5e491a9d5f" }, "downloads": -1, "filename": "DBManager-0.1.1-py3-none-any.whl", "has_sig": false, "md5_digest": "99d9b06bf9a380b3112333e361a577db", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 7001, "upload_time": "2018-09-07T17:13:50", "url": "https://files.pythonhosted.org/packages/ff/42/774913a84c6e7e695ea0eab6d3ed038e0fdee499e4af838a76c81243c5d9/DBManager-0.1.1-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "a05ff842590098c168552ef1c3715b05", "sha256": "57578ff68ff6e3aa6c5e13ca22d2bf49f8e9aec29939dc9e467ab0c935a85274" }, "downloads": -1, "filename": "DBManager-0.1.1.tar.gz", "has_sig": false, "md5_digest": "a05ff842590098c168552ef1c3715b05", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 6343, "upload_time": "2018-09-07T17:13:53", "url": "https://files.pythonhosted.org/packages/3d/4d/444b673db1a849fd5f46d5a290708d4412ca6b791af8a634afc50b4f81c9/DBManager-0.1.1.tar.gz" } ], "0.1.3": [ { "comment_text": "", "digests": { "md5": "03e03c2d5b79659b3b2d80d8957b8f4c", "sha256": "85fcb975d45d8e755ccd192fad773641d90c616ecd53c997c8c4bb08992f7551" }, "downloads": -1, "filename": "DBManager-0.1.3-py3-none-any.whl", "has_sig": false, "md5_digest": "03e03c2d5b79659b3b2d80d8957b8f4c", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 7004, "upload_time": "2018-09-07T17:13:52", "url": "https://files.pythonhosted.org/packages/98/f1/aff6f7767528445784c40d01f5cec7f6adcb10a78e275e2dbf31cb44354b/DBManager-0.1.3-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "0ab1535bb0801f43e38543edcd955df1", "sha256": "917838e2fd5b18e9ea30dd450ee39bd83d4a0712f52ca45c25c7fde8cd0ba2b9" }, "downloads": -1, "filename": "DBManager-0.1.3.tar.gz", "has_sig": false, "md5_digest": "0ab1535bb0801f43e38543edcd955df1", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 6339, "upload_time": "2018-09-07T17:13:54", "url": "https://files.pythonhosted.org/packages/ca/99/0ec18006092cf6d309883e7ec9549d926b047e509b01c8e3d13af2ae16af/DBManager-0.1.3.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "03e03c2d5b79659b3b2d80d8957b8f4c", "sha256": "85fcb975d45d8e755ccd192fad773641d90c616ecd53c997c8c4bb08992f7551" }, "downloads": -1, "filename": "DBManager-0.1.3-py3-none-any.whl", "has_sig": false, "md5_digest": "03e03c2d5b79659b3b2d80d8957b8f4c", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 7004, "upload_time": "2018-09-07T17:13:52", "url": "https://files.pythonhosted.org/packages/98/f1/aff6f7767528445784c40d01f5cec7f6adcb10a78e275e2dbf31cb44354b/DBManager-0.1.3-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "0ab1535bb0801f43e38543edcd955df1", "sha256": "917838e2fd5b18e9ea30dd450ee39bd83d4a0712f52ca45c25c7fde8cd0ba2b9" }, "downloads": -1, "filename": "DBManager-0.1.3.tar.gz", "has_sig": false, "md5_digest": "0ab1535bb0801f43e38543edcd955df1", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 6339, "upload_time": "2018-09-07T17:13:54", "url": "https://files.pythonhosted.org/packages/ca/99/0ec18006092cf6d309883e7ec9549d926b047e509b01c8e3d13af2ae16af/DBManager-0.1.3.tar.gz" } ] }