Skip to main content

Simple PyMySQL ProxyCursor

Project description

https://img.shields.io/badge/license-MIT-blue.svg

PyMySQLProxyCursor

A simple cursor wrapper to support before/after processing using PyMySQL.

Installation

The last stable release is available on PyPI and can be installed with pip:

$ pip install PyMySQLProxyCursor

Example

from __future__ import print_function

import pymysql
import proxycursor

class SimpleProxy(object):
    def __init__(self):
        self.tblname = 'user'

    def after_insert(self, **kwargs):
        cur = kwargs['cursor']
        cur.execute('SELECT LAST_INSERT_ID()')

    def after_update(self, **kwargs):
        cur = kwargs['cursor']
        cur.execute('SELECT * FROM user ORDER BY updated_at desc LIMIT 1')


conn = pymysql.connect(host='localhost', port=3306, user='root', passwd='', db='mysql')

cur = conn.cursor()
cur = proxycursor.wrap(cur, handlers=[SimpleProxy()])
cur.execute("SELECT Host,User FROM user")

print(cur.description)

print()

for row in cur:
    print(row)

cur.close()
conn.close()

License

PyMySQLProxyCursor is released under the MIT License. See LICENSE for more information.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Filename, size & hash SHA256 hash help File type Python version Upload date
PyMySQLProxyCursor-0.2.5.tar.gz (6.5 kB) Copy SHA256 hash SHA256 Source None

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN SignalFx SignalFx Supporter DigiCert DigiCert EV certificate StatusPage StatusPage Status page