MySQL for Gevent kept Simple.
Project description
Usage:
# pip install my4geks import gevent.monkey ; gevent.monkey.patch_all() from my4geks import db, db_config, db_transaction db_config.update(user='user', password='password', database='test') # Defaults: host='127.0.0.1', port=3306, pool_size=10, query_timeout=55, charset='utf8', cursor_class=AdictCursor. def on_request(): # Inside a greenlet: item = db('SELECT * FROM `items` WHERE `id` = %s', item_id, charset='utf8mb4').row for item in db('SELECT `id`, `name` FROM `items` WHERE `name` IN %s, [value1, value2]).rows: print('{} {}'.format(item.id, item.name)) assert db('UPDATE `items` SET `name` = %s WHERE `name` = %s', new_value, old_value).affected # rowcount def code(): db('INSERT INTO `table1` (`quantity`) VALUES (%s)', -100) db('INSERT INTO `table2` (`quantity`) VALUES (%s)', +1/0) db_transaction(code)
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
my4geks-0.1.4.tar.gz
(3.4 kB
view hashes)