| [ Index ] |
|
Code source de CMS made simple 1.0.5 |
[Code source] [Imprimer] [Statistiques]
(pas de description)
| Poids: | 1069 lignes (27 kb) |
| Inclus ou requis: | 2 fois |
| Référencé: | 0 fois |
| Nécessite: | 0 fichiers |
ADODB_DataDict:: (34 méthodes):
SetFetchMode()
outp()
GetCommentSQL()
SetCommentSQL()
MetaTables()
MetaColumns()
_findschema()
MetaPrimaryKeys()
MetaIndexes()
MetaType()
NameQuote()
TableName()
ExecuteSQLArray()
ActualType()
CreateDatabase()
CreateIndexSQL()
DropIndexSQL()
SetSchema()
AddColumnSQL()
AlterColumnSQL()
RenameColumnSQL()
DropColumnSQL()
DropTableSQL()
RenameTableSQL()
CreateTableSQL()
_GenFields()
_GetSize()
_CreateSuffix()
_IndexSQL()
_DropAutoIncrement()
_TableSQL()
_Triggers()
_Options()
ChangeTableSQL()
Classe: ADODB_DataDict - X-Ref
| SetFetchMode($mode) X-Ref |
| Pas de description |
| outp($text) X-Ref |
| Pas de description |
| GetCommentSQL($table,$col) X-Ref |
| Pas de description |
| SetCommentSQL($table,$col,$cmt) X-Ref |
| Pas de description |
| MetaTables() X-Ref |
param: ttype can either be 'VIEW' or 'TABLE' or false. param: showSchema returns the schema/user with the table name, eg. USER.TABLE param: mask is the input mask - only supported by oci8 and postgresql return: array of tables for current database. |
| MetaColumns($table, $upper=true, $schema=false) X-Ref |
| List columns in a database as an array of ADOFieldObjects. See top of file for definition of object. param: table table name to query param: upper uppercase table name (required by some databases) return: array of ADOFieldObjects for current table. |
| _findschema(&$table,&$schema) X-Ref |
| Pas de description |
| MetaPrimaryKeys($tab,$owner=false,$intkey=false) X-Ref |
returns: an array with the primary key columns in it. |
| MetaIndexes($table, $primary = false, $owner = false) X-Ref |
| List indexes on a table as an array. param: table table name to query param: primary true to only show primary keys. Not actually used for most databases return: array of indexes on current table. Each element represents an index, and is itself an associative array. |
| MetaType($t,$len=-1,$fieldobj=false) X-Ref |
| Pas de description |
| NameQuote($name = NULL,$allowBrackets=false) X-Ref |
| Pas de description |
| TableName($name) X-Ref |
| Pas de description |
| ExecuteSQLArray($sql, $continueOnError = true) X-Ref |
| Pas de description |
| ActualType($meta) X-Ref |
| Pas de description |
| CreateDatabase($dbname,$options=false) X-Ref |
| Pas de description |
| CreateIndexSQL($idxname, $tabname, $flds, $idxoptions = false) X-Ref |
| Pas de description |
| DropIndexSQL($idxname, $tabname = NULL) X-Ref |
| Pas de description |
| SetSchema($schema) X-Ref |
| Pas de description |
| AddColumnSQL($tabname, $flds) X-Ref |
| Pas de description |
| AlterColumnSQL($tabname, $flds, $tableflds='',$tableoptions='') X-Ref |
| Change the definition of one column As some DBM's can't do that on there own, you need to supply the complete defintion of the new table, to allow, recreating the table and copying the content over to the new table param: string $tabname table-name param: string $flds column-name and type for the changed column param: string $tableflds='' complete defintion of the new table, eg. for postgres, default '' param: array/string $tableoptions='' options for the new table see CreateTableSQL, default '' return: array with SQL strings |
| RenameColumnSQL($tabname,$oldcolumn,$newcolumn,$flds='') X-Ref |
| Rename one column Some DBM's can only do this together with changeing the type of the column (even if that stays the same, eg. mysql) param: string $tabname table-name param: string $oldcolumn column-name to be renamed param: string $newcolumn new column-name param: string $flds='' complete column-defintion-string like for AddColumnSQL, only used by mysql atm., default='' return: array with SQL strings |
| DropColumnSQL($tabname, $flds, $tableflds='',$tableoptions='') X-Ref |
| Drop one column Some DBM's can't do that on there own, you need to supply the complete defintion of the new table, to allow, recreating the table and copying the content over to the new table param: string $tabname table-name param: string $flds column-name and type for the changed column param: string $tableflds='' complete defintion of the new table, eg. for postgres, default '' param: array/string $tableoptions='' options for the new table see CreateTableSQL, default '' return: array with SQL strings |
| DropTableSQL($tabname) X-Ref |
| Pas de description |
| RenameTableSQL($tabname,$newname) X-Ref |
| Pas de description |
| CreateTableSQL($tabname, $flds, $tableoptions=false) X-Ref |
| Pas de description |
| _GenFields($flds,$widespacing=false) X-Ref |
| Pas de description |
| _GetSize($ftype, $ty, $fsize, $fprec) X-Ref |
| Pas de description |
| _CreateSuffix($fname,$ftype,$fnotnull,$fdefault,$fautoinc,$fconstraint) X-Ref |
| Pas de description |
| _IndexSQL($idxname, $tabname, $flds, $idxoptions) X-Ref |
| Pas de description |
| _DropAutoIncrement($tabname) X-Ref |
| Pas de description |
| _TableSQL($tabname,$lines,$pkey,$tableoptions) X-Ref |
| Pas de description |
| _Triggers($tabname,$taboptions) X-Ref |
| Pas de description |
| _Options($opts) X-Ref |
| Pas de description |
| ChangeTableSQL($tablename, $flds, $tableoptions = false) X-Ref |
| Pas de description |
| ctype_alnum($text) X-Ref |
| Pas de description |
| _array_change_key_case($an_array) X-Ref |
| Pas de description |
| Lens_ParseArgs($args,$endstmtchar=',',$tokenchars='_.-') X-Ref |
| Pas de description |
| Généré le : Tue Apr 3 18:50:37 2007 | par Balluche grâce à PHPXref 0.7 |