Module Hierarchy

• pydo: PyDO (Python Data Objects) is an object-relational wrapper for relational databases.
  • base
  • dbi
  • dbtypes: The dbtypes module contains generic type wrapper classes for values passed into PyDO, to provide type information useful into marshalling the data into SQL according to the intended datatype.
  • drivers
    • mssqlconn: PyDO driver for mssql, using the ADO adapter.
    • mysqlconn: PyDO driver for MySQL, using the MySQLdb driver.
    • oracleconn
    • psycopgconn: PyDO driver for PostgreSQL, using the psycopg driver.
    • sqliteconn: PyDO driver for sqlite, using the pysqlite adapter.
  • exceptions
  • field
  • guesscache
  • log
  • multifetch
  • operators: This module permits a useful subset of SQL where clauses to be defined with a Lispo-Pythonic syntax:
  • utils: utility functions imported by other PyDO modules.

Class Hierarchy

• __builtin__.object: The most base type
  • pydo.operators.BindingConverter: A value converter that uses bind variables.
    • pydo.drivers.mssqlconn.MssqlConverter
    • pydo.drivers.mysqlconn.MysqlConverter
    • pydo.drivers.psycopgconn.PsycopgConverter
    • pydo.drivers.sqliteconn.SqliteConverter
  • pydo.dbi.ConnectionPool: a connection pool for a single connection alias.
  • pydo.operators.CONSTANT: a way to represent a constant or field name in a sql expression
  • __builtin__.dict: dict() -> new empty dictionary.
    • pydo.base.PyDO: Base class for PyDO data classes.
  • pydo.field.Field: represents a column in a database table.
    • pydo.field.Sequence: like a Field, except that sequence defaults to True, and the field must be unique.
    • pydo.field.Unique: like a Field, except that it must be unique and isn't a sequence (use Sequence for that)
  • pydo.base.ForeignKey: descriptor that enables succinct creation of foreign key attributes.
  • pydo.guesscache.GuessCache: a cache that stores pickles of data associated with a Python class.
  • pydo.operators.SET: a way of passing a set into PyDO where clauses (for IN), e.g.:
  • __builtin__.tuple: tuple() -> an empty tuple tuple(sequence) -> tuple initialized from sequence's items
    • pydo.operators.SQLOperator: A special kind of tuple that knows how to represent itself as a SQL string.
  • __builtin__.type: type(object) -> the object's type type(name, bases, dict) -> a new type
• exceptions.Exception: Common base class for all exceptions.
  • pydo.exceptions.PyDOError