function test_mysqlstore()
{
// If the mysql extension isn't loaded or loadable, succeed
// because we can't run the test.
if (!(extension_loaded('mysql') || @dl('mysql.' . PHP_SHLIB_SUFFIX))) {
print "(not testing MySQL store)";
$this->pass();
return;
}
require_once 'Auth/OpenID/MySQLStore.php';
require_once 'DB.php';
global $_Auth_OpenID_db_test_host;
$dsn = array('phptype' => 'mysql', 'username' => 'openid_test', 'password' => '', 'hostspec' => $_Auth_OpenID_db_test_host);
$db =& DB::connect($dsn);
if (PEAR::isError($db)) {
print "MySQL database connection failed: " . $db->getMessage();
$this->pass();
return;
}
$temp_db_name = _Auth_OpenID_getTmpDbName();
$result = $db->query("CREATE DATABASE {$temp_db_name}");
if (PEAR::isError($result)) {
$this->pass("Error creating MySQL temporary database: " . $result->getMessage());
return;
}
$db->query("USE {$temp_db_name}");
$store =& new Auth_OpenID_MySQLStore($db);
$store->createTables();
$this->_testStore($store);
$this->_testNonce($store);
$this->_testNonceCleanup($store);
$db->query("DROP DATABASE {$temp_db_name}");
}
function test_mysqlstore()
{
global $_Auth_OpenID_db_test_host;
$dsn = array('phptype' => 'mysql', 'username' => 'openid_test', 'password' => '', 'hostspec' => $_Auth_OpenID_db_test_host);
$db = dbLayerTransaction::getInstance('mysql', 'localhost', 'test', 'root', '', false);
$temp_db_name = _Auth_OpenID_getTmpDbName();
$result = $db->query("CREATE DATABASE {$temp_db_name}");
$db = dbLayerTransaction::getInstance('mysql', 'localhost', $temp_db_name, 'root', '', false);
$store =& new WMySqlStore($db);
$store->createTables();
$this->_testStore($store);
$this->_testNonce($store);
$this->_testNonceCleanup($store);
$db->query("DROP DATABASE {$temp_db_name}");
}
function test_mdb2store()
{
// The MDB2 test can use any database engine. MySQL is chosen
// arbitrarily.
if (!(extension_loaded('mysql') || function_exists('dl') && @dl('mysql.' . PHP_SHLIB_SUFFIX)) || !@(include_once 'MDB2.php')) {
print "(not testing MDB2 store)";
$this->pass();
return;
}
require_once 'Auth/OpenID/MDB2Store.php';
global $_Auth_OpenID_db_test_host;
$dsn = array('phptype' => 'mysql', 'username' => 'openid_test', 'password' => '', 'hostspec' => $_Auth_OpenID_db_test_host);
$db =& MDB2::connect($dsn);
if (PEAR::isError($db)) {
print "MySQL database connection failed: " . $db->getMessage();
$this->pass();
return;
}
$temp_db_name = _Auth_OpenID_getTmpDbName();
$result = $db->query("CREATE DATABASE {$temp_db_name}");
if (PEAR::isError($result)) {
$this->pass("Error creating MySQL temporary database: " . $result->getMessage());
return;
}
$db->query("USE {$temp_db_name}");
$store =& new Auth_OpenID_MDB2Store($db);
if (!$store->createTables()) {
$this->fail("Failed to create tables");
return;
}
$this->_testStore($store);
$this->_testNonce($store);
$this->_testNonceCleanup($store);
$db->query("DROP DATABASE {$temp_db_name}");
}
function test_mysqlstore()
{
global $_Auth_OpenID_db_test_host;
$db = DbLayerTransSingleton::getInstance('mysql', 'localhost', 'test', 'root', '', false);
$temp_db_name = _Auth_OpenID_getTmpDbName();
$result = $db->execute("CREATE DATABASE {$temp_db_name}");
$db = DbLayerTransSingleton::getInstance('mysql', 'localhost', $temp_db_name, 'root', '', false);
$result = $db->execute("USE {$temp_db_name}");
$store =& new WMySqlStore($db);
$store->createTables();
$this->_testStore($store);
$this->_testNonce($store);
$this->_testNonceCleanup($store);
$db->execute("DROP DATABASE {$temp_db_name}");
}
