| [ Index ] |
PHP Cross Reference of Moodle 1.9.3 [Build 15-Oct-2008] |
[Source view] [Print] [Project Stats]
(no description)
| File Size: | 386 lines (17 kb) |
| Included or required: | 0 times |
| Referenced: | 0 times |
| Includes or requires: | 0 files |
XMLDBmysql:: (12 methods):
XMLDBmysql()
getTypeSQL()
getCreateEnumSQL()
getDropEnumSQL()
getCreateDefaultSQL()
getRenameFieldSQL()
getDropDefaultSQL()
getEnumSQL()
getCommentSQL()
getCheckConstraintsFromDB()
isNameInUse()
getReservedWords()
Class: XMLDBmysql - X-Ref
| XMLDBmysql() X-Ref |
| Creates one new XMLDBmysql |
| getTypeSQL($xmldb_type, $xmldb_length=null, $xmldb_decimals=null) X-Ref |
| Given one XMLDB Type, lenght and decimals, returns the DB proper SQL type |
| 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() |
| getRenameFieldSQL($xmldb_table, $xmldb_field, $newname) X-Ref |
| Given one correct XMLDBField and the new name, returns the SQL statements to rename it (inside one array) MySQL is pretty diferent from the standard to justify this oveloading |
| 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() |
| getEnumSQL($xmldb_field) X-Ref |
| Given one XMLDB Field, return its enum SQL |
| getCommentSQL($xmldb_table) X-Ref |
| Returns the code (in array) needed to add one comment to the table |
| 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 MySQL doesn't have check constraints in this implementation, but we return them based on the enum fields in the table |
| 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 |