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