'pmadb', 'navwork' => true, 'navigationhiding' => 'navigationhiding', ]); $_SESSION = ['relation' => [$GLOBALS['server'] => $relationParameters->toArray()]]; $this->object = new Navigation( new Template(), new Relation($GLOBALS['dbi']), $GLOBALS['dbi'] ); } /** * Tears down the fixture. */ protected function tearDown(): void { parent::tearDown(); unset($this->object); } /** * Tests hideNavigationItem() method. */ public function testHideNavigationItem(): void { $expectedQuery = 'INSERT INTO `pmadb`.`navigationhiding`' . '(`username`, `item_name`, `item_type`, `db_name`, `table_name`)' . " VALUES ('user','itemName','itemType','db','')"; $dbi = $this->getMockBuilder(DatabaseInterface::class) ->disableOriginalConstructor() ->getMock(); $dbi->expects($this->once()) ->method('tryQueryAsControlUser') ->with($expectedQuery); $dbi->expects($this->any())->method('escapeString') ->will($this->returnArgument(0)); $GLOBALS['dbi'] = $dbi; $this->object = new Navigation(new Template(), new Relation($dbi), $dbi); $this->object->hideNavigationItem('itemName', 'itemType', 'db'); } /** * Tests unhideNavigationItem() method. */ public function testUnhideNavigationItem(): void { $expectedQuery = 'DELETE FROM `pmadb`.`navigationhiding`' . " WHERE `username`='user' AND `item_name`='itemName'" . " AND `item_type`='itemType' AND `db_name`='db'"; $dbi = $this->getMockBuilder(DatabaseInterface::class) ->disableOriginalConstructor() ->getMock(); $dbi->expects($this->once()) ->method('tryQueryAsControlUser') ->with($expectedQuery); $dbi->expects($this->any())->method('escapeString') ->will($this->returnArgument(0)); $GLOBALS['dbi'] = $dbi; $this->object = new Navigation(new Template(), new Relation($dbi), $dbi); $this->object->unhideNavigationItem('itemName', 'itemType', 'db'); } /** * Tests getItemUnhideDialog() method. */ public function testGetItemUnhideDialog(): void { $html = $this->object->getItemUnhideDialog('db'); $this->assertStringContainsString('tableName', $html); $this->assertStringContainsString( '', $html ); } }