require_once dirname(__FILE__).'/../include/CLegacyWebTest.php';
require_once dirname(__FILE__).'/behaviors/CMessageBehavior.php';
class testPageAdministrationDMProxies extends CLegacyWebTest {
private $sqlHashProxy = '';
private $oldHashProxy = '';
private $sqlHashInterface = '';
private $oldHashInterface = '';
private $sqlHashHosts = '';
private $oldHashHosts = '';
private $sqlHashDRules = '';
private $oldHashDRules = '';
public function getBehaviors() {
return [CMessageBehavior::class];
private function calculateHash($proxy_hostid) {
$this->sqlHashProxy = 'SELECT * FROM hosts WHERE hostid='.$proxy_hostid;
$this->oldHashProxy = CDBHelper::getHash($this->sqlHashProxy);
$this->sqlHashInterface = 'SELECT * FROM interface WHERE hostid='.$proxy_hostid.' ORDER BY interfaceid';
$this->oldHashInterface = CDBHelper::getHash($this->sqlHashInterface);
$this->sqlHashHosts = 'SELECT hostid,proxy_hostid FROM hosts WHERE proxy_hostid='.$proxy_hostid.' ORDER BY hostid';
$this->oldHashHosts = CDBHelper::getHash($this->sqlHashHosts);
$this->sqlHashDRules = 'SELECT druleid,proxy_hostid FROM drules WHERE proxy_hostid='.$proxy_hostid.' ORDER BY druleid';
$this->oldHashDRules = CDBHelper::getHash($this->sqlHashDRules);
private function verifyHash() {
$this->assertEquals($this->oldHashProxy, CDBHelper::getHash($this->sqlHashProxy));
$this->assertEquals($this->oldHashInterface, CDBHelper::getHash($this->sqlHashInterface));
$this->assertEquals($this->oldHashHosts, CDBHelper::getHash($this->sqlHashHosts));
$this->assertEquals($this->oldHashDRules, CDBHelper::getHash($this->sqlHashDRules));
public static function proxies() {
return CDBHelper::getDataProvider(