PEAR is archived and read-only

This mirror preserves historical PEAR package releases and metadata so existing references remain available.

Home » Database » DB_Table

An object oriented interface to, and model of, a database. Integrates with HTML_QuickForm.

This package is unmaintained.

Download latest release 1.5.6 (archived versions might be outdated)

License: New BSD

Description

The DB_Table package provides an object oriented interface to a database.

Each instance of the core DB_Table class contains the schema for a table, defined using abstract data types. The class provides a portable api for insert, update, delete, and select SQL commands, and can validate data types upon insertion and updating. It provides methods to automatically create or verify a database table. DB_Table also provides methods (using PEAR HTML_QuickForm) to generate input forms that match the column definitions.

Each instance of the DB_Table_Database class contains a model of relationships between tables in a database, in which each table is represented by an instance of DB_Table. DB_Table_Database provides a method for automatic construction of join conditions for inner joins involving any number of tables, optional php validation of foreign key validity, and optional php emulation of actions triggered on delete or update of referenced rows, such as cascading deletes.

The DB_Table_Generator class auto-generates the php code necessary to create an interface to an existing database.

Documentation

Manual

Maintainers

Dependencies

Required

Optional

Releases

Bugs

IDStatusTypeVersionDateSummary
#1541ClosedReq2004-06-022 little feature requests
#1671ClosedBug2004-06-17Missing dependency
#1794ClosedBug2004-07-05Bug in creation of (adv)checkbox
#1797ClosedBug2004-07-05Missing QF rules
#1837ClosedBug2004-07-10Joins don't work not as they're documented
#1855ClosedBug2004-07-12QuickForm: Error "$type not defined" because piece of code is wrong positioned
#2160BogusReq2004-08-19Different Tables in one class definition
#2522ClosedReq2004-10-13[PATCH] Create bare QuickForm
#2596Wont fixReq2004-10-23Native MySQL timestamps needed
#2789ClosedReq2004-11-18[PATCH] Per-query fetchmodes
#2790ClosedReq2004-11-18[PATCH] getFormElements()
#2799ClosedBug2004-11-19Error in getFormElement
#2842SuspendedReq2004-11-27autodrop sequencing table - w/ patch
#2906ClosedReq2004-12-06$this->table attribute acces
#2918ClosedBug2004-12-08DB_Table::recast($data) timestamp zero packing
#3017ClosedReq2004-12-22[PATCH[ selectCount()
#3018ClosedReq2004-12-22Data overrides in getElement
#3360ClosedBug2005-02-02missing dep on DB
#3407ClosedReq2005-02-08add "name" for static QF elements
#3825ClosedReq2005-03-15Change $elemname in error messages to $col['qf_label']
#3892ClosedBug2005-03-20Error in DB_Table_QuickForm->addElements
#4209BogusBug2005-04-22Uncontroled restrictions to field names
#4610ClosedReq2005-06-16small addition to fixColDef()
#4614ClosedBug2005-06-16radios do not line up
#4657ClosedReq2005-06-21allow adding of null values to the database
#4935ClosedBug2005-07-28DB_Table_Quickform: Element names as Array-Keys not respected for radio buttons
#4941ClosedReq2005-07-28allow a label after (adv)checkbox elements
#5029ClosedReq2005-08-08[PATCH] HTML_QuickForm filter support
#5060No FeedbackBug2005-08-10empty date fields cause data to be invalid
#5382ClosedBug2005-09-13Radios not filled with default Value
#5478ClosedReq2005-09-21Verify schema/referential integrity
#5479ClosedReq2005-09-21Deeper abstraction of DB_Table
#5552ClosedDoc2005-09-28No explanation of properties
#5679ClosedBug2005-10-13Warning if no table-index defined
#5915BogusBug2005-11-09radio button value do not select dynamically by default value
#5965ClosedReq2005-11-15Turn off automatic setting of qf_rules
#6012BogusBug2005-11-19Lack of support for datetime
#6025ClosedBug2005-11-21$auto_create & postgres & table names containing uppercase letters
#6036ClosedReq2005-11-22interface to add further Quickform-Elements
#6384ClosedReq2005-12-31add MDB2
#6497BogusBug2006-01-15this->table got parse error
#6655ClosedBug1.2.12006-02-01column Default
#6749BogusReq1.2.12006-02-10Wondering if you'd like to use this as a log example
#7287ClosedBugCVS2006-04-04create is triggered while in 'alter' mode
#7398ClosedReq1.3.0RC42006-04-14Validation against QuickForm parameters not wanted
#7568No FeedbackBug1.3.02006-05-05recast and quoted date/timestamp values
#8249ClosedReq1.3.12006-07-19  in grouped Radio-Elements
#8268ClosedBug1.3.12006-07-23selectCount() gives pear error, if as-names are used for where, group, order
#8485ClosedReqCVS2006-08-16Remove assumption that DB_Table will be subclassed
#8760Wont fixReq2006-09-21Insert only if row doesn't exist
#8767Wont fixReq1.3.22006-09-22Only expand index names for PostgreSQL
#8874Wont fixBugCVS2006-10-06Test (please ignore)
#9141ClosedReq1.3.22006-10-23Support for hierselect
#9240ClosedDoc1.3.22006-11-06wrong documentation
#9441SpamReqCVS2006-11-24freeman
#9593ClosedBug1.4.02006-12-10incorrect mapping
#9686SpamReqCVS2006-12-23malekss
#11077Wont fixReq1.5.0RC22007-05-19generate real check box forms
#11278SuspendedReq1.5.0RC22007-06-11Need a method to drop exist columns in DB_Table_Manager class
#11298SuspendedReqCVS2007-06-12Ability to mark columns as ignored
#11986ClosedDoc2007-09-05User note that is a documentation problem
#12093ClosedDoc1.5.02007-09-21line '$generator =& DB_Table_Generator($conn, $database);' ->undefined function
#12136ClosedReq1.5.02007-09-28Support for 'link' QF element
#12137SuspendedReq1.5.02007-09-28Add support for queries in QF 'select' elements
#12190ClosedBug1.5.02007-10-06missing error return in DB_Table_Manager::create()
#12208ClosedBug1.5.02007-10-09wrong verification of clob fields with mysql(i) backend
#12214SuspendedReq1.5.02007-10-10Support MDB2_Schema description and comments tags
#12247ClosedBug1.5.02007-10-15'require' attribute is name 'required' in Generator
#12497ClosedBug2007-11-21Generator works only with DB, but not with MDB2
#12510ClosedReqCVS2007-11-23some changes in Generator.php
#12989SuspendedReq1.5.02008-01-28new method/callback: defineColumns?
#13267ClosedReqCVS2008-02-29Table name should be optional in constructor parameter list
#13700DuplicateBug1.5.12008-04-17bug?
#13701ClosedBug1.5.12008-04-17Undefined variable $db in Generator.php
#13728ClosedBug1.5.12008-04-20DB_Table_Generator produces invalid php code when using pgsql
#13858DuplicateBug1.5.12008-05-08Notice: Undefined variable: db in /includes/p
#13949No FeedbackReq1.5.22008-05-20Generator should enclose building Database instance in a function
#14048ClosedDoc2008-06-02User note that is a documentation problem
#14082ClosedBug1.5.22008-06-05DB_Table_Manager::getIndexes() misbehaviour
#14106ClosedBugCVS2008-06-08"PRIMARY" not allowed as index name
#14224BogusBug1.5.52008-06-24Decimal Column's Scale Bug of generated Table Class
#14262ClosedReq1.5.52008-06-30Ability to change maximum length of sequences
#14688BogusReq1.5.52008-09-22Can't insert with an auto increment field without having a sequence table
#15370Wont fixReq1.5.52008-12-21Build Form without DB-Connection
#15871No FeedbackBug1.5.62009-02-03Alter table problems when changing size
#17707AssignedBugSVN2010-08-16Failing tests
#18514SpamDoc2011-05-10User note that is a documentation problem
#18515SpamDoc2011-05-10User note that is a documentation problem
#18516SpamDoc2011-05-10User note that is a documentation problem
#18517SpamDoc2011-05-10User note that is a documentation problem
#18518SpamDoc2011-05-10User note that is a documentation problem
#18519SpamDoc2011-05-10User note that is a documentation problem
#18520SpamDoc2011-05-10User note that is a documentation problem
#18522SpamDoc2011-05-10User note that is a documentation problem