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 | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
mysqldbhelper-1.0.2.tar.gz
(2.2 kB
view hashes)