/** * @brief Creates tables from XML file * @param string $file file to read structure from * @return bool * * TODO: write more documentation */ public static function createDbFromStructure($file) { $CONFIG_DBNAME = OC_Config::getValue("dbname", "owncloud"); $CONFIG_DBTABLEPREFIX = OC_Config::getValue("dbtableprefix", "oc_"); $CONFIG_DBTYPE = OC_Config::getValue("dbtype", "sqlite"); // cleanup the cached queries self::$preparedQueries = array(); self::connectScheme(); // read file $content = file_get_contents($file); // Make changes and save them to an in-memory file $file2 = 'static://db_scheme'; $content = str_replace('*dbname*', $CONFIG_DBNAME, $content); $content = str_replace('*dbprefix*', $CONFIG_DBTABLEPREFIX, $content); /* FIXME: use CURRENT_TIMESTAMP for all databases. mysql supports it as a default for DATETIME since 5.6.5 [1] * as a fallback we could use <default>0000-01-01 00:00:00</default> everywhere * [1] http://bugs.mysql.com/bug.php?id=27645 * http://dev.mysql.com/doc/refman/5.0/en/timestamp-initialization.html * http://www.postgresql.org/docs/8.1/static/functions-datetime.html * http://www.sqlite.org/lang_createtable.html * http://docs.oracle.com/cd/B19306_01/server.102/b14200/functions037.htm */ if ($CONFIG_DBTYPE == 'pgsql') { //mysql support it too but sqlite doesn't $content = str_replace('<default>0000-00-00 00:00:00</default>', '<default>CURRENT_TIMESTAMP</default>', $content); } file_put_contents($file2, $content); // Try to create tables $definition = self::$schema->parseDatabaseDefinitionFile($file2); //clean up memory unlink($file2); // Die in case something went wrong if ($definition instanceof MDB2_Schema_Error) { OC_Template::printErrorPage($definition->getMessage() . ': ' . $definition->getUserInfo()); } if (OC_Config::getValue('dbtype', 'sqlite') === 'oci') { unset($definition['charset']); //or MDB2 tries SHUTDOWN IMMEDIATE $oldname = $definition['name']; $definition['name'] = OC_Config::getValue("dbuser", $oldname); } // we should never drop a database $definition['overwrite'] = false; $ret = self::$schema->createDatabase($definition); // Die in case something went wrong if ($ret instanceof MDB2_Error) { OC_Template::printErrorPage(self::$MDB2->getDebugOutput() . ' ' . $ret->getMessage() . ': ' . $ret->getUserInfo()); } return true; }