/**
* Set current Adapter
*
* @param string $adapterName
* @param string $append
* @static
* @return bool
*/
static public function SetAdapter($adapterName, $append = false)
{
if (!class_exists("{$adapterName}ScriptingAdapter"))
Core::Load("NET/ScriptingClient/Adapters/{$adapterName}ScriptingAdapter");
$reflect = new ReflectionClass("{$adapterName}ScriptingAdapter");
if ($reflect && $reflect->isInstantiable())
{
if ($append)
$args[] = $append;
if (count($args) > 0)
self::$Adapter = $reflect->newInstanceArgs($args);
else
self::$Adapter = $reflect->newInstance(true);
}
else
Core::RaiseError(_("Object '{$type}ScriptingAdapter' not instantiable."));
if (self::$Adapter)
return true;
else
return false;
}
function testMSSQLAdapter()
{
ScriptingClient::SetAdapter("MSSQL");
ScriptingClient::SetAdapterOption("host", "192.168.1.6:1434");
ScriptingClient::SetAdapterOption("login", "test");
ScriptingClient::SetAdapterOption("password", "test123");
ScriptingClient::SetAdapterOption("dbname", "test");
$conn = ScriptingClient::Connect();
$this->assertTrue($conn, "MSSQLAdapter successfully connected to host");
$script = "INSERT INTO test(test,test2) VALUES(1,2); DELETE FROM test;";
if ($conn)
{
$exec = ScriptingClient::Execute($script, $params);
$this->assertTrue($exec, "MSSQLAdapter successfully executed script");
$dicsonn = ScriptingClient::Disconnect();
$this->assertTrue($dicsonn, "MSSQLAdapter successfully disconnected");
}
}
