92 lines
3.3 KiB
PHP
92 lines
3.3 KiB
PHP
<?php
|
|
|
|
declare(strict_types=1);
|
|
|
|
namespace PhpMyAdmin\Tests\Bookmarks;
|
|
|
|
use PhpMyAdmin\Bookmarks\Bookmark;
|
|
use PhpMyAdmin\Bookmarks\BookmarkRepository;
|
|
use PhpMyAdmin\Config;
|
|
use PhpMyAdmin\ConfigStorage\Relation;
|
|
use PhpMyAdmin\ConfigStorage\RelationParameters;
|
|
use PhpMyAdmin\Tests\AbstractTestCase;
|
|
use PHPUnit\Framework\Attributes\CoversClass;
|
|
use ReflectionProperty;
|
|
|
|
#[CoversClass(Bookmark::class)]
|
|
class BookmarkTest extends AbstractTestCase
|
|
{
|
|
/**
|
|
* Sets up the fixture, for example, opens a network connection.
|
|
* This method is called before a test is executed.
|
|
*/
|
|
protected function setUp(): void
|
|
{
|
|
parent::setUp();
|
|
|
|
$relationParameters = RelationParameters::fromArray([
|
|
RelationParameters::BOOKMARK_WORK => true,
|
|
RelationParameters::DATABASE => 'phpmyadmin',
|
|
RelationParameters::BOOKMARK => 'pma_bookmark',
|
|
]);
|
|
(new ReflectionProperty(Relation::class, 'cache'))->setValue(null, $relationParameters);
|
|
}
|
|
|
|
/**
|
|
* Tests for BookmarkRepository::getList()
|
|
*/
|
|
public function testGetList(): void
|
|
{
|
|
$dbiDummy = $this->createDbiDummy();
|
|
$dbiDummy->addResult(
|
|
'SELECT * FROM `phpmyadmin`.`pma_bookmark` WHERE (`user` = \'root\' OR `user` = \'\')'
|
|
. ' AND dbase = \'sakila\' ORDER BY label ASC',
|
|
[['1', 'sakila', 'root', 'label', 'SELECT * FROM `actor` WHERE `actor_id` < 10;']],
|
|
['id', 'dbase', 'user', 'label', 'query'],
|
|
);
|
|
$config = new Config();
|
|
$dbi = $this->createDatabaseInterface($dbiDummy, $config);
|
|
$bookmarkRepository = new BookmarkRepository($dbi, new Relation($dbi, $config), $config);
|
|
$actual = $bookmarkRepository->getList($config->selectedServer['user'], 'sakila');
|
|
self::assertContainsOnlyInstancesOf(Bookmark::class, $actual);
|
|
$dbiDummy->assertAllSelectsConsumed();
|
|
}
|
|
|
|
/**
|
|
* Tests for BookmarkRepository::get()
|
|
*/
|
|
public function testGet(): void
|
|
{
|
|
$dbiDummy = $this->createDbiDummy();
|
|
$dbiDummy->addResult(
|
|
"SELECT * FROM `phpmyadmin`.`pma_bookmark` WHERE `id` = 1 AND (user = 'root' OR user = '') LIMIT 1",
|
|
[],
|
|
['id', 'dbase', 'user', 'label', 'query'],
|
|
);
|
|
$config = new Config();
|
|
$dbi = $this->createDatabaseInterface($dbiDummy, $config);
|
|
$bookmarkRepository = new BookmarkRepository($dbi, new Relation($dbi, $config), $config);
|
|
self::assertNull($bookmarkRepository->get($config->selectedServer['user'], 1));
|
|
}
|
|
|
|
/**
|
|
* Tests for Bookmark::save()
|
|
*/
|
|
public function testSave(): void
|
|
{
|
|
$dbiDummy = $this->createDbiDummy();
|
|
$dbiDummy->addResult(
|
|
'INSERT INTO `phpmyadmin`.`pma_bookmark` (id, dbase, user, query, label)' .
|
|
" VALUES (NULL, 'phpmyadmin', 'root', 'SELECT \\\"phpmyadmin\\\"', 'bookmark1')",
|
|
true,
|
|
);
|
|
$config = new Config();
|
|
$dbi = $this->createDatabaseInterface($dbiDummy, $config);
|
|
$relation = new Relation($dbi, $config);
|
|
$bookmarkRepository = new BookmarkRepository($dbi, $relation, $config);
|
|
$bookmark = $bookmarkRepository->createBookmark('SELECT "phpmyadmin"', 'bookmark1', 'root', 'phpmyadmin');
|
|
self::assertNotFalse($bookmark);
|
|
self::assertTrue($bookmark->save());
|
|
}
|
|
}
|
