{ "info": { "author": "Randy Yoon", "author_email": "randy.yoon@dailyhotel.com", "bugtrack_url": null, "classifiers": [ "Intended Audience :: Developers", "License :: OSI Approved :: MIT License", "Programming Language :: Python :: 2", "Programming Language :: Python :: 2.7", "Programming Language :: Python :: 3", "Programming Language :: Python :: 3.4", "Programming Language :: Python :: 3.5", "Programming Language :: Python :: 3.6", "Topic :: Database" ], "description": ".. image:: https://img.shields.io/badge/license-MIT-blue.svg\n :target: https://github.com/PyMySQL/PyMySQL/blob/master/LICENSE\n\n\nPyMySQLProxyCursor\n==================\n\n\nA simple cursor wrapper to support before/after processing using PyMySQL.\n\n\nInstallation\n------------\n\nThe last stable release is available on PyPI and can be installed with ``pip``::\n\n $ pip install PyMySQLProxyCursor\n\nExample\n-------\n\n.. code:: python\n\n from __future__ import print_function\n\n import pymysql\n import proxycursor\n\n class SimpleProxy(object):\n def __init__(self):\n self.tblname = 'user'\n\n def after_insert(self, **kwargs):\n cur = kwargs['cursor']\n cur.execute('SELECT LAST_INSERT_ID()')\n\n def after_update(self, **kwargs):\n cur = kwargs['cursor']\n cur.execute('SELECT * FROM user ORDER BY updated_at desc LIMIT 1')\n\n\n conn = pymysql.connect(host='localhost', port=3306, user='root', passwd='', db='mysql')\n\n cur = conn.cursor()\n cur = proxycursor.wrap(cur, handlers=[SimpleProxy()])\n cur.execute(\"SELECT Host,User FROM user\")\n\n print(cur.description)\n\n print()\n\n for row in cur:\n print(row)\n\n cur.close()\n conn.close()\n\nLicense\n-------\n\nPyMySQLProxyCursor is released under the MIT License. See LICENSE for more information.\n", "description_content_type": null, "docs_url": null, "download_url": "", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/DailyHotel/PyMySQLProxyCursor/", "keywords": "", "license": "MIT", "maintainer": "", "maintainer_email": "", "name": "PyMySQLProxyCursor", "package_url": "https://pypi.org/project/PyMySQLProxyCursor/", "platform": "", "project_url": "https://pypi.org/project/PyMySQLProxyCursor/", "project_urls": { "Homepage": "https://github.com/DailyHotel/PyMySQLProxyCursor/" }, "release_url": "https://pypi.org/project/PyMySQLProxyCursor/0.2.5/", "requires_dist": null, "requires_python": "", "summary": "Simple PyMySQL ProxyCursor", "version": "0.2.5" }, "last_serial": 3060586, "releases": { "0.2.1": [ { "comment_text": "", "digests": { "md5": "8c9a541d4ccd05a1d8ca77a6eca20225", "sha256": "b015ec912169070112d3d08d035ea279e0cad9fc78ce7cc8b884420e6078be0e" }, "downloads": -1, "filename": "PyMySQLProxyCursor-0.2.1.tar.gz", "has_sig": true, "md5_digest": "8c9a541d4ccd05a1d8ca77a6eca20225", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3789, "upload_time": "2017-06-30T08:49:01", "url": "https://files.pythonhosted.org/packages/85/59/ec78d12e10b3eb6228895c451823893354fc6d8bb5e77ff12222dd8b5c9d/PyMySQLProxyCursor-0.2.1.tar.gz" } ], "0.2.2": [ { "comment_text": "", "digests": { "md5": "2783ba7d9252fa6f3aada761fa77d457", "sha256": "54ae8564aadf36e8196df7db57b34574ef3973ec5e5935a430f10c0b8cf3fb0f" }, "downloads": -1, "filename": "PyMySQLProxyCursor-0.2.2-py2-none-any.whl", "has_sig": true, "md5_digest": "2783ba7d9252fa6f3aada761fa77d457", "packagetype": "bdist_wheel", "python_version": "2.7", "requires_python": null, "size": 5928, "upload_time": "2017-07-03T09:06:24", "url": "https://files.pythonhosted.org/packages/53/37/75dcc5c4593141969de800cb066fe6d2b99ca6df0771f0086edea659a208/PyMySQLProxyCursor-0.2.2-py2-none-any.whl" }, { "comment_text": "", "digests": { "md5": "fd4b12a398bc3a2b38024a1bfd8f1068", "sha256": "b41f2ba1a4ac0cf127f85737ea69d2d76b35450a2fd19f2b49f39dddcee719c0" }, "downloads": -1, "filename": "PyMySQLProxyCursor-0.2.2.tar.gz", "has_sig": true, "md5_digest": "fd4b12a398bc3a2b38024a1bfd8f1068", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5830, "upload_time": "2017-07-03T09:06:20", "url": "https://files.pythonhosted.org/packages/52/68/ac18064078558d7d0a94e2598b287b108bad1c3b6057c9be2629d6dd1be3/PyMySQLProxyCursor-0.2.2.tar.gz" } ], "0.2.3": [ { "comment_text": "", "digests": { "md5": "a130f5cbf420342c70cbb9fbdf75ec17", "sha256": "4b389da573200d2c2d531ab22f379acfc2a14bd5e97321ad06bc19ca0df4db4b" }, "downloads": -1, "filename": "PyMySQLProxyCursor-0.2.3-py2-none-any.whl", "has_sig": true, "md5_digest": "a130f5cbf420342c70cbb9fbdf75ec17", "packagetype": "bdist_wheel", "python_version": "2.7", "requires_python": null, "size": 5902, "upload_time": "2017-07-05T07:34:26", "url": "https://files.pythonhosted.org/packages/c9/ef/0ae5a4e5b900f1029ab875eeba8e0372b28f988a1850e0bc9f1f7538dff0/PyMySQLProxyCursor-0.2.3-py2-none-any.whl" }, { "comment_text": "", "digests": { "md5": "5f3ed8ac1c5c89567ed8bee1d99d260f", "sha256": "65917220fcf5093d906347b3619b0f8704107a83aa2ab1420d3f0e0794898020" }, "downloads": -1, "filename": "PyMySQLProxyCursor-0.2.3.tar.gz", "has_sig": true, "md5_digest": "5f3ed8ac1c5c89567ed8bee1d99d260f", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 6466, "upload_time": "2017-07-05T07:34:22", "url": "https://files.pythonhosted.org/packages/62/91/2657e042ced9160f19a50c8516648fd5ba9f2bfef5525908dd37b7478d9c/PyMySQLProxyCursor-0.2.3.tar.gz" } ], "0.2.4": [ { "comment_text": "", "digests": { "md5": "0a35bd0c5d84e44f0e7990ef67bfc40e", "sha256": "5b8999dc0a8f3ea2d695be308842781029c4280834d4a4d461c8b55f8dbf77ca" }, "downloads": -1, "filename": "PyMySQLProxyCursor-0.2.4.tar.gz", "has_sig": true, "md5_digest": "0a35bd0c5d84e44f0e7990ef67bfc40e", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 6487, "upload_time": "2017-07-05T13:56:17", "url": "https://files.pythonhosted.org/packages/c8/ee/4858c82614aecf354b99688c6161195df3fddb927ea19f28621ba1ef9304/PyMySQLProxyCursor-0.2.4.tar.gz" } ], "0.2.5": [ { "comment_text": "", "digests": { "md5": "fe4497fe21d567a1aeb641cedf6edd1a", "sha256": "bbf4e18a3c070e3fcbdfbffcc43b65dbe484c9da26a94ec34e5ca820af30fafa" }, "downloads": -1, "filename": "PyMySQLProxyCursor-0.2.5.tar.gz", "has_sig": false, "md5_digest": "fe4497fe21d567a1aeb641cedf6edd1a", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 6520, "upload_time": "2017-07-31T05:43:41", "url": "https://files.pythonhosted.org/packages/4f/37/9d6c0146b209b207affd3245c5d32f6af1c2e0ef515a8c57841b6e730baf/PyMySQLProxyCursor-0.2.5.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "fe4497fe21d567a1aeb641cedf6edd1a", "sha256": "bbf4e18a3c070e3fcbdfbffcc43b65dbe484c9da26a94ec34e5ca820af30fafa" }, "downloads": -1, "filename": "PyMySQLProxyCursor-0.2.5.tar.gz", "has_sig": false, "md5_digest": "fe4497fe21d567a1aeb641cedf6edd1a", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 6520, "upload_time": "2017-07-31T05:43:41", "url": "https://files.pythonhosted.org/packages/4f/37/9d6c0146b209b207affd3245c5d32f6af1c2e0ef515a8c57841b6e730baf/PyMySQLProxyCursor-0.2.5.tar.gz" } ] }