/** * Checks to see if the diagrams database and schema exists * @return TRUE Success * @return FALSE Fail */ public static function check_diagrams_database_and_schema() { global $data, $misc; $rs = $data->getDatabase(ERDiagram::$store_database); if ($rs->recordCount() != 1) { return FALSE; } // Create a new database access object. ERDiagram::$store_driver = $misc->getDatabaseAccessor(ERDiagram::$store_database); $sql = "SELECT nspname FROM pg_catalog.pg_namespace WHERE nspname='" . pg_escape_string(ERDiagram::$store_schema) . "'"; $rs = ERDiagram::$store_driver->selectSet($sql); if ($rs->recordCount() != 1) { return FALSE; } ERDiagram::$store_driver->setSchema(ERDiagram::$store_schema); return TRUE; }