{ "info": { "author": "Ben Dowling", "author_email": "ben.m.dowling@gmail.com", "bugtrack_url": null, "classifiers": [], "description": "# EasyDB\n\nA really simple **SQLite wrapper** that saves you from having to worry about creating tables or managing connections.\n\nIt can be used on existing SQLite database by simply passing in the database filename:\n\n```python\nfrom easydb import EasyDB\ndb = EasyDB('filename.db')\ncursor = db.query(\"SELECT * FROM mytable\")\n```\n\nNew databases can be creating by specifying your schema as a dictionary, eg:\n\n```python\nschema = {\n 'table_name': ['column_name column_type', \u2026],\n 'table_name': ['column_name column_type', \u2026],\n 'table_name': ['column_name column_type', \u2026]\n}\ndb = EasyDB('filename.db', schema)\n```\n\nIf the database file already exists then the schema won't be updated, but if it doesn't exist then it'll be created with the given schema. Here's a full example:\n\n```python\nfrom easydb import EasyDB\ndb = EasyDB('my.db', {'users': ['username text', 'description text']})\n\ndb.query(\"INSERT INTO users (username, description) VALUES (?, ?)\", ('ben', 'some sort of description'))\n\nfor result in db.query(\"SELECT * FROM users\"):\n print result\n# => ('ben', 'some sort of description')\n```", "description_content_type": null, "docs_url": null, "download_url": "UNKNOWN", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/coderholic/easydb", "keywords": "db database sqlite", "license": "MIT", "maintainer": null, "maintainer_email": null, "name": "easydb", "package_url": "https://pypi.org/project/easydb/", "platform": "UNKNOWN", "project_url": "https://pypi.org/project/easydb/", "project_urls": { "Download": "UNKNOWN", "Homepage": "https://github.com/coderholic/easydb" }, "release_url": "https://pypi.org/project/easydb/0.2/", "requires_dist": null, "requires_python": null, "summary": "Simple SQLite wrapper to make it easier to manage your database", "version": "0.2" }, "last_serial": 791494, "releases": { "0.1": [ { "comment_text": "", "digests": { "md5": "d9389bd3fb71f9d4db6944085cb44905", "sha256": "318bec4d8350622265031391400fde6eca7e688f05c7e78a45635cd5d72ad32f" }, "downloads": -1, "filename": "easydb-0.1.tar.gz", "has_sig": false, "md5_digest": "d9389bd3fb71f9d4db6944085cb44905", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 1932, "upload_time": "2012-03-05T17:43:16", "url": "https://files.pythonhosted.org/packages/b2/ae/7082b9f36523f03f7ba42712bb5c65defd511a3d76cae087e6f7cfc977e0/easydb-0.1.tar.gz" } ], "0.2": [ { "comment_text": "", "digests": { "md5": "5e4bb20b3ebcd48ae2a0e838916ba7c1", "sha256": "f0ccebb3268f4867cf696cbd9fdc1a6e6c25a03f30fb41fa6e3035d53a7309d5" }, "downloads": -1, "filename": "easydb-0.2.tar.gz", "has_sig": false, "md5_digest": "5e4bb20b3ebcd48ae2a0e838916ba7c1", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 1969, "upload_time": "2013-03-05T18:35:44", "url": "https://files.pythonhosted.org/packages/25/35/bf86c56d4c0f53e2b57d74f6f2a19d30905fec9e6534b835700a496acd08/easydb-0.2.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "5e4bb20b3ebcd48ae2a0e838916ba7c1", "sha256": "f0ccebb3268f4867cf696cbd9fdc1a6e6c25a03f30fb41fa6e3035d53a7309d5" }, "downloads": -1, "filename": "easydb-0.2.tar.gz", "has_sig": false, "md5_digest": "5e4bb20b3ebcd48ae2a0e838916ba7c1", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 1969, "upload_time": "2013-03-05T18:35:44", "url": "https://files.pythonhosted.org/packages/25/35/bf86c56d4c0f53e2b57d74f6f2a19d30905fec9e6534b835700a496acd08/easydb-0.2.tar.gz" } ] }