DB_DataObject
Prev		Next

DB_DataObject

SQL Builder and Data Modeling Layer

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

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()

Prev	Database	Next
DB_Error	PEAR Manual	Introduction