{ "info": { "author": "Joumaico Maulas", "author_email": "maulasjoumaico@gmail.com", "bugtrack_url": null, "classifiers": [ "Development Status :: 5 - Production/Stable", "License :: OSI Approved :: MIT License", "Operating System :: OS Independent", "Programming Language :: Python :: 3.6", "Programming Language :: Python :: 3.7" ], "description": "# DBEngine\n\nDescription\n\nDatabase Abstraction Layer for MySQL and SQLite3\n\nInstallation\n\n \tpip install dbengine\n\nExample\n\nTo create connection for SQLite3\n\n\tsqlite = DBEngine.sqlite(':memory:') # ':memory:' or 'filename.db'\n\nand for MySQL server\n\n\tmysql = DBEngine.mysql(host=str,port=int,user=str,password=str,database=str)\n\nTo create table named users\n\n\tsqlite.query = 'CREATE TABLE users (first_name STRING, last_name STRING)'\n\tsqlite.value = () # empty tuple if no arguments\n\tsqlite.write()\n\nTo insert single item: if database is MySQL use placeholder `%s` instead of `?`\n\n\tsqlite.query = 'INSERT INTO users VALUES (?,?)'\n\tsqlite.value = 'Taylor', 'Swift'\n\tprint('id:', sqlite.write())\n\nTo insert multiple items\n\n\tsqlite.query = 'INSERT INTO users VALUES (?,?)'\n\tsqlite.value = [('Rihanna', ''), ('Bruno', 'Mars'), ('Adele', '')]\n\tsqlite.write(bulk=True)\n\nTo select single item\n\n\tsqlite.query = 'SELECT * FROM users WHERE last_name = ?'\n\tsqlite.value = 'Mars', # a tuple containing a single value must include a comma\n\tprint('single-select:', sqlite.read())\n\nTo select multiple items\n\n\tsqlite.query = 'SELECT * FROM users WHERE last_name IS ?'\n\tsqlite.value = '',\n\tprint('multi-select:', sqlite.read(bulk=True))", "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/maulasjoumaico/dbengine", "keywords": "", "license": "", "maintainer": "", "maintainer_email": "", "name": "dbengine", "package_url": "https://pypi.org/project/dbengine/", "platform": "", "project_url": "https://pypi.org/project/dbengine/", "project_urls": { "Homepage": "https://github.com/maulasjoumaico/dbengine" }, "release_url": "https://pypi.org/project/dbengine/1.1/", "requires_dist": null, "requires_python": "", "summary": "Database Abstraction Layer for MySQL and SQLite3", "version": "1.1" }, "last_serial": 5831028, "releases": { "1.0": [ { "comment_text": "", "digests": { "md5": "00f101cd15812d58b12673a0c466e725", "sha256": "34b9ac8681ab2df8ba1512fbfb2a5d772a3b90e4805f57aa73ca3d22e6bfc3e6" }, "downloads": -1, "filename": "dbengine-1.0.tar.gz", "has_sig": false, "md5_digest": "00f101cd15812d58b12673a0c466e725", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 2404, "upload_time": "2019-09-01T06:10:02", "url": "https://files.pythonhosted.org/packages/78/db/d1d06aaa99533dbb75c2d08b866bc460e8e6fe5de2bcbbfed9ce1c0b641a/dbengine-1.0.tar.gz" } ], "1.1": [ { "comment_text": "", "digests": { "md5": "4b0be250932b5736b625a2156e58026f", "sha256": "9e281abfb220967cd541a6b9319c6ac9123d44e591b749de1c87f4954cf1137b" }, "downloads": -1, "filename": "dbengine-1.1.tar.gz", "has_sig": false, "md5_digest": "4b0be250932b5736b625a2156e58026f", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 2464, "upload_time": "2019-09-15T07:28:29", "url": "https://files.pythonhosted.org/packages/70/8b/b2ad01c76bd6176421da18a006c146739ba61cc047be79c0783b53d8886f/dbengine-1.1.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "4b0be250932b5736b625a2156e58026f", "sha256": "9e281abfb220967cd541a6b9319c6ac9123d44e591b749de1c87f4954cf1137b" }, "downloads": -1, "filename": "dbengine-1.1.tar.gz", "has_sig": false, "md5_digest": "4b0be250932b5736b625a2156e58026f", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 2464, "upload_time": "2019-09-15T07:28:29", "url": "https://files.pythonhosted.org/packages/70/8b/b2ad01c76bd6176421da18a006c146739ba61cc047be79c0783b53d8886f/dbengine-1.1.tar.gz" } ] }