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 ]
[ _ ]
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
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
top
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
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
top
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
top
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
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
top
top
Documentation generated on Mon, 11 Mar 2019 15:28:00 -0400 by phpDocumentor 1.4.4. PEAR Logo Copyright © PHP Group 2004.
|
|