{ "info": { "author": "stefanitsky", "author_email": "stefanitsky.mozdor@google.com", "bugtrack_url": null, "classifiers": [ "Development Status :: 3 - Alpha", "Intended Audience :: Developers", "License :: OSI Approved :: MIT License", "Operating System :: OS Independent", "Programming Language :: Python :: 3", "Programming Language :: Python :: 3.3", "Programming Language :: Python :: 3.4", "Programming Language :: Python :: 3.5", "Programming Language :: Python :: 3.6", "Programming Language :: Python :: 3.7", "Topic :: Database :: Front-Ends" ], "description": "[![Say Thanks!](https://img.shields.io/badge/Say%20Thanks-!-1EAEDB.svg)](https://saythanks.io/to/Stefanitsky) [![PyPI version](https://badge.fury.io/py/dbcw.svg)](https://badge.fury.io/py/dbcw)\n# DBCW\n\nDBCW (Database Connection Wrapper) is a python package that allows you to connect to different types of databases and contains methods for getting the necessary data.\n\nThis is a good choice for you if you do not want to deal with queries to the database and you just need basic functionality for getting data.\n\nBut if you need to send your own query to the database - this is also possible.\n\nSupported engines: \n - PostgreSQL \n - MySQL / MariaDB\n\n## Documentation\n\nYou can run the [pydoc](https://docs.python.org/3/library/pydoc.html) module to read the documentation:\n```bash\npython -m pydoc -b\n```\n\n## Installation\n\nUse the package manager [pip](https://pip.pypa.io/en/stable/) to install dbcw.\n\n```bash\npip install dbcw\n```\n\n## Usage\n\n#### Import:\n```python\nfrom dbcw import DBConnectionWrapper\n```\n\n#### PostgreSQL connection\n```python\nconnection = DBConnectionWrapper(\n host='localhost', user='root', password='1234')\n```\n\n#### MySQL connection\n```python\nconnection = DBConnectionWrapper(\n engine='mysql', host='localhost', user='root', password='1234')\n```\n\n#### Get database list\n```python\n>>> connection.get_db_list()\n['db1', 'db2'] # output example\n```\n\n#### Get tables list from the database\n```python\n>>> connection.get_tables_list('db_name')\n[('friends', 'numbers')] # output example\n```\n\n#### Get table data\n```python\nconnection.get_table_data('db_name', 'table_name')\n```\n\n#### Get database structure (depends on engine)\n```python\nconnection.get_db_structure('db_name')\n```\n\n#### Get table structure (depends on engine)\n```python\nconnection.get_table_structure('db_name', 'table_name')\n```\n\n#### Execute custom query\n```python\nconnection.execute_query('SELECT * FROM table;')\n```\n\n## Contributing\nPull requests are welcome. For major changes, please open an issue first to discuss what you would like to change.\n\n## License\n[MIT](https://choosealicense.com/licenses/mit/)\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/Stefanitsky/dbcw", "keywords": "db database tool wrapper connection connect", "license": "", "maintainer": "", "maintainer_email": "", "name": "dbcw", "package_url": "https://pypi.org/project/dbcw/", "platform": "", "project_url": "https://pypi.org/project/dbcw/", "project_urls": { "Documentation": "https://github.com/Stefanitsky/dbcw/wiki", "Homepage": "https://github.com/Stefanitsky/dbcw", "Say Thanks!": "https://saythanks.io/to/Stefanitsky", "Source": "https://github.com/Stefanitsky/dbcw", "Tracker": "https://github.com/Stefanitsky/dbcw/issues" }, "release_url": "https://pypi.org/project/dbcw/0.2.3/", "requires_dist": [ "psycopg2", "mysql-connector" ], "requires_python": "", "summary": "Database connection wrapper", "version": "0.2.3" }, "last_serial": 5135026, "releases": { "0.1": [ { "comment_text": "", "digests": { "md5": "34dde2fbdcec537f08a9cab74230f70d", "sha256": "319c501821075d71ed9f2398525010ae4d6305c34140977d80f18b83dcb6a374" }, "downloads": -1, "filename": "dbcw-0.1-py3-none-any.whl", "has_sig": false, "md5_digest": "34dde2fbdcec537f08a9cab74230f70d", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 6749, "upload_time": "2019-04-02T13:40:49", "url": "https://files.pythonhosted.org/packages/a3/e4/b3d9a1f1932f79150fd6e59ce1c223cfa68f6a49785850d97bba179e4465/dbcw-0.1-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "6e3767ca0bc146ec9aafa298bed90666", "sha256": "8fedd2616f0f890e2185c12cc23edd6d5bab33d3a69bbbe0f2b65d843edba2eb" }, "downloads": -1, "filename": "dbcw-0.1.tar.gz", "has_sig": false, "md5_digest": "6e3767ca0bc146ec9aafa298bed90666", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3252, "upload_time": "2019-04-02T13:40:51", "url": "https://files.pythonhosted.org/packages/00/1a/8529b6a1769718c086036e034c8f7883ebfc3147987efc2795215645e810/dbcw-0.1.tar.gz" } ], "0.2": [ { "comment_text": "", "digests": { "md5": "af868bc47a894d10aa22d95cab47e61f", "sha256": "0e2aeefae3d2f9c4efd9fe6604a4782110b9797981943cce29caf4c350a75be4" }, "downloads": -1, "filename": "dbcw-0.2-py3-none-any.whl", "has_sig": false, "md5_digest": "af868bc47a894d10aa22d95cab47e61f", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 7648, "upload_time": "2019-04-02T15:14:15", "url": "https://files.pythonhosted.org/packages/63/f3/8bc3cc1abef78fd1dd4140e6e0a1857a66ff641b82e2775ec7289b817be3/dbcw-0.2-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "3d52313c96d0ca1729d73ae8674acd84", "sha256": "b27e9d3e6cfce9f4cfe91b80eb452051a25510cf976d0ade3b2071054a24d07d" }, "downloads": -1, "filename": "dbcw-0.2.tar.gz", "has_sig": false, "md5_digest": "3d52313c96d0ca1729d73ae8674acd84", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4292, "upload_time": "2019-04-02T15:14:17", "url": "https://files.pythonhosted.org/packages/1a/28/bcebbda627bf585b1eeeee0d36dbe5e8ed208616cb36ba3b7fe89c05ce1e/dbcw-0.2.tar.gz" } ], "0.2.1": [ { "comment_text": "", "digests": { "md5": "920a0ca11934c6412d2f2931c8760001", "sha256": "201160e948fc5d3130d722b35d2f88ddc653b3dfec6e45ea25fcfde0ed2c6eff" }, "downloads": -1, "filename": "dbcw-0.2.1-py3-none-any.whl", "has_sig": false, "md5_digest": "920a0ca11934c6412d2f2931c8760001", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 8107, "upload_time": "2019-04-02T15:22:16", "url": "https://files.pythonhosted.org/packages/58/4d/24bb028bce7102a4f7152e7b77f011f753488e9854b4d6c8c72530a31fee/dbcw-0.2.1-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "dc5010f62b463a91bbfe98a54d18e0c1", "sha256": "72650003671e2e8eab3ae94ded946ef2947153e62509741ced73ba3f25ba6874" }, "downloads": -1, "filename": "dbcw-0.2.1.tar.gz", "has_sig": false, "md5_digest": "dc5010f62b463a91bbfe98a54d18e0c1", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4561, "upload_time": "2019-04-12T14:04:35", "url": "https://files.pythonhosted.org/packages/64/3d/9eb0be053f97a685696d6d6dcc8c5ad927aae417d5aabe40fd80a4e25c58/dbcw-0.2.1.tar.gz" } ], "0.2.2": [ { "comment_text": "", "digests": { "md5": "18000a90bc93ab21de8c48cb983a90d1", "sha256": "6ad289cdb823f41e4a6b6ba8b11640a0ebee0ef5c10222a1e23d6031a2b85ddd" }, "downloads": -1, "filename": "dbcw-0.2.2-py3-none-any.whl", "has_sig": false, "md5_digest": "18000a90bc93ab21de8c48cb983a90d1", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 8482, "upload_time": "2019-04-12T14:04:34", "url": "https://files.pythonhosted.org/packages/5d/06/4b2c455dfcaf1a028d48766f79d486f42021ae941c986fac096fd29717d6/dbcw-0.2.2-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "d1abb1d41df20b7c50e04839be396ba6", "sha256": "a57b3bf40d4dcfcd9bd9cc45239c4f7eabeee3a43f668045fd980ead2ee59f04" }, "downloads": -1, "filename": "dbcw-0.2.2.tar.gz", "has_sig": false, "md5_digest": "d1abb1d41df20b7c50e04839be396ba6", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4559, "upload_time": "2019-04-12T14:04:36", "url": "https://files.pythonhosted.org/packages/8e/45/22e48a904a63d6089fc3176814f29177e85a8a281cee218d5090b4cb1649/dbcw-0.2.2.tar.gz" } ], "0.2.3": [ { "comment_text": "", "digests": { "md5": "d9b0b145a0d837b968ece1cc2c8180b3", "sha256": "b47d50dfa520866bcd78972e86809dc4e50f80e6c8f5e8297ff88d90318ecaec" }, "downloads": -1, "filename": "dbcw-0.2.3-py3-none-any.whl", "has_sig": false, "md5_digest": "d9b0b145a0d837b968ece1cc2c8180b3", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 8494, "upload_time": "2019-04-12T17:56:41", "url": "https://files.pythonhosted.org/packages/14/89/24992caa3ce316fa745c9271a2f585dd689b855f0cb00be9f1c35cf8b307/dbcw-0.2.3-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "07e3c757ebdc804d1973df8688e9bae1", "sha256": "9e49b42c67a67fc2ecc9e3577f8e4a3992388f98c21f6f58c880b7baf69e81bb" }, "downloads": -1, "filename": "dbcw-0.2.3.tar.gz", "has_sig": false, "md5_digest": "07e3c757ebdc804d1973df8688e9bae1", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4555, "upload_time": "2019-04-12T17:56:51", "url": "https://files.pythonhosted.org/packages/d4/58/bc8ca6f56918230e2f0492e9c258b3be58667cf32c87ec572c3788d475e5/dbcw-0.2.3.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "d9b0b145a0d837b968ece1cc2c8180b3", "sha256": "b47d50dfa520866bcd78972e86809dc4e50f80e6c8f5e8297ff88d90318ecaec" }, "downloads": -1, "filename": "dbcw-0.2.3-py3-none-any.whl", "has_sig": false, "md5_digest": "d9b0b145a0d837b968ece1cc2c8180b3", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 8494, "upload_time": "2019-04-12T17:56:41", "url": "https://files.pythonhosted.org/packages/14/89/24992caa3ce316fa745c9271a2f585dd689b855f0cb00be9f1c35cf8b307/dbcw-0.2.3-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "07e3c757ebdc804d1973df8688e9bae1", "sha256": "9e49b42c67a67fc2ecc9e3577f8e4a3992388f98c21f6f58c880b7baf69e81bb" }, "downloads": -1, "filename": "dbcw-0.2.3.tar.gz", "has_sig": false, "md5_digest": "07e3c757ebdc804d1973df8688e9bae1", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4555, "upload_time": "2019-04-12T17:56:51", "url": "https://files.pythonhosted.org/packages/d4/58/bc8ca6f56918230e2f0492e9c258b3be58667cf32c87ec572c3788d475e5/dbcw-0.2.3.tar.gz" } ] }