From 0bd921db9e40fbfa05366b2db8c5d416861df6e5 Mon Sep 17 00:00:00 2001 From: stronk7 Date: Tue, 12 Sep 2006 22:20:50 +0000 Subject: [PATCH] Added support for add_field and drop_field --- lib/xmldb/classes/XMLDBTable.class.php | 55 ++++++++++++++++++++++++++ 1 file changed, 55 insertions(+) diff --git a/lib/xmldb/classes/XMLDBTable.class.php b/lib/xmldb/classes/XMLDBTable.class.php index 2ea9f5e6b4..1f869bb592 100644 --- a/lib/xmldb/classes/XMLDBTable.class.php +++ b/lib/xmldb/classes/XMLDBTable.class.php @@ -818,6 +818,61 @@ class XMLDBTable extends XMLDBObject { } return $results; } + + /** + * This function will return the SQL code needed to add one field to the table for the specified DB and + * prefix. Just one simple wrapper over generators. + */ + function getAddFieldSQL ($dbtype, $prefix, $xmldb_field, $statement_end=true) { + + $results = array(); + + $classname = 'XMLDB' . $dbtype; + $generator = new $classname(); + $generator->setPrefix($prefix); + $results = $generator->getAddFieldSQL($this, $xmldb_field); + if ($statement_end) { + $results = $generator->getEndedStatements($results); + } + return $results; + } + + /** + * This function will return the SQL code needed to drop one field from the table for the specified DB and + * prefix. Just one simple wrapper over generators. + */ + function getDropFieldSQL ($dbtype, $prefix, $xmldb_field, $statement_end=true) { + + $results = array(); + + $classname = 'XMLDB' . $dbtype; + $generator = new $classname(); + $generator->setPrefix($prefix); + $results = $generator->getDropFieldSQL($this, $xmldb_field); + if ($statement_end) { + $results = $generator->getEndedStatements($results); + } + return $results; + } + + /** + * This function will return the SQL code needed to rename one field from the table for the specified DB and + * prefix. Just one simple wrapper over generators. + */ + function getRenameFieldSQL ($dbtype, $prefix, $xmldb_field, $newname, $statement_end=true) { + + $results = array(); + + $classname = 'XMLDB' . $dbtype; + $generator = new $classname(); + $generator->setPrefix($prefix); + $results = $generator->getRenameFieldSQL($this, $xmldb_field, $newname); + if ($statement_end) { + $results = $generator->getEndedStatements($results); + } + return $results; + } + } ?> -- 2.39.5