function testMySQLTool()
{
$MySQLTool = new MySQLTool();
//
// List databases
//
$retval = $MySQLTool->ListDatabases();
$this->assertTrue(count($retval)> 0, "There are more than 0 database listed");
//
// Create DB
//
$retval = $MySQLTool->CreateDatabase("cptest", "test1");
$this->assertTrue($retval, "Database created succesfully");
//
// Create User
//
$retval = $MySQLTool->CreateUser("cptest", "test1", "testpass0");
$this->assertTrue($retval, "User created succesfully");
//
// Privileges
//
$privileges = array("SELECT", "UPDATE");
$retval = $MySQLTool->SetPrivileges("cptest_test1", "cptest_test1", $privileges);
$this->assertTrue($retval, "Granted rights succesfully");
//
// Delete DB
//
$retval = $MySQLTool->DropDatabase("cptest", "test1");
$this->assertTrue(!in_array("cptest_test1", $MySQLTool->ListDatabases()), "Deleted DB does not exist");
//
// Delete User
//
$retval = $MySQLTool->DropUser("cptest_test1");
$this->assertTrue($retval, "User deleted succesfully");
//
// Server info
//
$retval = $MySQLTool->GetSQLServerVersion();
$this->assertTrue(count($retval) > 2, "SQL server version retreived");
//
// List users
//
$retval = $MySQLTool->ListUsers();
$this->assertTrue(is_array($retval) && count($retval) > 0, "Users list is non-empty array");
}
