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"); }