{ "info": { "author": "plausibility", "author_email": "chris@gibsonsec.org", "bugtrack_url": null, "classifiers": [ "Development Status :: 5 - Production/Stable", "Intended Audience :: Developers", "License :: OSI Approved :: MIT License", "Operating System :: OS Independent", "Programming Language :: Python :: 2", "Topic :: Database" ], "description": "======\npysqlw\n======\n\n.. _MySQLdb: http://sourceforge.net/projects/mysql-python/\n.. _This link: http://blog.mysqlboy.com/2010/08/installing-mysqldb-python-module.html\n.. _readthedocs: https://pysqlw.readthedocs.org\n.. _pysqlw wrappers: https://pysqlw.readthedocs.org/en/latest/wrappers.html\n.. _github repo: https://github.com/plausibility/pysqlw\n.. _with: https://pysqlw.readthedocs.org/en/latest/usage.html#with-pysqlw-as-p\n\nA Python based wrapper (meta-wrapper, even) allowing easy MySQL and SQLite interactions.\n\nRequirements\n============\n\n- Python 2.7.3 (this is what I test with, should work with most 2.x; 3.x not guaranteed without porting)\n- sqlite3 module (comes with Python installs)\n- Install `MySQLdb`_ if you want MySQL support\n\n - If you\u2019re using a Debian-like distro (Ubuntu, Debian, Crunchbang, etc), install the package **python-mysqldb**\n\n - ``$ sudo apt-get install python-mysqldb``\n\n - There is no pypi package (someone get on this)\n - If that didn\u2019t work, or you\u2019re not using a Debian-like distro:\n\n - Build and install the MySQLdb module from source.\n - `This link`_ explains better than I could.\n\n - Verify it\u2019s installed: ``$ python -c 'import MySQLdb'``\n\n - If nothing shows up, you\u2019re good!\n - If you get an ImportError, think, do you **really** need MySQL?\n - If yes, this is a problem, and I can't really help. :(\n - If you don't, just use sqlite, it's much easier.\n\nUsage\n=====\n\n- Install pysqlw: ``$ pip install pysqlw``\n- Import pysqlw:\n\n - ``import pysqlw``\n\n- Create a new instance:\n\n - ``p = pysqlw.pysqlw(db_type=\"sqlite\", db_path=\"/home/user/example.db\")``\n - If you want to use MySQL you need to supply more details:\n - ``p = pysqlw.pysqlw(db_type=\"mysql\", db_host=\"localhost\", db_user=\"username\", db_pass=\"password\", db_name=\"database_name\")``\n - Alternatively, you can use it with Python's `with`_ statement.\n\n- Documentation is now on the pysqlw `readthedocs`_ entry.\n\nContributing\n============\nIf you're interested, you can write extra meta-wrappers for foreign database types. \nThey're pretty simple, look at the `pysqlw wrappers`_ documentation page for an example.\n\nIf there's not a wrapper for a database type you'd like (that is, an actual wrapper, not just a meta-wrapper), you should make one of those and send in some pull requests with meta-wrappers! More coverage is great.\n\nIf you wish to help contribute to the base wrapper functions, feel free to fork the `github repo`_ and send in pull requests!", "description_content_type": null, "docs_url": null, "download_url": "", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/plausibility/pysqlw", "keywords": "sql sqlite mysql wrapper", "license": "MIT", "maintainer": "", "maintainer_email": "", "name": "pysqlw", "package_url": "https://pypi.org/project/pysqlw/", "platform": "UNKNOWN", "project_url": "https://pypi.org/project/pysqlw/", "project_urls": { "Homepage": "https://github.com/plausibility/pysqlw" }, "release_url": "https://pypi.org/project/pysqlw/1.3.1/", "requires_dist": null, "requires_python": "", "summary": "Python wrapper to make interacting with SQL databases easy", "version": "1.3.1" }, "last_serial": 2343540, "releases": { "1.0.0": [ { "comment_text": "", "digests": { "md5": "e1a9e490ffe6b98cced45eba10eb7e18", "sha256": "0d77c5b9c25984f0888220d92ee12ba79aa3211dae9af48352fd4c4ad17b2e63" }, "downloads": -1, "filename": "pysqlw-1.0.0.tar.gz", "has_sig": false, "md5_digest": "e1a9e490ffe6b98cced45eba10eb7e18", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5071, "upload_time": "2013-01-15T07:00:25", "url": "https://files.pythonhosted.org/packages/ab/1a/52850904b6fabd20e899790219bb389d29e85765478829feafb085a8356b/pysqlw-1.0.0.tar.gz" } ], "1.1.0": [ { "comment_text": "", "digests": { "md5": "a422942b5620c8d4bcfeb2f8607c2b0f", "sha256": "76a62faa29da375a7faacdbbce0cad53d0d583d3d203e8761272988f88aab1f8" }, "downloads": -1, "filename": "pysqlw-1.1.0.tar.gz", "has_sig": false, "md5_digest": "a422942b5620c8d4bcfeb2f8607c2b0f", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5407, "upload_time": "2013-01-15T09:11:31", "url": "https://files.pythonhosted.org/packages/7b/82/0bf99a1795f6c094700db29d6c97dc87c6435feece5adb052eb9fe66ce51/pysqlw-1.1.0.tar.gz" } ], "1.1.1": [ { "comment_text": "", "digests": { "md5": "e5e7f8c70601271df4c26ad88c7ef33f", "sha256": "06a4284abe2d78ecdf53ccb4ce5f4cc88267329f8eb9f4ac46ff677c9ef61de0" }, "downloads": -1, "filename": "pysqlw-1.1.1.tar.gz", "has_sig": false, "md5_digest": "e5e7f8c70601271df4c26ad88c7ef33f", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5869, "upload_time": "2013-01-16T05:50:31", "url": "https://files.pythonhosted.org/packages/a1/00/c78465d4326e6b480daf91b4142c7bc94600fef330bca84c03d69bdfd1c6/pysqlw-1.1.1.tar.gz" } ], "1.1.2": [ { "comment_text": "", "digests": { "md5": "d014a3258ae2942713bf3c708d417865", "sha256": "3fa63728b234ff7b55abf4f9927f57d62efb3ed6e5c03e045fa63c9af3aec203" }, "downloads": -1, "filename": "pysqlw-1.1.2.tar.gz", "has_sig": false, "md5_digest": "d014a3258ae2942713bf3c708d417865", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5941, "upload_time": "2013-01-17T12:24:59", "url": "https://files.pythonhosted.org/packages/e6/83/45f06b199407477f27657b3163992fd95999fa6e1f3f673627a64708b43f/pysqlw-1.1.2.tar.gz" } ], "1.2.0": [ { "comment_text": "", "digests": { "md5": "a04ae5f027b5c04ce0a7556114c323b4", "sha256": "12c79cfb02fc5af931a3433e8dbf775e7a83ab1d287b6701a0088eae132de9c0" }, "downloads": -1, "filename": "pysqlw-1.2.0.tar.gz", "has_sig": false, "md5_digest": "a04ae5f027b5c04ce0a7556114c323b4", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 6070, "upload_time": "2013-01-17T13:13:53", "url": "https://files.pythonhosted.org/packages/42/ce/7241785ae998e72ff45a4ee129e7227edd994efbc3ac3eb1b016f3934bff/pysqlw-1.2.0.tar.gz" } ], "1.2.1": [ { "comment_text": "", "digests": { "md5": "f3b018dc961eac63d6aa5d58f8d0516f", "sha256": "706eb1e2fa2e1658294b9de1e538ff458b543a069c84acc3ca33a296448d32a4" }, "downloads": -1, "filename": "pysqlw-1.2.1.tar.gz", "has_sig": false, "md5_digest": "f3b018dc961eac63d6aa5d58f8d0516f", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 6279, "upload_time": "2013-01-21T12:55:09", "url": "https://files.pythonhosted.org/packages/17/fb/edf601fade4372429782ddbde411666d7a13fd08742211825b4969cdc255/pysqlw-1.2.1.tar.gz" } ], "1.3.0": [ { "comment_text": "", "digests": { "md5": "1afaae701ce495583510ad1d3fc72719", "sha256": "d10ffe9c2ae13122e504a8073f8affdb80cda6f74d850d6c95589d86c49e9d8d" }, "downloads": -1, "filename": "pysqlw-1.3.0.tar.gz", "has_sig": false, "md5_digest": "1afaae701ce495583510ad1d3fc72719", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 6408, "upload_time": "2013-01-21T14:16:29", "url": "https://files.pythonhosted.org/packages/91/20/ae19bd9f9dd751c6f927c7d9818fb6e4da5ee7b3f79a1aaaee091f9968cf/pysqlw-1.3.0.tar.gz" } ], "1.3.1": [ { "comment_text": "", "digests": { "md5": "9da12eaac22893f66ba2cabef25a479d", "sha256": "98d6a351b205d648fda4534d9ec8ed369ca455d6c36f9e4de1d81a03f1e5a463" }, "downloads": -1, "filename": "pysqlw-1.3.1.tar.gz", "has_sig": false, "md5_digest": "9da12eaac22893f66ba2cabef25a479d", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 6348, "upload_time": "2016-09-15T04:06:27", "url": "https://files.pythonhosted.org/packages/82/73/22ac0a4cc7dc4eb13ca9f52d52e76c2a30b337d402ccbc1925397fa498ff/pysqlw-1.3.1.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "9da12eaac22893f66ba2cabef25a479d", "sha256": "98d6a351b205d648fda4534d9ec8ed369ca455d6c36f9e4de1d81a03f1e5a463" }, "downloads": -1, "filename": "pysqlw-1.3.1.tar.gz", "has_sig": false, "md5_digest": "9da12eaac22893f66ba2cabef25a479d", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 6348, "upload_time": "2016-09-15T04:06:27", "url": "https://files.pythonhosted.org/packages/82/73/22ac0a4cc7dc4eb13ca9f52d52e76c2a30b337d402ccbc1925397fa498ff/pysqlw-1.3.1.tar.gz" } ] }