userPreferences = new UserPreferences();
}
/**
* Test for pageInit
*/
public function testPageInit(): void
{
$GLOBALS['cfg'] = [
'Server/hide_db' => 'testval123',
'Server/port' => '213',
];
$GLOBALS['cfg']['AvailableCharsets'] = [];
$GLOBALS['cfg']['UserprefsDeveloperTab'] = null;
$this->userPreferences->pageInit(new ConfigFile());
$this->assertEquals(
[
'Servers' => [
1 => ['hide_db' => 'testval123'],
],
],
$_SESSION['ConfigFile' . $GLOBALS['server']]
);
}
/**
* Test for load
*/
public function testLoad(): void
{
$_SESSION['relation'][$GLOBALS['server']]['version'] = Version::VERSION;
$_SESSION['relation'][$GLOBALS['server']]['userconfigwork'] = null;
unset($_SESSION['userconfig']);
$result = $this->userPreferences->load();
$this->assertCount(
3,
$result
);
$this->assertEquals(
[],
$result['config_data']
);
$this->assertEqualsWithDelta(
time(),
$result['mtime'],
2,
''
);
$this->assertEquals(
'session',
$result['type']
);
// case 2
$_SESSION['relation'][$GLOBALS['server']]['userconfigwork'] = 1;
$_SESSION['relation'][$GLOBALS['server']]['db'] = "pma'db";
$_SESSION['relation'][$GLOBALS['server']]['userconfig'] = 'testconf';
$_SESSION['relation'][$GLOBALS['server']]['user'] = 'user';
$dbi = $this->getMockBuilder(DatabaseInterface::class)
->disableOriginalConstructor()
->getMock();
$query = 'SELECT `config_data`, UNIX_TIMESTAMP(`timevalue`) ts '
. 'FROM `pma\'db`.`testconf` WHERE `username` = \'user\'';
$dbi->expects($this->once())
->method('fetchSingleRow')
->with($query, 'ASSOC', DatabaseInterface::CONNECT_CONTROL)
->will(
$this->returnValue(
[
'ts' => '123',
'config_data' => json_encode([1, 2]),
]
)
);
$dbi->expects($this->any())
->method('escapeString')
->will($this->returnArgument(0));
$GLOBALS['dbi'] = $dbi;
$result = $this->userPreferences->load();
$this->assertEquals(
[
'config_data' => [
1,
2,
],
'mtime' => 123,
'type' => 'db',
],
$result
);
}
/**
* Test for save
*/
public function testSave(): void
{
$GLOBALS['server'] = 2;
$_SESSION['relation'][2]['version'] = Version::VERSION;
$_SESSION['relation'][2]['userconfigwork'] = null;
unset($_SESSION['userconfig']);
$result = $this->userPreferences->save([1]);
$this->assertTrue(
$result
);
$this->assertCount(
2,
$_SESSION['userconfig']
);
$this->assertEquals(
[1],
$_SESSION['userconfig']['db']
);
/* TODO: This breaks sometimes as there might be time difference! */
$this->assertEqualsWithDelta(
time(),
$_SESSION['userconfig']['ts'],
2,
''
);
$assert = true;
if (isset($_SESSION['cache']['server_2']['userprefs'])) {
$assert = false;
}
$this->assertTrue(
$assert
);
// case 2
$_SESSION['relation'][$GLOBALS['server']]['userconfigwork'] = 1;
$_SESSION['relation'][$GLOBALS['server']]['db'] = 'pmadb';
$_SESSION['relation'][$GLOBALS['server']]['userconfig'] = 'testconf';
$_SESSION['relation'][$GLOBALS['server']]['user'] = 'user';
$query1 = 'SELECT `username` FROM `pmadb`.`testconf` '
. 'WHERE `username` = \'user\'';
$query2 = 'UPDATE `pmadb`.`testconf` SET `timevalue` = NOW(), `config_data` = \''
. json_encode([1]) . '\' WHERE `username` = \'user\'';
$dbi = $this->getMockBuilder(DatabaseInterface::class)
->disableOriginalConstructor()
->getMock();
$dbi->expects($this->once())
->method('fetchValue')
->with($query1, 0, 0, DatabaseInterface::CONNECT_CONTROL)
->will($this->returnValue(true));
$dbi->expects($this->once())
->method('tryQuery')
->with($query2, DatabaseInterface::CONNECT_CONTROL)
->will($this->returnValue(true));
$dbi->expects($this->any())
->method('escapeString')
->will($this->returnArgument(0));
$GLOBALS['dbi'] = $dbi;
$result = $this->userPreferences->save([1]);
$this->assertTrue($result);
// case 3
$query1 = 'SELECT `username` FROM `pmadb`.`testconf` '
. 'WHERE `username` = \'user\'';
$query2 = 'INSERT INTO `pmadb`.`testconf` (`username`, `timevalue`,`config_data`) '
. 'VALUES (\'user\', NOW(), \'' . json_encode([1]) . '\')';
$dbi = $this->getMockBuilder(DatabaseInterface::class)
->disableOriginalConstructor()
->getMock();
$dbi->expects($this->once())
->method('fetchValue')
->with($query1, 0, 0, DatabaseInterface::CONNECT_CONTROL)
->will($this->returnValue(false));
$dbi->expects($this->once())
->method('tryQuery')
->with($query2, DatabaseInterface::CONNECT_CONTROL)
->will($this->returnValue(false));
$dbi->expects($this->once())
->method('getError')
->with(DatabaseInterface::CONNECT_CONTROL)
->will($this->returnValue('err1'));
$dbi->expects($this->any())
->method('escapeString')
->will($this->returnArgument(0));
$GLOBALS['dbi'] = $dbi;
$result = $this->userPreferences->save([1]);
$this->assertInstanceOf(Message::class, $result);
$this->assertEquals(
'Could not save configuration
err1',
$result->getMessage()
);
}
/**
* Test for apply
*/
public function testApply(): void
{
$GLOBALS['cfg']['UserprefsDisallow'] = [
'test' => 'val',
'foo' => 'bar',
];
$GLOBALS['cfg']['UserprefsDeveloperTab'] = null;
$result = $this->userPreferences->apply(
[
'DBG/sql' => true,
'ErrorHandler/display' => true,
'ErrorHandler/gather' => false,
'Servers/foobar' => '123',
'Server/hide_db' => true,
]
);
$this->assertEquals(
[
'Server' => ['hide_db' => 1],
],
$result
);
}
/**
* Test for apply
*/
public function testApplyDevel(): void
{
$GLOBALS['cfg']['UserprefsDeveloperTab'] = true;
$result = $this->userPreferences->apply(
['DBG/sql' => true]
);
$this->assertEquals(
[
'DBG' => ['sql' => true],
],
$result
);
}
/**
* Test for persistOption
*/
public function testPersistOption(): void
{
$_SESSION['relation'][$GLOBALS['server']]['version'] = Version::VERSION;
$_SESSION['relation'][$GLOBALS['server']]['userconfigwork'] = null;
$_SESSION['userconfig'] = [];
$_SESSION['userconfig']['ts'] = '123';
$_SESSION['userconfig']['db'] = [
'Server/hide_db' => true,
'Server/only_db' => true,
];
$GLOBALS['server'] = 2;
$_SESSION['relation'][2]['userconfigwork'] = null;
$this->assertTrue(
$this->userPreferences->persistOption('Server/hide_db', 'val', 'val')
);
$this->assertTrue(
$this->userPreferences->persistOption('Server/hide_db', 'val2', 'val')
);
$this->assertTrue(
$this->userPreferences->persistOption('Server/hide_db2', 'val', 'val')
);
}
/**
* Test for redirect
*/
public function testRedirect(): void
{
$GLOBALS['lang'] = '';
$GLOBALS['db'] = 'db';
$GLOBALS['table'] = 'table';
$this->mockResponse('Location: /phpmyadmin/file.html?a=b&saved=1&server=0#h+ash');
$GLOBALS['config']->set('PmaAbsoluteUri', '');
$GLOBALS['config']->set('PMA_IS_IIS', false);
$this->userPreferences->redirect(
'file.html',
['a' => 'b'],
'h ash'
);
}
/**
* Test for autoloadGetHeader
*/
public function testAutoloadGetHeader(): void
{
$_SESSION['userprefs_autoload'] = false;
$_REQUEST['prefs_autoload'] = 'hide';
$this->assertEquals(
'',
$this->userPreferences->autoloadGetHeader()
);
$this->assertTrue(
$_SESSION['userprefs_autoload']
);
$_REQUEST['prefs_autoload'] = 'nohide';
$GLOBALS['cfg']['ServerDefault'] = 1;
$GLOBALS['PMA_PHP_SELF'] = 'index.php';
$result = $this->userPreferences->autoloadGetHeader();
$this->assertStringContainsString(
'