{ "info": { "author": "Maxwel Dsouza", "author_email": "contact@comparnion.com", "bugtrack_url": null, "classifiers": [], "description": "MySqlDbHelper\n=============\n\nFor use with the mysqldb module for python\n\nUsage\n\n::\n\n import mysqldbhelper\n db = mysqldbhelper.DatabaseConnection('hostname',\n user='username',\n passwd='password',\n db='databasename')\n\nFor single transactions\n-----------------------\n\n::\n\n db.get_one('select book_name from book where isbn = %s', ('SOMEISBN',))\n\n\u2018limit 1\u2019 is automatically added\n\n::\n\n db.get_all('select book_name from book where author = %s', ('Richard Dawkins',))\n\n::\n\n db.put('''\n insert into book\n (book_name, book_author)\n values\n (%s, %s)''', ('Phantoms in the brain', 'V.S. Ramachandran')\n\nput can be used for insert, update and delete queries\n\n::\n\n db.put('''delete from book\n where\n book_author = %s''' ('Deepak Chopra',))\n\nFor multiple transcations that need to be run atomically\n--------------------------------------------------------\n\n::\n\n try:\n db.start()\n db.get(...)\n db.put(...)\n ...\n db.save()\n except Exception, e:\n db.rollback()\n raise\n\nUsed at `Comparnion.com`_\n\n.. _Comparnion.com: https://comparnion.com\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/comparnion/mysqldbhelper", "keywords": "mysql,mysqldb,wrapper", "license": "UNKNOWN", "maintainer": null, "maintainer_email": null, "name": "mysqldbhelper", "package_url": "https://pypi.org/project/mysqldbhelper/", "platform": "UNKNOWN", "project_url": "https://pypi.org/project/mysqldbhelper/", "project_urls": { "Download": "UNKNOWN", "Homepage": "https://github.com/comparnion/mysqldbhelper" }, "release_url": "https://pypi.org/project/mysqldbhelper/1.0.2/", "requires_dist": null, "requires_python": null, "summary": "A simple wrapper over mysqldb", "version": "1.0.2" }, "last_serial": 1943160, "releases": { "1.0.2": [ { "comment_text": "", "digests": { "md5": "0824ca30c707dfe7f02e3dd11360f7ea", "sha256": "2e82653eeaf8039f1271a589ab9151ad83eee8f86cdafb5eb2a13df07f18c354" }, "downloads": -1, "filename": "mysqldbhelper-1.0.2.tar.gz", "has_sig": false, "md5_digest": "0824ca30c707dfe7f02e3dd11360f7ea", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 2246, "upload_time": "2016-02-06T16:33:55", "url": "https://files.pythonhosted.org/packages/ae/c7/be946000109c01b382c2886e86ec9715142a840f09bd0a6a58f6136b1176/mysqldbhelper-1.0.2.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "0824ca30c707dfe7f02e3dd11360f7ea", "sha256": "2e82653eeaf8039f1271a589ab9151ad83eee8f86cdafb5eb2a13df07f18c354" }, "downloads": -1, "filename": "mysqldbhelper-1.0.2.tar.gz", "has_sig": false, "md5_digest": "0824ca30c707dfe7f02e3dd11360f7ea", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 2246, "upload_time": "2016-02-06T16:33:55", "url": "https://files.pythonhosted.org/packages/ae/c7/be946000109c01b382c2886e86ec9715142a840f09bd0a6a58f6136b1176/mysqldbhelper-1.0.2.tar.gz" } ] }