DB_DataObject
Prev
Next
DB_DataObject
Package zur automatischen Erzeugung von SQL und Daten-Modellierung-Schicht.
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()