DB_Table
[ class tree: DB_Table ] [ index: DB_Table ] [ all elements ]

Element index for package DB_Table

[ a ] [ b ] [ c ] [ d ] [ e ] [ f ] [ g ] [ h ] [ i ] [ l ] [ m ] [ n ] [ o ] [ p ] [ q ] [ r ] [ s ] [ t ] [ u ] [ v ] [ x ] [ y ] [ _ ]

_

_getFormColDefs
in file Table.php, method DB_Table::_getFormColDefs()
    Creates a column definition array suitable for DB_Table_QuickForm.
__sleep
in file Database.php, method DB_Table_Database::__sleep()
    Serializes all table references and sets $db = null, $backend = null
__wakeup
in file Database.php, method DB_Table_Database::__wakeup()
    Unserializes DB_Table_Database object and all child DB_Table objects
top

a

$auto_inc_col
in file Generator.php, variable DB_Table_Generator::$auto_inc_col
    Array of auto_increment column names
$auto_inc_col
in file Table.php, variable DB_Table::$auto_inc_col
    Name of an auto-increment column, if any. Null otherwise.
addAllLinks
in file Database.php, method DB_Table_Database::addAllLinks()
    Adds all possible linking tables to the $_link property array
addElements
in file QuickForm.php, method DB_Table_QuickForm::addElements()
    Adds DB_Table columns to a pre-existing HTML_QuickForm object.
addFilters
in file QuickForm.php, method DB_Table_QuickForm::addFilters()
    Adds DB_Table filters to a pre-existing HTML_QuickForm object.
addFormElements
in file Table.php, method DB_Table::addFormElements()
    Adds elements and rules to a pre-existing HTML_QuickForm object.
addLink
in file Database.php, method DB_Table_Database::addLink()
    Identifies a linking/association table that links two others
addRef
in file Database.php, method DB_Table_Database::addRef()
    Adds a foreign key reference to the database.
addRules
in file QuickForm.php, method DB_Table_QuickForm::addRules()
    Adds element rules to a pre-existing HTML_QuickForm object.
addStaticElements
in file QuickForm.php, method DB_Table_QuickForm::addStaticElements()
    Adds static form elements like 'header', 'static', 'submit' or 'reset' to a pre-existing HTML_QuickForm object.
addStaticFormElements
in file Table.php, method DB_Table::addStaticFormElements()
    Adds static form elements like 'header', 'static', 'submit' or 'reset' to a pre-existing HTML_QuickForm object. The form elements needs to be defined in a property called $frm.
addTable
in file Database.php, method DB_Table_Database::addTable()
    Adds a table to the database.
alter
in file Manager.php, method DB_Table_Manager::alter()
    Alter columns and indexes of a table based on DB_Table column and index arrays.
alter
in file Table.php, method DB_Table::alter()
    Alters the table to match schema declared in $this->col and $this->idx.
alterTable
in file sqlite.php, method DB_Table_Manager_sqlite::alterTable()
    alter an existing table
alterTable
in file mysqli.php, method DB_Table_Manager_mysqli::alterTable()
    alter an existing table
alterTable
in file pgsql.php, method DB_Table_Manager_pgsql::alterTable()
    alter an existing table
alterTable
in file mysql.php, method DB_Table_Manager_mysql::alterTable()
    alter an existing table
alterTable
in file ibase.php, method DB_Table_Manager_ibase::alterTable()
    alter an existing table
alterTable
in file oci8.php, method DB_Table_Manager_oci8::alterTable()
    alter an existing table
autoInc
in file Database.php, method DB_Table_Database::autoInc()
    Turns on (or off) php implementation of auto-incrementing on insertion for all tables
autoJoin
in file Database.php, method DB_Table_Database::autoJoin()
    Builds a select command involving joined tables from a list of column names and/or a list of table names.
autoRecast
in file Database.php, method DB_Table_Database::autoRecast()
    Turns on (or off) automatic recasting of insert and update data for all tables
autoRecast
in file Table.php, method DB_Table::autoRecast()
    Turns on (or off) automatic recasting of insert and update data.
autoValidInsert
in file Table.php, method DB_Table::autoValidInsert()
    Turns on (or off) automatic validation of inserted data.
autoValidInsert
in file Database.php, method DB_Table_Database::autoValidInsert()
    Turns on or off automatic validation of inserted data for all tables
autoValidUpdate
in file Table.php, method DB_Table::autoValidUpdate()
    Turns on (or off) automatic validation of updated data.
autoValidUpdate
in file Database.php, method DB_Table_Database::autoValidUpdate()
    Turns on (or off) automatic validation of updated data for all tables.
top

b

$backend
in file Base.php, variable DB_Table_Base::$backend
    The backend type, which must be 'db' or 'mdb2'
buildFilter
in file Base.php, method DB_Table_Base::buildFilter()
    Returns SQL condition equating columns to literal values.
buildSQL
in file Base.php, method DB_Table_Base::buildSQL()
    Returns SQL SELECT string constructed from sql query array
buildTableClass
in file Generator.php, method DB_Table_Generator::buildTableClass()
    Returns one skeleton DB_Table subclass definition, as php code
buildTableClasses
in file Generator.php, method DB_Table_Generator::buildTableClasses()
    Returns a string containing all table class definitions in one file
Base.php
procedural page Base.php
top

c

$class_include_path
in file Generator.php, variable DB_Table_Generator::$class_include_path
    Include path to subclass definition files from database file
$class_suffix
in file Generator.php, variable DB_Table_Generator::$class_suffix
    Suffix to add to table names to obtain corresponding class names
$class_write_path
in file Generator.php, variable DB_Table_Generator::$class_write_path
    Path to directory in which subclass definitions should be written
$col
in file Generator.php, variable DB_Table_Generator::$col
    Array of column definitions
$col
in file Table.php, variable DB_Table::$col
    Associative array of column definitions.
classFileName
in file Generator.php, method DB_Table_Generator::classFileName()
    Returns the path to a file containing a class definition
className
in file Generator.php, method DB_Table_Generator::className()
    Convert a table name into a class name
closeTag
in file XML.php, method DB_Table_XML::closeTag()
    Returns XML closing tag </tag>, decreases $indent by 3 spaces
create
in file Manager.php, method DB_Table_Manager::create()
    Create the table based on DB_Table column and index arrays.
create
in file Table.php, method DB_Table::create()
    Creates the table based on $this->col and $this->idx.
createForm
in file QuickForm.php, method DB_Table_QuickForm::createForm()
    Creates an empty form object.
createTables
in file Database.php, method DB_Table_Database::createTables()
    Creates all the tables in a database in a RDBMS
top

d

$day
in file Date.php, variable DB_Table_Date::$day
    the day
$db
in file Base.php, variable DB_Table_Base::$db
    The PEAR DB/MDB2 object that connects to the database.
DB_Table
in file Table.php, method DB_Table::DB_Table()
    Constructor.
DB_Table
in file Table.php, class DB_Table
    DB_Table is a database API and data type SQL abstraction class.
Database.php
procedural page Database.php
Date.php
procedural page Date.php
DB_Table_Base
in file Base.php, class DB_Table_Base
    Base class for DB_Table and DB_Table_Database
DB_Table_Database
in file Database.php, class DB_Table_Database
    Relational database abstraction class
DB_Table_Database
in file Database.php, method DB_Table_Database::DB_Table_Database()
    Constructor
DB_TABLE_DATABASE_ERR_AMBIG_JOIN
in file Database.php, constant DB_TABLE_DATABASE_ERR_AMBIG_JOIN
    Error in autoJoin for non-unique set of join conditions
DB_TABLE_DATABASE_ERR_COL_NOT_STRING
in file Database.php, constant DB_TABLE_DATABASE_ERR_COL_NOT_STRING
    Error for column name that is not a string
DB_TABLE_DATABASE_ERR_COL_NOT_UNIQUE
in file Database.php, constant DB_TABLE_DATABASE_ERR_COL_NOT_UNIQUE
    Error in autoJoin for ambiguous column name
DB_TABLE_DATABASE_ERR_DATA_KEY
in file Database.php, constant DB_TABLE_DATABASE_ERR_DATA_KEY
    Error in buildFilter due to invalid key for full match
DB_TABLE_DATABASE_ERR_DBTABLE_OBJECT
in file Database.php, constant DB_TABLE_DATABASE_ERR_DBTABLE_OBJECT
    Error in addTable, parameter $table_obj is not a DB_Table object
DB_TABLE_DATABASE_ERR_DB_OBJECT
in file Database.php, constant DB_TABLE_DATABASE_ERR_DB_OBJECT
    Parameter is not a DB/MDB2 object
DB_TABLE_DATABASE_ERR_FAIL_JOIN
in file Database.php, constant DB_TABLE_DATABASE_ERR_FAIL_JOIN
    Error in autoJoin for failed construction of join
DB_TABLE_DATABASE_ERR_FILT_KEY
in file Database.php, constant DB_TABLE_DATABASE_ERR_FILT_KEY
    Error in buildFilter due to invalid key for full match
DB_TABLE_DATABASE_ERR_FKEY
in file Database.php, constant DB_TABLE_DATABASE_ERR_FKEY
    Error in addRef for an invalid foreign key, neither string nor array
DB_TABLE_DATABASE_ERR_FKEY_CONSTRAINT
in file Database.php, constant DB_TABLE_DATABASE_ERR_FKEY_CONSTRAINT
    Error in insert for a failed foreign key constraint
DB_TABLE_DATABASE_ERR_FULL_KEY
in file Database.php, constant DB_TABLE_DATABASE_ERR_FULL_KEY
    Error in buildFilter due to invalid key for full match
DB_TABLE_DATABASE_ERR_MATCH_TYPE
in file Database.php, constant DB_TABLE_DATABASE_ERR_MATCH_TYPE
    Error in buildFilter due to invalid match type
DB_TABLE_DATABASE_ERR_MULT_PKEY
in file Database.php, constant DB_TABLE_DATABASE_ERR_MULT_PKEY
    Error in addTable for multiple primary keys
DB_TABLE_DATABASE_ERR_MULT_REF
in file Database.php, constant DB_TABLE_DATABASE_ERR_MULT_REF
    Error in addRef for multiple references from one table to another
DB_TABLE_DATABASE_ERR_NO_COL
in file Database.php, constant DB_TABLE_DATABASE_ERR_NO_COL
    Error in getCol for a non-existent column name
DB_TABLE_DATABASE_ERR_NO_COL_DB
in file Database.php, constant DB_TABLE_DATABASE_ERR_NO_COL_DB
    Error in validCol for a column name that does not exist in the datase
DB_TABLE_DATABASE_ERR_NO_COL_NO_TBL
in file Database.php, constant DB_TABLE_DATABASE_ERR_NO_COL_NO_TBL
    Error in autoJoin, column and tables parameter both null
DB_TABLE_DATABASE_ERR_NO_COL_TBL
in file Database.php, constant DB_TABLE_DATABASE_ERR_NO_COL_TBL
    Error in validCol for column name that does not exist in the specified table
DB_TABLE_DATABASE_ERR_NO_FCOL
in file Database.php, constant DB_TABLE_DATABASE_ERR_NO_FCOL
    Error in addRef for non-existence foreign key (referencing) column
DB_TABLE_DATABASE_ERR_NO_FOREIGN_COL
in file Database.php, constant DB_TABLE_DATABASE_ERR_NO_FOREIGN_COL
    Error in getForeignCol for a non-existent foreign key column
DB_TABLE_DATABASE_ERR_NO_FTABLE
in file Database.php, constant DB_TABLE_DATABASE_ERR_NO_FTABLE
    Error in addRef for a non-existent foreign key table
DB_TABLE_DATABASE_ERR_NO_PKEY
in file Database.php, constant DB_TABLE_DATABASE_ERR_NO_PKEY
    Error in addRef for null referenced key in a table with no primary key
DB_TABLE_DATABASE_ERR_NO_RCOL
in file Database.php, constant DB_TABLE_DATABASE_ERR_NO_RCOL
    Error in addRef for non-existence referenced column
DB_TABLE_DATABASE_ERR_NO_REF_LINK
in file Database.php, constant DB_TABLE_DATABASE_ERR_NO_REF_LINK
    Error in addLink due to missing required reference
DB_TABLE_DATABASE_ERR_NO_RTABLE
in file Database.php, constant DB_TABLE_DATABASE_ERR_NO_RTABLE
    Error in addRef for non-existence referenced table
DB_TABLE_DATABASE_ERR_NO_TBL
in file Database.php, constant DB_TABLE_DATABASE_ERR_NO_TBL
    Error for table name that does not exist in the database
DB_TABLE_DATABASE_ERR_ON_DELETE_ACTION
in file Database.php, constant DB_TABLE_DATABASE_ERR_ON_DELETE_ACTION
    Error due to invalid ON DELETE action name
DB_TABLE_DATABASE_ERR_ON_UPDATE_ACTION
in file Database.php, constant DB_TABLE_DATABASE_ERR_ON_UPDATE_ACTION
    Error due to invalid ON UPDATE action name
DB_TABLE_DATABASE_ERR_PHP_VERSION
in file Database.php, constant DB_TABLE_DATABASE_ERR_PHP_VERSION
    Error in fromXML for PHP 4 (this function requires PHP 5)
DB_TABLE_DATABASE_ERR_REF_TYPE
in file Database.php, constant DB_TABLE_DATABASE_ERR_REF_TYPE
    Error in addRef for referencing and referenced columns of different types
DB_TABLE_DATABASE_ERR_RESTRICT_DELETE
in file Database.php, constant DB_TABLE_DATABASE_ERR_RESTRICT_DELETE
    Error in delete due to a referentially triggered 'restrict' action
DB_TABLE_DATABASE_ERR_RESTRICT_UPDATE
in file Database.php, constant DB_TABLE_DATABASE_ERR_RESTRICT_UPDATE
    Error in update due to a referentially triggered 'restrict' action
DB_TABLE_DATABASE_ERR_RKEY_COL_NUMBER
in file Database.php, constant DB_TABLE_DATABASE_ERR_RKEY_COL_NUMBER
    Error in addRef for wrong number of columns in referenced key
DB_TABLE_DATABASE_ERR_RKEY_NOT_ARRAY
in file Database.php, constant DB_TABLE_DATABASE_ERR_RKEY_NOT_ARRAY
    Error in addRef for referenced key that is not an array, array foreign key
DB_TABLE_DATABASE_ERR_RKEY_NOT_STRING
in file Database.php, constant DB_TABLE_DATABASE_ERR_RKEY_NOT_STRING
    Error in addRef for referenced key that is not a string, string foreign key
DB_TABLE_DATABASE_ERR_SQL_NOT_STRING
in file Database.php, constant DB_TABLE_DATABASE_ERR_SQL_NOT_STRING
    Error in a buildSQL or select* method for a key of $this->sql that is
DB_TABLE_DATABASE_ERR_SQL_UNDEF
in file Database.php, constant DB_TABLE_DATABASE_ERR_SQL_UNDEF
    Error in a buildSQL or select* method for an undefined key of $this->sql
DB_TABLE_DATABASE_ERR_TBL_NOT_STRING
in file Database.php, constant DB_TABLE_DATABASE_ERR_TBL_NOT_STRING
    Error for table name parameter that is not a string
DB_TABLE_DATABASE_ERR_XML_MULT_AUTO_INC
in file Database.php, constant DB_TABLE_DATABASE_ERR_XML_MULT_AUTO_INC
    Error in fromXML for table with multiple auto_increment columns
DB_TABLE_DATABASE_ERR_XML_PARSE
in file Database.php, constant DB_TABLE_DATABASE_ERR_XML_PARSE
    Error parsing XML string in fromXML
DB_Table_Date
in file Date.php, method DB_Table_Date::DB_Table_Date()
    Constructor
DB_Table_Date
in file Date.php, class DB_Table_Date
    Generic date handling class for DB_Table.
DB_TABLE_ERR_ALTER_INDEX_IMPOS
in file Table.php, constant DB_TABLE_ERR_ALTER_INDEX_IMPOS
    Error code at alter() time when altering a(n) index/constraint is not possible (e.g. because MDB2 has no support for the change or because the DBMS does not support the change).
DB_TABLE_ERR_ALTER_TABLE_IMPOS
in file Table.php, constant DB_TABLE_ERR_ALTER_TABLE_IMPOS
    Error code at alter() time when altering a table field is not possible (e.g. because MDB2 has no support for the change or because the DBMS does not support the change).
DB_TABLE_ERR_AUTO_INC_COL
in file Table.php, constant DB_TABLE_ERR_AUTO_INC_COL
    Error code at insert() time due to invalid the auto-increment column definition. This column must be an integer type and required.
DB_TABLE_ERR_CREATE_FLAG
in file Table.php, constant DB_TABLE_ERR_CREATE_FLAG
    Error code when you use a create() flag that is not recognized (must be 'safe', 'drop', 'verify' or boolean false.
DB_TABLE_ERR_CREATE_PHPTYPE
in file Table.php, constant DB_TABLE_ERR_CREATE_PHPTYPE
    Error code at instantiation time when a creation mode is not available for a phptype.
DB_TABLE_ERR_DECLARE_COLNAME
in file Table.php, constant DB_TABLE_ERR_DECLARE_COLNAME
    Error code at create() time when you define a column in $this->col with an invalid column name (usually because it's a reserved keyword).
DB_TABLE_ERR_DECLARE_DECIMAL
in file Table.php, constant DB_TABLE_ERR_DECLARE_DECIMAL
    Error code at create() time when you have an error in a 'decimal' definition (usually becuase the 'size' or 'scope' are wrong).
DB_TABLE_ERR_DECLARE_IDXNAME
in file Table.php, constant DB_TABLE_ERR_DECLARE_IDXNAME
    Error code at create() time when you define an index in $this->idx with an invalid index name (usually because it's a reserved keyword).
DB_TABLE_ERR_DECLARE_PRIMARY
in file Table.php, constant DB_TABLE_ERR_DECLARE_PRIMARY
    Error code at create() time when you define more than one primary key in $this->idx.
DB_TABLE_ERR_DECLARE_PRIM_SQLITE
in file Table.php, constant DB_TABLE_ERR_DECLARE_PRIM_SQLITE
    Error code at create() time when a primary key is defined in $this->idx and SQLite is used (SQLite does not support primary keys).
DB_TABLE_ERR_DECLARE_STRING
in file Table.php, constant DB_TABLE_ERR_DECLARE_STRING
    Error code at create() time when you have an error in a 'char' or 'varchar' definition in $this->col (usually because 'size' is wrong).
DB_TABLE_ERR_DECLARE_STRLEN
in file Table.php, constant DB_TABLE_ERR_DECLARE_STRLEN
    Error code at create() time when you define a column name that is more than 30 chars long (an Oracle restriction).
DB_TABLE_ERR_DECLARE_TYPE
in file Table.php, constant DB_TABLE_ERR_DECLARE_TYPE
    Error code at create() time when you define a column in $this->col with an unrecognized 'type'.
DB_TABLE_ERR_IDX_COL_CLOB
in file Table.php, constant DB_TABLE_ERR_IDX_COL_CLOB
    Error code at create() time when you define an index in $this->idx that refers to a CLOB column.
DB_TABLE_ERR_IDX_COL_UNDEF
in file Table.php, constant DB_TABLE_ERR_IDX_COL_UNDEF
    Error code at create() time when you define an index in $this->idx that refers to a column that does not exist in the $this->col array.
DB_TABLE_ERR_IDX_NO_COLS
in file Table.php, constant DB_TABLE_ERR_IDX_NO_COLS
    Error code at create() time when you define an index in $this->idx that has no columns.
DB_TABLE_ERR_IDX_STRLEN
in file Table.php, constant DB_TABLE_ERR_IDX_STRLEN
    Error code at create() time when the index name ends up being more than 30 chars long (an Oracle restriction).
DB_TABLE_ERR_IDX_TYPE
in file Table.php, constant DB_TABLE_ERR_IDX_TYPE
    Error code at create() time when you define a $this->idx index type that is not recognized (must be 'normal' or 'unique').
DB_TABLE_ERR_INS_COL_NOMAP
in file Table.php, constant DB_TABLE_ERR_INS_COL_NOMAP
    Error code when you try to insert data to a column that is not in the $this->col array.
DB_TABLE_ERR_INS_COL_REQUIRED
in file Table.php, constant DB_TABLE_ERR_INS_COL_REQUIRED
    Error code when you try to insert data, and that data does not have a column marked as 'require' in the $this->col array.
DB_TABLE_ERR_INS_DATA_INVALID
in file Table.php, constant DB_TABLE_ERR_INS_DATA_INVALID
    Error code when auto-validation fails on data to be inserted.
DB_TABLE_ERR_NOT_DB_OBJECT
in file Table.php, constant DB_TABLE_ERR_NOT_DB_OBJECT
    Error code at instantiation time when the first parameter to the constructor is not a PEAR DB object.
DB_TABLE_ERR_NO_COLS
in file Table.php, constant DB_TABLE_ERR_NO_COLS
    Error code at instantiation time when the column definition array does not contain at least one column.
DB_TABLE_ERR_PHPTYPE
in file Table.php, constant DB_TABLE_ERR_PHPTYPE
    Error code at instantiation time when the PEAR DB/MDB2 $phptype is not supported by DB_Table.
DB_TABLE_ERR_SEQ_STRLEN
in file Table.php, constant DB_TABLE_ERR_SEQ_STRLEN
    Error code at nextID() time when the sequence name is more than 30 chars long (an Oracle restriction).
DB_TABLE_ERR_SQL_NOT_STRING
in file Table.php, constant DB_TABLE_ERR_SQL_NOT_STRING
    Error code when you call select*() or buildSQL() and the first
DB_TABLE_ERR_SQL_UNDEF
in file Table.php, constant DB_TABLE_ERR_SQL_UNDEF
    Error code when you call select() or selectResult() and the first parameter is a string that does not match any of the $this->sql keys.
DB_TABLE_ERR_TABLE_NAME_MISSING
in file Table.php, constant DB_TABLE_ERR_TABLE_NAME_MISSING
    Error code at instantiation time when both the $table parameter and the $table class property are missing.
DB_TABLE_ERR_TABLE_STRLEN
in file Table.php, constant DB_TABLE_ERR_TABLE_STRLEN
    Error code at create() time when the table name is more than 30 chars long (an Oracle restriction).
DB_TABLE_ERR_UPD_COL_NOMAP
in file Table.php, constant DB_TABLE_ERR_UPD_COL_NOMAP
    Error code when you try to update data to a column that is not in the $this->col array.
DB_TABLE_ERR_UPD_COL_REQUIRED
in file Table.php, constant DB_TABLE_ERR_UPD_COL_REQUIRED
    Error code when you try to update data, and that data does not have a column marked as 'require' in the $this->col array.
DB_TABLE_ERR_UPD_DATA_INVALID
in file Table.php, constant DB_TABLE_ERR_UPD_DATA_INVALID
    Error code when auto-validation fails on update data.
DB_TABLE_ERR_VALIDATE_TYPE
in file Table.php, constant DB_TABLE_ERR_VALIDATE_TYPE
    Error code at validation time when a column in $this->col has an unrecognized 'type'.
DB_TABLE_ERR_VER_COLUMN_MISSING
in file Table.php, constant DB_TABLE_ERR_VER_COLUMN_MISSING
    Error code at verify() time when the column does not exist in the database table.
DB_TABLE_ERR_VER_COLUMN_TYPE
in file Table.php, constant DB_TABLE_ERR_VER_COLUMN_TYPE
    Error code at verify() time when the column type does not match the type specified in the column declaration.
DB_TABLE_ERR_VER_IDX_COL_MISSING
in file Table.php, constant DB_TABLE_ERR_VER_IDX_COL_MISSING
    Error code at verify() time when an index does not contain all columns that it should contain.
DB_TABLE_ERR_VER_IDX_MISSING
in file Table.php, constant DB_TABLE_ERR_VER_IDX_MISSING
    Error code at verify() time when an index cannot be found in the database table.
DB_TABLE_ERR_VER_TABLE_MISSING
in file Table.php, constant DB_TABLE_ERR_VER_TABLE_MISSING
    Error code at verify() time when the table does not exist in the database.
DB_Table_Generator
in file Generator.php, method DB_Table_Generator::DB_Table_Generator()
    Constructor
DB_Table_Generator
in file Generator.php, class DB_Table_Generator
    class DB_Table_Generator - Generates DB_Table subclass skeleton code
DB_TABLE_GENERATOR_ERR_DB_OBJECT
in file Generator.php, constant DB_TABLE_GENERATOR_ERR_DB_OBJECT
    Parameter is not a DB/MDB2 object
DB_TABLE_GENERATOR_ERR_FILE
in file Generator.php, constant DB_TABLE_GENERATOR_ERR_FILE
    Error while creating file/directory
DB_TABLE_GENERATOR_ERR_INDEX_COL
in file Generator.php, constant DB_TABLE_GENERATOR_ERR_INDEX_COL
    Parameter is not a DB/MDB2 object
DB_Table_Manager
in file Manager.php, class DB_Table_Manager
    Creates, checks or alters tables from DB_Table definitions.
DB_Table_Manager_ibase
in file ibase.php, class DB_Table_Manager_ibase
    Index, constraint and alter methods for DB_Table usage with PEAR::DB as backend.
DB_Table_Manager_mysql
in file mysql.php, class DB_Table_Manager_mysql
    Index, constraint and alter methods for DB_Table usage with PEAR::DB as backend.
DB_Table_Manager_mysqli
in file mysqli.php, class DB_Table_Manager_mysqli
    Index, constraint and alter methods for DB_Table usage with PEAR::DB as backend.
DB_Table_Manager_oci8
in file oci8.php, class DB_Table_Manager_oci8
    Index, constraint and alter methods for DB_Table usage with PEAR::DB as backend.
DB_Table_Manager_pgsql
in file pgsql.php, class DB_Table_Manager_pgsql
    Index, constraint and alter methods for DB_Table usage with PEAR::DB as backend.
DB_Table_Manager_sqlite
in file sqlite.php, class DB_Table_Manager_sqlite
    Index, constraint and alter methods for DB_Table usage with PEAR::DB as backend.
DB_Table_QuickForm
in file QuickForm.php, class DB_Table_QuickForm
    DB_Table_QuickForm creates HTML_QuickForm objects from DB_Table properties.
DB_Table_Valid
in file Valid.php, class DB_Table_Valid
    DB_Table_Valid validates values against DB_Table column types.
DB_Table_XML
in file XML.php, class DB_Table_XML
    Class DB_Table_XML contains a few simple static methods for writing XML
delete
in file Table.php, method DB_Table::delete()
    Deletes table rows matching a custom WHERE clause.
delete
in file Database.php, method DB_Table_Database::delete()
    Deletes all row(s) of table that match a custom where clause.
deleteLink
in file Database.php, method DB_Table_Database::deleteLink()
    Removes a link between two tables from the $_link property
deleteRef
in file Database.php, method DB_Table_Database::deleteRef()
    Deletes one reference from database model
deleteTable
in file Database.php, method DB_Table_Database::deleteTable()
    Deletes a table from $this database object.
dropConstraint
in file mysql.php, method DB_Table_Manager_mysql::dropConstraint()
    drop existing constraint
dropConstraint
in file pgsql.php, method DB_Table_Manager_pgsql::dropConstraint()
    drop existing constraint
dropConstraint
in file oci8.php, method DB_Table_Manager_oci8::dropConstraint()
    drop existing constraint
dropConstraint
in file mysqli.php, method DB_Table_Manager_mysqli::dropConstraint()
    drop existing constraint
dropConstraint
in file sqlite.php, method DB_Table_Manager_sqlite::dropConstraint()
    drop existing constraint
dropConstraint
in file ibase.php, method DB_Table_Manager_ibase::dropConstraint()
    drop existing constraint
dropIndex
in file ibase.php, method DB_Table_Manager_ibase::dropIndex()
    drop existing index
dropIndex
in file mysql.php, method DB_Table_Manager_mysql::dropIndex()
    drop existing index
dropIndex
in file mysqli.php, method DB_Table_Manager_mysqli::dropIndex()
    drop existing index
dropIndex
in file oci8.php, method DB_Table_Manager_oci8::dropIndex()
    drop existing index
dropIndex
in file pgsql.php, method DB_Table_Manager_pgsql::dropIndex()
    drop existing index
dropIndex
in file sqlite.php, method DB_Table_Manager_sqlite::dropIndex()
    drop existing index
top

e

$error
in file Base.php, variable DB_Table_Base::$error
    If there is an error on instantiation, this captures that error.
$error
in file Generator.php, variable DB_Table_Generator::$error
    If there is an error on instantiation, this captures that error.
$extends
in file Generator.php, variable DB_Table_Generator::$extends
    Class being extended (DB_Table or generic subclass)
$extends_file
in file Generator.php, variable DB_Table_Generator::$extends_file
    Path to definition of the class $this->extends
top

f

$fetchmode
in file Base.php, variable DB_Table_Base::$fetchmode
    Format of rows in sets returned by the select() method
$fetchmode_object_class
in file Base.php, variable DB_Table_Base::$fetchmode_object_class
    Class of objects to use for rows returned as objects by select()
fixColDef
in file QuickForm.php, method DB_Table_QuickForm::fixColDef()
    "Fixes" a DB_Table column definition for QuickForm.
format
in file Date.php, method DB_Table_Date::format()
    Date pretty printing, similar to strftime()
fromXML
in file Database.php, method DB_Table_Database::fromXML()
    Returns a DB_Table_Database object constructed from an XML string
top

g

Generator.php
procedural page Generator.php
generateDatabaseFile
in file Generator.php, method DB_Table_Generator::generateDatabaseFile()
    Writes a file to instantiate Table and Database objects
generateTableClassFiles
in file Generator.php, method DB_Table_Generator::generateTableClassFiles()
    Writes all table class definitions to separate files
getBlankRow
in file Table.php, method DB_Table::getBlankRow()
    Returns a blank row array based on the column map.
getCol
in file Database.php, method DB_Table_Database::getCol()
    Returns all or part of the $_col property array
getColumns
in file Table.php, method DB_Table::getColumns()
    Returns all or part of the $this->col property array.
getDBInstance
in file Database.php, method DB_Table_Database::getDBInstance()
    Return reference to $this->db DB/MDB2 object wrapped by $this
getDeclare
in file Manager.php, method DB_Table_Manager::getDeclare()
    Get the column declaration string for a DB_Table column.
getDeclareForIndex
in file Manager.php, method DB_Table_Manager::getDeclareForIndex()
    Get the index declaration string for a DB_Table index.
getDeclareMDB2
in file Manager.php, method DB_Table_Manager::getDeclareMDB2()
    Get the column declaration string for a DB_Table column.
getElement
in file QuickForm.php, method DB_Table_QuickForm::getElement()
    Build a single QuickForm element based on a DB_Table column.
getElements
in file QuickForm.php, method DB_Table_QuickForm::getElements()
    Gets controls for a list of columns
getForeignCol
in file Database.php, method DB_Table_Database::getForeignCol()
    Returns all or part of the $_foreign_col property array
getForm
in file QuickForm.php, method DB_Table_QuickForm::getForm()
    Build a form based on DB_Table column definitions.
getForm
in file Table.php, method DB_Table::getForm()
    Creates and returns a QuickForm object based on table columns.
getFormElement
in file Table.php, method DB_Table::getFormElement()
    Creates and returns a single QuickForm element based on a DB_Table column name.
getFormElements
in file Table.php, method DB_Table::getFormElements()
    Creates and returns an array of QuickForm elements based on a DB_Table column name.
getFormGroup
in file Table.php, method DB_Table::getFormGroup()
    Creates and returns an array of QuickForm elements based on an array of DB_Table column names.
getGroup
in file QuickForm.php, method DB_Table_QuickForm::getGroup()
    Build an array of form elements based from DB_Table columns.
getIndexes
in file Table.php, method DB_Table::getIndexes()
    Returns all or part of the $this->idx property array.
getIndexes
in file Manager.php, method DB_Table_Manager::getIndexes()
    Return all indexes for a table.
getLink
in file Database.php, method DB_Table_Database::getLink()
    Returns all or part of the $link two-dimensional property array
getPrimaryKey
in file Database.php, method DB_Table_Database::getPrimaryKey()
    Returns all or part of the $_primary_key property array
getRef
in file Database.php, method DB_Table_Database::getRef()
    Returns all or part of the $_ref two-dimensional property array
getRefTo
in file Database.php, method DB_Table_Database::getRefTo()
    Returns all or part of the $_ref_to property array
getTable
in file Database.php, method DB_Table_Database::getTable()
    Returns all or part of $_table property array
getTableConstraintDefinition
in file sqlite.php, method DB_Table_Manager_sqlite::getTableConstraintDefinition()
    get the structure of a constraint into an array
getTableConstraintDefinition
in file mysql.php, method DB_Table_Manager_mysql::getTableConstraintDefinition()
    get the structure of a constraint into an array
getTableConstraintDefinition
in file ibase.php, method DB_Table_Manager_ibase::getTableConstraintDefinition()
    get the structure of a constraint into an array
getTableConstraintDefinition
in file oci8.php, method DB_Table_Manager_oci8::getTableConstraintDefinition()
    get the structure of a constraint into an array
getTableConstraintDefinition
in file mysqli.php, method DB_Table_Manager_mysqli::getTableConstraintDefinition()
    get the structure of a constraint into an array
getTableConstraintDefinition
in file pgsql.php, method DB_Table_Manager_pgsql::getTableConstraintDefinition()
    get the structure of a constraint into an array
getTableDefinition
in file Generator.php, method DB_Table_Generator::getTableDefinition()
    Gets column and index definitions by querying database
getTableIndexDefinition
in file ibase.php, method DB_Table_Manager_ibase::getTableIndexDefinition()
    get the structure of an index into an array
getTableIndexDefinition
in file oci8.php, method DB_Table_Manager_oci8::getTableIndexDefinition()
    get the structure of an index into an array
getTableIndexDefinition
in file mysql.php, method DB_Table_Manager_mysql::getTableIndexDefinition()
    get the structure of an index into an array
getTableIndexDefinition
in file pgsql.php, method DB_Table_Manager_pgsql::getTableIndexDefinition()
    get the structure of an index into an array
getTableIndexDefinition
in file sqlite.php, method DB_Table_Manager_sqlite::getTableIndexDefinition()
    get the structure of an index into an array
getTableIndexDefinition
in file mysqli.php, method DB_Table_Manager_mysqli::getTableIndexDefinition()
    get the structure of an index into an array
getTableNames
in file Generator.php, method DB_Table_Generator::getTableNames()
    Gets a list of tables from the database
getTableSubclass
in file Database.php, method DB_Table_Database::getTableSubclass()
    Returns all or part of the $_table_subclass property array
top

h

$hour
in file Date.php, variable DB_Table_Date::$hour
    the hour
top

i

$idx
in file Table.php, variable DB_Table::$idx
    Associative array of index definitions.
$idx
in file Generator.php, variable DB_Table_Generator::$idx
    Array of index/constraint definitions.
$idxname_format
in file Generator.php, variable DB_Table_Generator::$idxname_format
    MDB2 'idxname_format' option, format of index names
ibase.php
procedural page ibase.php
insert
in file Database.php, method DB_Table_Database::insert()
    Inserts a single table row
insert
in file Table.php, method DB_Table::insert()
    Inserts a single table row.
isBigint
in file Valid.php, method DB_Table_Valid::isBigint()
    Check if a value validates against the 'bigint' data type.
isBoolean
in file Valid.php, method DB_Table_Valid::isBoolean()
    Check if a value validates against the 'boolean' data type.
isChar
in file Valid.php, method DB_Table_Valid::isChar()
    Check if a value validates against the 'char' and 'varchar' data type.
isClob
in file Valid.php, method DB_Table_Valid::isClob()
    Check if a value validates against the 'clob' data type.
isDate
in file Valid.php, method DB_Table_Valid::isDate()
    Check if a value validates against the 'date' data type.
isDecimal
in file Valid.php, method DB_Table_Valid::isDecimal()
    Check if a value validates against the 'decimal' data type.
isDouble
in file Valid.php, method DB_Table_Valid::isDouble()
    Check if a value validates against the 'double' data type.
isInteger
in file Valid.php, method DB_Table_Valid::isInteger()
    Check if a value validates against the 'integer' data type.
isRequired
in file Table.php, method DB_Table::isRequired()
    Is a specific column required to be set and non-null?
isSingle
in file Valid.php, method DB_Table_Valid::isSingle()
    Check if a value validates against the 'single' data type.
isSmallint
in file Valid.php, method DB_Table_Valid::isSmallint()
    Check if a value validates against the 'smallint' data type.
isTime
in file Valid.php, method DB_Table_Valid::isTime()
    Check if a value validates against the 'time' data type.
isTimestamp
in file Valid.php, method DB_Table_Valid::isTimestamp()
    Check if a value validates against the 'timestamp' data type.
isValid
in file Table.php, method DB_Table::isValid()
    Checks if a value validates against the DB_Table data type for a given column. This only checks that it matches the data type; it does not do extended validation.
top

l

lineElement
in file XML.php, method DB_Table_XML::lineElement()
    Returns string single line XML element <tag>text</tag>
listTableConstraints
in file pgsql.php, method DB_Table_Manager_pgsql::listTableConstraints()
    list all constraints in a table
listTableConstraints
in file sqlite.php, method DB_Table_Manager_sqlite::listTableConstraints()
    list all constraints in a table
listTableConstraints
in file ibase.php, method DB_Table_Manager_ibase::listTableConstraints()
    list all constraints in a table
listTableConstraints
in file oci8.php, method DB_Table_Manager_oci8::listTableConstraints()
    list all constraints in a table
listTableConstraints
in file mysql.php, method DB_Table_Manager_mysql::listTableConstraints()
    list all constraints in a table
listTableConstraints
in file mysqli.php, method DB_Table_Manager_mysqli::listTableConstraints()
    list all constraints in a table
listTableIndexes
in file sqlite.php, method DB_Table_Manager_sqlite::listTableIndexes()
    list all indexes in a table
listTableIndexes
in file ibase.php, method DB_Table_Manager_ibase::listTableIndexes()
    list all indexes in a table
listTableIndexes
in file mysql.php, method DB_Table_Manager_mysql::listTableIndexes()
    list all indexes in a table
listTableIndexes
in file oci8.php, method DB_Table_Manager_oci8::listTableIndexes()
    list all indexes in a table
listTableIndexes
in file mysqli.php, method DB_Table_Manager_mysqli::listTableIndexes()
    list all indexes in a table
listTableIndexes
in file pgsql.php, method DB_Table_Manager_pgsql::listTableIndexes()
    list all indexes in a table
top

m

$minute
in file Date.php, variable DB_Table_Date::$minute
    the minute
$month
in file Date.php, variable DB_Table_Date::$month
    the month
mysql.php
procedural page mysql.php
mysqli.php
procedural page mysqli.php
Manager.php
procedural page Manager.php
modeSupported
in file Table.php, method DB_Table::modeSupported()
    Is a creation mode supported for a RDBMS by DB_Table?
top

n

$name
in file Database.php, variable DB_Table_Database::$name
    Name of the database
$name
in file Generator.php, variable DB_Table_Generator::$name
    Name of the database
nextID
in file Table.php, method DB_Table::nextID()
    Generates and returns a sequence value.
top

o

oci8.php
procedural page oci8.php
onDeleteAction
in file Database.php, method DB_Table_Database::onDeleteAction()
    Implements ON DELETE actions triggered by deletion of rows of $table_obj that match logical condition $where.
onUpdateAction
in file Database.php, method DB_Table_Database::onUpdateAction()
    Implements any ON UPDATE actions triggered by updating of rows of $table_obj that match logical condition $where.
openTag
in file XML.php, method DB_Table_XML::openTag()
    Returns XML closing tag <tag>, increases $indent by 3 spaces
top

p

$partsecond
in file Date.php, variable DB_Table_Date::$partsecond
    the parts of a second
$primary_key
in file Generator.php, variable DB_Table_Generator::$primary_key
    Array of primary keys
pgsql.php
procedural page pgsql.php
top

q

QuickForm.php
procedural page QuickForm.php
quote
in file Table.php, method DB_Table::quote()
    Escapes and enquotes a value for use in an SQL query.
quote
in file Database.php, method DB_Table_Database::quote()
    Returns SQL literal string representation of a php value
top

r

recast
in file Table.php, method DB_Table::recast()
    Forces array elements to the proper types for their columns.
top

s

$second
in file Date.php, variable DB_Table_Date::$second
    the second
$sql
in file Base.php, variable DB_Table_Base::$sql
    Baseline SELECT maps for buildSQL() and select*() methods.
sqlite.php
procedural page sqlite.php
select
in file Base.php, method DB_Table_Base::select()
    Selects rows using one of the DB/MDB2 get*() methods.
selectCount
in file Base.php, method DB_Table_Base::selectCount()
    Counts the number of rows which will be returned by a query.
selectResult
in file Base.php, method DB_Table_Base::selectResult()
    Selects rows as a DB_Result/MDB2_Result_* object.
setActOnDelete
in file Database.php, method DB_Table_Database::setActOnDelete()
    Turns on (or off) automatic php emulation of SQL ON DELETE actions
setActOnUpdate
in file Database.php, method DB_Table_Database::setActOnUpdate()
    Turns on (or off) automatic php emulation of ON UPDATE actions
setAutoInc
in file Table.php, method DB_Table::setAutoInc()
    Turns on or off auto-incrementing of $auto_inc_col column (if any)
setCheckFKey
in file Database.php, method DB_Table_Database::setCheckFKey()
    Turns on (or off) validation of foreign key values on insert and update
setDatabaseInstance
in file Table.php, method DB_Table::setDatabaseInstance()
    Connect or disconnect a DB_Table_Database instance to this table instance.
setDBconnection
in file Database.php, method DB_Table_Database::setDBconnection()
    Set DB/MDB2 connection instance for database and all tables
setErrorMessage
in file Generator.php, method DB_Table_Generator::setErrorMessage()
    Overwrites one or more error messages, e.g., to internationalize them.
setErrorMessage
in file Base.php, method DB_Table_Base::setErrorMessage()
    Overwrites one or more error messages, e.g., to internationalize them.
setErrorMessage
in file Table.php, method DB_Table::setErrorMessage()
    Overwrite one or more error messages, e.g. to internationalize them.
setFixCase
in file Database.php, method DB_Table_Database::setFixCase()
    Sets backend option such that column keys in associative array return sets are converted to fixed case, if true, or mixed case, if false.
setOnDelete
in file Database.php, method DB_Table_Database::setOnDelete()
    Modifies the on delete action for one foreign key reference.
setOnUpdate
in file Database.php, method DB_Table_Database::setOnUpdate()
    Modifies on update action for one foreign key reference.
setTableSubclassPath
in file Database.php, method DB_Table_Database::setTableSubclassPath()
    Sets path to a directory containing DB_Table subclass definitions.
supported
in file Table.php, method DB_Table::supported()
    Is a particular RDBMS supported by DB_Table?
top

t

$table
in file Table.php, variable DB_Table::$table
    The table or view in the database to which this object binds.
$tables
in file Generator.php, variable DB_Table_Generator::$tables
    Numerical array of table name strings
Table.php
procedural page Table.php
tableExists
in file Manager.php, method DB_Table_Manager::tableExists()
    Check whether a table exists.
tableName
in file Generator.php, method DB_Table_Generator::tableName()
    Returns a valid variable name from a table name
throwError
in file Generator.php, method DB_Table_Generator::throwError()
    Specialized version of throwError() modeled on PEAR_Error.
throwError
in file Base.php, method DB_Table_Base::throwError()
    Specialized version of throwError() modeled on PEAR_Error.
toXML
in file Table.php, method DB_Table::toXML()
    Returns XML string representation of the table
toXML
in file Database.php, method DB_Table_Database::toXML()
    Returns XML string representation of database declaration
top

u

update
in file Table.php, method DB_Table::update()
    Update table row or rows that match a custom WHERE clause
update
in file Database.php, method DB_Table_Database::update()
    Updates all row(s) of table that match a custom where clause.
top

v

Valid.php
procedural page Valid.php
validCol
in file Database.php, method DB_Table_Database::validCol()
    Validates and (if necessary) disambiguates a column name.
validForeignKeys
in file Database.php, method DB_Table_Database::validForeignKeys()
    Check validity of any foreign key values in associative array $data containing values to be inserted or updated in table $table_name.
validInsert
in file Table.php, method DB_Table::validInsert()
    Validates an array for insertion into the table.
validUpdate
in file Table.php, method DB_Table::validUpdate()
    Validates an array for updating the table.
verify
in file Manager.php, method DB_Table_Manager::verify()
    Verify whether the table and columns exist, whether the columns have the right type and whether the indexes exist.
verify
in file Table.php, method DB_Table::verify()
    Verifies the table based on $this->col and $this->idx.
top

x

XML.php
procedural page XML.php
top

y

$year
in file Date.php, variable DB_Table_Date::$year
    the year
top

Documentation generated on Thu, 25 Dec 2008 15:00:09 -0500 by phpDocumentor 1.4.0. PEAR Logo Copyright © PHP Group 2004.