Skip to main content

SQL statement wrapper class

Project description

This module allows for easy wrapping of SQL tables, simple queries and their results in dictionary-like python datatype objects. Attn: MySQLdb is currently mandatory for this module! Example:

>>> res = myDB.Address.City["Oklahoma%"]
>>> len(res)
2
>>> for r in res:
...   print "%s: %s"%(r.Name, r.Phone)
John Doe: 0405-12345
Joe User: 0405-67890
>>> john = res[0]
>>> john.Phone = '0405-54321'

Supported by

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