/**
* it loads data about all servers, and return array of them
*
* @return array array of DatabaseServers
*/
public static function getServers()
{
self::setUpConnection();
$select = self::$db->select();
$databaseServer = new DatabaseServer();
$data = $select->From($databaseServer->getTableName())->query()->fetchAll();
$servers = array();
foreach ($data as $row) {
$server = new DatabaseServer();
$server->setData($row);
$servers[] = $server;
}
return $servers;
}
/**
* method bases on url server name and creates appropriate server object
*
* @param string $urlName
* @return DatabaseServer
*/
public static function getServer($urlName)
{
self::setUpConnection();
$sampleServer = new DatabaseServer();
if (!is_null($urlName)) {
$select = self::$db->select();
$data = $select->From($sampleServer->getTableName())->Where('urlName = ?', $urlName)->query()->fetch();
if ($data) {
$server = new DatabaseServer();
$server->setData($data);
return $server;
}
}
//return default server
$select = self::$db->select();
$data = $select->From($sampleServer->getTableName())->query()->fetch();
$server = new DatabaseServer();
$server->setData($data);
return $server;
}
