function testDefaultSchemaNameForUser()
{
$user = '******';
$password = '******';
$default_schema = $user;
$another_schema = 'bar';
$this->_dropSchema($default_schema);
$this->_dropSchema($another_schema);
$this->_dropUser($user);
$this->_createSchema($default_schema);
$this->_createSchema($another_schema);
$this->_createUser($user, $password);
$sql = 'CREATE TABLE %schema_name%.test_default_schema_name (
"id" SERIAL,
"value" integer,
PRIMARY KEY (id)
)';
$this->_executeForSchema($sql, $default_schema);
$this->_executeForSchema($sql, $another_schema);
$this->_changeTableOwner($default_schema . '.test_default_schema_name', $user);
$this->_changeTableOwner($another_schema . '.test_default_schema_name', $user);
$sql = "INSERT INTO %schema_name%.test_default_schema_name(value) VALUES(1)";
$this->_executeForSchema($sql, $default_schema);
$dsn = $this->_getDsnForUser($user, $password);
$new_connection = $this->toolkit->createDbConnection($dsn);
lmbToolkit::instance()->setDefaultDbConnection($new_connection);
$sql = "SELECT COUNT(*) as count from test_default_schema_name";
$this->assertEqual(lmbDBAL::fetchOneValue($sql), 1);
$dbinfo = $new_connection->getDatabaseInfo();
$this->assertTrue($dbinfo->hasTable('test_default_schema_name'));
}
protected function _setPriority()
{
if (!($parent_id = $this->getParentId())) {
$parent_id = lmbCmsDocument::findRoot()->getId();
}
$sql = "SELECT MAX(priority) FROM " . $this->_db_table_name . " WHERE parent_id = " . $parent_id;
$max_priority = lmbDBAL::fetchOneValue($sql);
$this->setPriority($max_priority + 10);
}
