. */ namespace SP\Tests\Services\Import; use Defuse\Crypto\Exception\CryptoException; use DI\Container; use DI\DependencyException; use DI\NotFoundException; use SP\Core\Context\ContextException; use SP\Core\Crypt\Crypt; use SP\Core\Exceptions\ConstraintException; use SP\Core\Exceptions\QueryException; use SP\Core\Exceptions\SPException; use SP\DataModel\AccountSearchVData; use SP\Repositories\NoSuchItemException; use SP\Services\Account\AccountSearchFilter; use SP\Services\Account\AccountService; use SP\Services\Category\CategoryService; use SP\Services\Client\ClientService; use SP\Services\Import\FileImport; use SP\Services\Import\ImportException; use SP\Services\Import\ImportParams; use SP\Services\Import\KeepassImport; use SP\Services\Import\XmlFileImport; use SP\Storage\File\FileException; use SP\Tests\DatabaseTestCase; use function SP\Tests\setupContext; /** * Class KeepassImportTest * * @package SP\Tests\Services\Import */ class KeepassImportTest extends DatabaseTestCase { /** * @var Container */ protected static $dic; /** * @throws ContextException */ public static function setUpBeforeClass(): void { self::$dic = setupContext(); self::$loadFixtures = true; } /** * @throws ImportException * @throws DependencyException * @throws NotFoundException * @throws CryptoException * @throws ConstraintException * @throws QueryException * @throws SPException * @throws NoSuchItemException * @throws FileException */ public function testDoImport() { $file = RESOURCE_PATH . DIRECTORY_SEPARATOR . 'import' . DIRECTORY_SEPARATOR . 'data_keepass.xml'; $params = new ImportParams(); $params->setDefaultUser(1); $params->setDefaultGroup(2); $import = new KeepassImport(self::$dic, new XmlFileImport(FileImport::fromFilesystem($file)), $params); $import->doImport(); $this->checkImportedData(); } /** * @throws DependencyException * @throws NotFoundException * @throws CryptoException * @throws ConstraintException * @throws QueryException * @throws NoSuchItemException * @throws SPException */ private function checkImportedData() { // Checkout categories $categoryService = self::$dic->get(CategoryService::class); $this->assertEquals('Linux', $categoryService->getByName('Linux')->getName()); $this->assertEquals('Windows', $categoryService->getByName('Windows')->getName()); $this->assertEquals('Servers', $categoryService->getByName('Servers')->getName()); $this->assertEquals('General', $categoryService->getByName('General')->getName()); $this->assertEquals(11, self::getRowCount('Category')); // Checkout clients $client = self::$dic->get(ClientService::class)->getByName('KeePass'); $this->assertEquals('KeePass', $client->getName()); $this->assertEquals(5, self::getRowCount('Client')); // Checkout accounts $accountService = self::$dic->get(AccountService::class); // 1st account $filter = new AccountSearchFilter(); $filter->setClientId($client->getId()); /** @var AccountSearchVData[] $data */ $data = $accountService->getByFilter($filter)->getDataAsArray(); $this->assertCount(5, $data); $this->assertEquals(5, $data[0]->getId()); $this->assertEquals(1, $data[0]->getUserId()); $this->assertEquals(2, $data[0]->getUserGroupId()); $this->assertEquals('DC1', $data[0]->getName()); $this->assertEquals('KeePass', $data[0]->getClientName()); $this->assertEquals('Windows', $data[0]->getCategoryName()); $this->assertEquals('192.168.100.1', $data[0]->getUrl()); $this->assertEquals('ADS server', $data[0]->getNotes()); $this->assertEquals('administrator', $data[0]->getLogin()); $pass = $accountService->getPasswordForId($data[0]->getId()); $this->assertEquals('k6V4iIAeR9SBOprLMUGV', Crypt::decrypt($pass->getPass(), $pass->getKey(), '12345678900')); // 2nd account $this->assertEquals(6, $data[1]->getId()); $this->assertEquals(1, $data[1]->getUserId()); $this->assertEquals(2, $data[1]->getUserGroupId()); $this->assertEquals('debian', $data[1]->getName()); $this->assertEquals('KeePass', $data[1]->getClientName()); $this->assertEquals('Linux', $data[1]->getCategoryName()); $this->assertEquals('http://debian.org', $data[1]->getUrl()); $this->assertEquals("Some notes about the server", $data[1]->getNotes()); $this->assertEquals('root', $data[1]->getLogin()); $pass = $accountService->getPasswordForId($data[1]->getId()); $this->assertEquals('TKr321zqCZhgbzmmAX13', Crypt::decrypt($pass->getPass(), $pass->getKey(), '12345678900')); // 3rd account $this->assertEquals(7, $data[2]->getId()); $this->assertEquals(1, $data[2]->getUserId()); $this->assertEquals(2, $data[2]->getUserGroupId()); $this->assertEquals('proxy', $data[2]->getName()); $this->assertEquals('KeePass', $data[2]->getClientName()); $this->assertEquals('Linux', $data[2]->getCategoryName()); $this->assertEquals('192.168.0.1', $data[2]->getUrl()); $this->assertEquals('Some notes about proxy server', $data[2]->getNotes()); $this->assertEquals('admin', $data[2]->getLogin()); $pass = $accountService->getPasswordForId($data[2]->getId()); $this->assertEquals('TKr321zqCZhgbzmmAX13', Crypt::decrypt($pass->getPass(), $pass->getKey(), '12345678900')); $this->assertEquals(8, $data[3]->getId()); $this->assertEquals(1, $data[3]->getUserId()); $this->assertEquals(2, $data[3]->getUserGroupId()); $this->assertEquals('Sample Entry', $data[3]->getName()); $this->assertEquals('NewDatabase', $data[3]->getCategoryName()); $this->assertEquals(9, $data[4]->getId()); $this->assertEquals(1, $data[4]->getUserId()); $this->assertEquals(2, $data[4]->getUserGroupId()); $this->assertEquals('Sample Entry #2', $data[4]->getName()); $this->assertEquals('NewDatabase', $data[4]->getCategoryName()); $this->assertEquals(9, self::getRowCount('Account')); } }