Skip to main content

A simple wrapper over mysqldb

Project description

For use with the mysqldb module for python

Usage

import mysqldbhelper
db = mysqldbhelper.DatabaseConnection('hostname',
                    user='username',
                    passwd='password',
                    db='databasename')

For single transactions

db.get_one('select book_name from book where isbn = %s', ('SOMEISBN',))

‘limit 1’ is automatically added

db.get_all('select book_name from book where author = %s', ('Richard Dawkins',))
db.put('''
insert into book
(book_name, book_author)
values
(%s, %s)''', ('Phantoms in the brain', 'V.S. Ramachandran')

put can be used for insert, update and delete queries

db.put('''delete from book
where
book_author = %s''' ('Deepak Chopra',))

For multiple transcations that need to be run atomically

try:
    db.start()
    db.get(...)
    db.put(...)
    ...
    db.save()
except Exception, e:
    db.rollback()
    raise

Used at Comparnion.com

Project details


Release history Release notifications

This version
History Node

1.0.2

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
mysqldbhelper-1.0.2.tar.gz (2.2 kB) Copy SHA256 hash SHA256 Source None Feb 6, 2016

Supported by

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