| [ Index ] |
PHP Cross Reference of Moodle 1.9.3 [Build 15-Oct-2008] |
[Source view] [Print] [Project Stats]
(no description)
| File Size: | 643 lines (29 kb) |
| Included or required: | 0 times |
| Referenced: | 0 times |
| Includes or requires: | 0 files |
XMLDBoci8po:: (20 methods):
XMLDBoci8po()
getTypeSQL()
getEnumExtraSQL()
getCreateSequenceSQL()
getCreateTriggerSQL()
getDropSequenceSQL()
getCommentSQL()
getRenameFieldExtraSQL()
getDropTableExtraSQL()
getRenameTableExtraSQL()
getAlterFieldSQL()
getCreateEnumSQL()
getDropEnumSQL()
getCreateDefaultSQL()
getDropDefaultSQL()
getCheckConstraintsFromDB()
getSequenceFromDB()
getTriggerFromDB()
isNameInUse()
getReservedWords()
Class: XMLDBoci8po - X-Ref
| XMLDBoci8po() X-Ref |
| Creates one new XMLDBoci8po |
| getTypeSQL($xmldb_type, $xmldb_length=null, $xmldb_decimals=null) X-Ref |
| Given one XMLDB Type, lenght and decimals, returns the DB proper SQL type |
| getEnumExtraSQL($xmldb_table, $xmldb_field) X-Ref |
| Returns the code needed to create one enum for the xmldb_table and xmldb_field passes |
| getCreateSequenceSQL($xmldb_table, $xmldb_field) X-Ref |
| Returns the code needed to create one sequence for the xmldb_table and xmldb_field passes |
| getCreateTriggerSQL($xmldb_table, $xmldb_field) X-Ref |
| Returns the code needed to create one trigger for the xmldb_table and xmldb_field passed |
| getDropSequenceSQL($xmldb_table, $xmldb_field, $include_trigger=false) X-Ref |
| Returns the code needed to drop one sequence for the xmldb_table and xmldb_field passed Can, optionally, specify if the underlying trigger will be also dropped |
| getCommentSQL($xmldb_table) X-Ref |
| Returns the code (in array) needed to add one comment to the table |
| getRenameFieldExtraSQL($xmldb_table, $xmldb_field, $newname) X-Ref |
| Returns the code (array of statements) needed to execute extra statements on field rename |
| getDropTableExtraSQL($xmldb_table) X-Ref |
| Returns the code (array of statements) needed to execute extra statements on table drop |
| getRenameTableExtraSQL($xmldb_table, $newname) X-Ref |
| Returns the code (array of statements) needed to execute extra statements on table rename |
| getAlterFieldSQL($xmldb_table, $xmldb_field) X-Ref |
| Given one XMLDBTable and one XMLDBField, return the SQL statements needded to alter the field in the table Oracle has some severe limits: - clob and blob fields doesn't allow type to be specified - error is dropped if the null/not null clause is specified and hasn't changed - changes in precision/decimals of numeric fields drop an ORA-1440 error |
| getCreateEnumSQL($xmldb_table, $xmldb_field) X-Ref |
| Given one XMLDBTable and one XMLDBField, return the SQL statements needded to create its enum (usually invoked from getModifyEnumSQL() |
| getDropEnumSQL($xmldb_table, $xmldb_field) X-Ref |
| Given one XMLDBTable and one XMLDBField, return the SQL statements needded to drop its enum (usually invoked from getModifyEnumSQL() |
| getCreateDefaultSQL($xmldb_table, $xmldb_field) X-Ref |
| Given one XMLDBTable and one XMLDBField, return the SQL statements needded to create its default (usually invoked from getModifyDefaultSQL() |
| getDropDefaultSQL($xmldb_table, $xmldb_field) X-Ref |
| Given one XMLDBTable and one XMLDBField, return the SQL statements needded to drop its default (usually invoked from getModifyDefaultSQL() |
| getCheckConstraintsFromDB($xmldb_table, $xmldb_field = null) X-Ref |
| Given one XMLDBTable returns one array with all the check constrainsts in the table (fetched from DB) Optionally the function allows one xmldb_field to be specified in order to return only the check constraints belonging to one field. Each element contains the name of the constraint and its description If no check constraints are found, returns an empty array |
| getSequenceFromDB($xmldb_table) X-Ref |
| Given one XMLDBTable returns one string with the sequence of the table in the table (fetched from DB) The sequence name for oracle is calculated by looking the corresponding trigger and retrieving the sequence name from it (because sequences are independent elements) If no sequence is found, returns false |
| getTriggerFromDB($xmldb_table) X-Ref |
| Given one XMLDBTable returns one string with the trigger in the table (fetched from DB) If no trigger is found, returns false |
| isNameInUse($object_name, $type, $table_name) X-Ref |
| Given one object name and it's type (pk, uk, fk, ck, ix, uix, seq, trg) return if such name is currently in use (true) or no (false) (invoked from getNameForObject() |
| getReservedWords() X-Ref |
| Returns an array of reserved words (lowercase) for this DB |
| Generated: Wed Jan 14 11:33:29 2009 | Cross-referenced by PHPXref 0.7 |