DB_DataObject

Table of Contents
Introduction --  What DB_DataObject can do
Configuration Options --  Setting the defaults for database access
Auto Building and Database Schema --  creating the base Classes and Database schema
DB_DataObject::factory() -- Autoload and instantate class based on table name.
->get() --  Simple Get (Select) request
DB_DataObject::staticGet() -- Simple Get (Select) request, abbreviated and Autoload.
{Child Class}::staticGet() -- Simple Get (Select) request, abbreviated (autogenerated)
->find() -- find results
->fetch() -- fetch next row
->count() -- Perform a select count() request
->insert() -- Insert current objects variables into database
->update() -- Update objects variables into database
->delete() -- Delete items from table
Selecting Specific data (SELECT) --  Advanced Filters - ::query(), ::SelectAdd(), ::whereAdd(), ::Limit(), ::OrderBy(), ::GroupBy(),
->query() -- send a raw query
->free() -- Free resources
->selectAdd() -- Add selected columns
->whereAdd() -- Add WHERE statement
->escape() -- Escape a string for use with Like queries
->limit() -- Set limit
->orderBy() -- Add an order by condition
->groupBy() -- Add group by condition
Automatic Table Linking and Joins --  Automatic Table Linking - ::getLink(), ::getLinks(), ::joinAdd(), ::selectAs()
->getLink() -- fetch and return a related object
->getLinks() -- load related objects
->selectAs() -- Build the select component of a query (usually for joins)
->joinAdd() -- add another dataobject to build a create join query
->set*() and ->get*() -- Automatic Setters and Getters using overload
->setFrom() -- Copy items from Array or Object (for form posting)
->toArray() -- Get an array of the current result
->validate() -- check object data, and call objects validation methods.
->tableName() -- Get or set the table name of an object
->database() -- Get or set the database the object uses
->table() -- Get or set the table schema
->keys() -- Get or set the table keys
->getDatabaseConnection() -- Get the PEAR Database Object
->getDatabaseResult() -- Get the PEAR Database Result Object
DB_DataObject::debugLevel -- set the amount of debugging output
->debug() -- output debug information.
DB_DataObject::raiseError -- throw an error
Casting - Dates, Blobs and Null --  DB_DataObject_Cast ::date(), ::blob(), ::sql()

SQL Builder and Data Modeling Layer

This chapter describes how to use the DB_DataObject SQL Builder and Data Modeling layer