Skip to main content

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.6.tar.gz (3.5 kB view details)

Uploaded Source

File details

Details for the file my4geks-0.1.6.tar.gz.

File metadata

  • Download URL: my4geks-0.1.6.tar.gz
  • Upload date:
  • Size: 3.5 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No

File hashes

Hashes for my4geks-0.1.6.tar.gz
Algorithm Hash digest
SHA256 a05b48e82d9c90184c3698e5cd342bb0aabddf05d39655bddabae4167b40f074
MD5 b9ceab21b6b527fb7b802cc37c947fea
BLAKE2b-256 bdb2e74abad9d0fc781c412eb7a3bccc5d11ff1b607457bbe82b77cf304681a0

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page