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.
      • pydo.operators.DyadicOperator
        • pydo.operators.EQ
        • pydo.operators.EXP
        • pydo.operators.GT
        • pydo.operators.GT_EQ
        • pydo.operators.ILIKE
        • pydo.operators.IN
        • pydo.operators.IREGEX
        • pydo.operators.IS
        • pydo.operators.LIKE
        • pydo.operators.LT
        • pydo.operators.LT_EQ
        • pydo.operators.MOD
        • pydo.operators.NE
        • pydo.operators.OVERLAPS
        • pydo.operators.REGEX
        • pydo.operators.SIMILAR
      • pydo.operators.MonadicOperator
        • pydo.operators.ISNULL
        • pydo.operators.NOT
        • pydo.operators.NOTNULL
      • pydo.operators.PolyadicOperator
        • pydo.operators.AND
        • pydo.operators.BETWEEN
        • pydo.operators.DIV
        • pydo.operators.MINUS
        • pydo.operators.MULT
        • pydo.operators.OR
        • pydo.operators.PLUS
  • __builtin__.type: type(object) -> the object's type type(name, bases, dict) -> a new type
    • pydo.base._metapydo: metaclass for _pydobase.
  • pydo.dbi.ConnectionWrapper: a connection object returned from a connection pool which wraps a real db connection.
  • pydo.dbi.DBIBase: base class for db connection wrappers.
    • pydo.drivers.mssqlconn.MssqlDBI
    • pydo.drivers.mysqlconn.MysqlDBI
    • pydo.drivers.oracleconn.OracleDBI
    • pydo.drivers.psycopgconn.PsycopgDBI
    • pydo.drivers.sqliteconn.SqliteDBI
  • pydo.multifetch.TableAlias
  • pydo.dbtypes.typewrapper
    • pydo.dbtypes.BINARY
    • pydo.dbtypes.DATE
    • pydo.dbtypes.INTERVAL
    • pydo.dbtypes.TIMESTAMP
• exceptions.Exception: Common base class for all exceptions.
  • pydo.exceptions.PyDOError