- 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