123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510 |
- <?php
- namespace Test;
- use OC\SystemConfig;
- use OCP\IDBConnection;
- class AllConfigTest extends \Test\TestCase {
-
- protected $connection;
- protected function getConfig($systemConfig = null, $connection = null) {
- if ($this->connection === null) {
- $this->connection = \OC::$server->getDatabaseConnection();
- }
- if ($connection === null) {
- $connection = $this->connection;
- }
- if ($systemConfig === null) {
- $systemConfig = $this->getMockBuilder('\OC\SystemConfig')
- ->disableOriginalConstructor()
- ->getMock();
- }
- return new \OC\AllConfig($systemConfig, $connection);
- }
- public function testDeleteUserValue(): void {
- $config = $this->getConfig();
-
- $this->connection->executeUpdate(
- 'INSERT INTO `*PREFIX*preferences` (`userid`, `appid`, ' .
- '`configkey`, `configvalue`) VALUES (?, ?, ?, ?)',
- ['userDelete', 'appDelete', 'keyDelete', 'valueDelete']
- );
- $config->deleteUserValue('userDelete', 'appDelete', 'keyDelete');
- $result = $this->connection->executeQuery(
- 'SELECT COUNT(*) AS `count` FROM `*PREFIX*preferences` WHERE `userid` = ?',
- ['userDelete']
- )->fetch();
- $actualCount = $result['count'];
- $this->assertEquals(0, $actualCount, 'There was one value in the database and after the tests there should be no entry left.');
- }
- public function testSetUserValue(): void {
- $selectAllSQL = 'SELECT `userid`, `appid`, `configkey`, `configvalue` FROM `*PREFIX*preferences` WHERE `userid` = ?';
- $config = $this->getConfig();
- $config->setUserValue('userSet', 'appSet', 'keySet', 'valueSet');
- $result = $this->connection->executeQuery($selectAllSQL, ['userSet'])->fetchAll();
- $this->assertEquals(1, count($result));
- $this->assertEquals([
- 'userid' => 'userSet',
- 'appid' => 'appSet',
- 'configkey' => 'keySet',
- 'configvalue' => 'valueSet'
- ], $result[0]);
-
- $config->setUserValue('userSet', 'appSet', 'keySet', 'valueSet2');
- $result = $this->connection->executeQuery($selectAllSQL, ['userSet'])->fetchAll();
- $this->assertEquals(1, count($result));
- $this->assertEquals([
- 'userid' => 'userSet',
- 'appid' => 'appSet',
- 'configkey' => 'keySet',
- 'configvalue' => 'valueSet2'
- ], $result[0]);
-
- $config->deleteUserValue('userSet', 'appSet', 'keySet');
- }
- public function testSetUserValueWithPreCondition(): void {
- $config = $this->getConfig();
- $selectAllSQL = 'SELECT `userid`, `appid`, `configkey`, `configvalue` FROM `*PREFIX*preferences` WHERE `userid` = ?';
- $config->setUserValue('userPreCond', 'appPreCond', 'keyPreCond', 'valuePreCond');
- $result = $this->connection->executeQuery($selectAllSQL, ['userPreCond'])->fetchAll();
- $this->assertEquals(1, count($result));
- $this->assertEquals([
- 'userid' => 'userPreCond',
- 'appid' => 'appPreCond',
- 'configkey' => 'keyPreCond',
- 'configvalue' => 'valuePreCond'
- ], $result[0]);
-
- $config->setUserValue('userPreCond', 'appPreCond', 'keyPreCond', 'valuePreCond2', 'valuePreCond');
- $result = $this->connection->executeQuery($selectAllSQL, ['userPreCond'])->fetchAll();
- $this->assertEquals(1, count($result));
- $this->assertEquals([
- 'userid' => 'userPreCond',
- 'appid' => 'appPreCond',
- 'configkey' => 'keyPreCond',
- 'configvalue' => 'valuePreCond2'
- ], $result[0]);
-
- $config->deleteUserValue('userPreCond', 'appPreCond', 'keyPreCond');
- }
- public function dataSetUserValueUnexpectedValue() {
- return [
- [true],
- [false],
- [null],
- [new \stdClass()],
- ];
- }
-
- public function testSetUserValueUnexpectedValue($value): void {
- $this->expectException(\UnexpectedValueException::class);
- $config = $this->getConfig();
- $config->setUserValue('userSetBool', 'appSetBool', 'keySetBool', $value);
- }
- public function testSetUserValueWithPreConditionFailure(): void {
- $this->expectException(\OCP\PreConditionNotMetException::class);
- $config = $this->getConfig();
- $selectAllSQL = 'SELECT `userid`, `appid`, `configkey`, `configvalue` FROM `*PREFIX*preferences` WHERE `userid` = ?';
- $config->setUserValue('userPreCond1', 'appPreCond', 'keyPreCond', 'valuePreCond');
- $result = $this->connection->executeQuery($selectAllSQL, ['userPreCond1'])->fetchAll();
- $this->assertEquals(1, count($result));
- $this->assertEquals([
- 'userid' => 'userPreCond1',
- 'appid' => 'appPreCond',
- 'configkey' => 'keyPreCond',
- 'configvalue' => 'valuePreCond'
- ], $result[0]);
-
- $config->setUserValue('userPreCond1', 'appPreCond', 'keyPreCond', 'valuePreCond2', 'valuePreCond3');
- $result = $this->connection->executeQuery($selectAllSQL, ['userPreCond1'])->fetchAll();
- $this->assertEquals(1, count($result));
- $this->assertEquals([
- 'userid' => 'userPreCond1',
- 'appid' => 'appPreCond',
- 'configkey' => 'keyPreCond',
- 'configvalue' => 'valuePreCond'
- ], $result[0]);
-
- $config->deleteUserValue('userPreCond1', 'appPreCond', 'keyPreCond');
- }
- public function testSetUserValueWithPreConditionFailureWhenResultStillMatches(): void {
- $this->expectException(\OCP\PreConditionNotMetException::class);
- $config = $this->getConfig();
- $selectAllSQL = 'SELECT `userid`, `appid`, `configkey`, `configvalue` FROM `*PREFIX*preferences` WHERE `userid` = ?';
- $config->setUserValue('userPreCond1', 'appPreCond', 'keyPreCond', 'valuePreCond');
- $result = $this->connection->executeQuery($selectAllSQL, ['userPreCond1'])->fetchAll();
- $this->assertCount(1, $result);
- $this->assertEquals([
- 'userid' => 'userPreCond1',
- 'appid' => 'appPreCond',
- 'configkey' => 'keyPreCond',
- 'configvalue' => 'valuePreCond'
- ], $result[0]);
-
- $config->setUserValue('userPreCond1', 'appPreCond', 'keyPreCond', 'valuePreCond', 'valuePreCond3');
- $result = $this->connection->executeQuery($selectAllSQL, ['userPreCond1'])->fetchAll();
- $this->assertCount(1, $result);
- $this->assertEquals([
- 'userid' => 'userPreCond1',
- 'appid' => 'appPreCond',
- 'configkey' => 'keyPreCond',
- 'configvalue' => 'valuePreCond'
- ], $result[0]);
-
- $config->deleteUserValue('userPreCond1', 'appPreCond', 'keyPreCond');
- }
- public function testSetUserValueUnchanged(): void {
-
- $this->markTestSkipped('Skipped because this is just testable if database connection can be injected');
- $resultMock = $this->getMockBuilder('\Doctrine\DBAL\Driver\Statement')
- ->disableOriginalConstructor()->getMock();
- $resultMock->expects($this->once())
- ->method('fetchColumn')
- ->willReturn('valueSetUnchanged');
- $connectionMock = $this->createMock(IDBConnection::class);
- $connectionMock->expects($this->once())
- ->method('executeQuery')
- ->with($this->equalTo('SELECT `configvalue` FROM `*PREFIX*preferences` ' .
- 'WHERE `userid` = ? AND `appid` = ? AND `configkey` = ?'),
- $this->equalTo(['userSetUnchanged', 'appSetUnchanged', 'keySetUnchanged']))
- ->willReturn($resultMock);
- $connectionMock->expects($this->never())
- ->method('executeUpdate');
- $config = $this->getConfig(null, $connectionMock);
- $config->setUserValue('userSetUnchanged', 'appSetUnchanged', 'keySetUnchanged', 'valueSetUnchanged');
- }
- public function testGetUserValue(): void {
- $config = $this->getConfig();
-
- $config->setUserValue('userGet', 'appGet', 'keyGet', 'valueGet');
- $value = $config->getUserValue('userGet', 'appGet', 'keyGet');
- $this->assertEquals('valueGet', $value);
- $result = $this->connection->executeQuery(
- 'SELECT `userid`, `appid`, `configkey`, `configvalue` FROM `*PREFIX*preferences` WHERE `userid` = ?',
- ['userGet']
- )->fetchAll();
- $this->assertEquals(1, count($result));
- $this->assertEquals([
- 'userid' => 'userGet',
- 'appid' => 'appGet',
- 'configkey' => 'keyGet',
- 'configvalue' => 'valueGet'
- ], $result[0]);
-
- $this->connection->executeUpdate('DELETE FROM `*PREFIX*preferences` WHERE `userid` = ?', ['userGet']);
-
- $value = $config->getUserValue('userGet', 'appGet', 'keyGet');
- $this->assertEquals('valueGet', $value);
- $result = $this->connection->executeQuery(
- 'SELECT `userid`, `appid`, `configkey`, `configvalue` FROM `*PREFIX*preferences` WHERE `userid` = ?',
- ['userGet']
- )->fetchAll();
- $this->assertEquals(0, count($result));
- }
- public function testGetUserKeys(): void {
- $config = $this->getConfig();
-
- $data = [
- ['userFetch', 'appFetch1', 'keyFetch1', 'value1'],
- ['userFetch', 'appFetch1', 'keyFetch2', 'value2'],
- ['userFetch', 'appFetch2', 'keyFetch3', 'value3'],
- ['userFetch', 'appFetch1', 'keyFetch4', 'value4'],
- ['userFetch', 'appFetch4', 'keyFetch1', 'value5'],
- ['userFetch', 'appFetch5', 'keyFetch1', 'value6'],
- ['userFetch2', 'appFetch', 'keyFetch1', 'value7']
- ];
- foreach ($data as $entry) {
- $this->connection->executeUpdate(
- 'INSERT INTO `*PREFIX*preferences` (`userid`, `appid`, ' .
- '`configkey`, `configvalue`) VALUES (?, ?, ?, ?)',
- $entry
- );
- }
- $value = $config->getUserKeys('userFetch', 'appFetch1');
- $this->assertEquals(['keyFetch1', 'keyFetch2', 'keyFetch4'], $value);
- $value = $config->getUserKeys('userFetch2', 'appFetch');
- $this->assertEquals(['keyFetch1'], $value);
-
- $this->connection->executeUpdate('DELETE FROM `*PREFIX*preferences`');
- }
- public function testGetUserKeysAllInts(): void {
- $config = $this->getConfig();
-
- $data = [
- ['userFetch8', 'appFetch1', '123', 'value'],
- ['userFetch8', 'appFetch1', '456', 'value'],
- ];
- foreach ($data as $entry) {
- $this->connection->executeUpdate(
- 'INSERT INTO `*PREFIX*preferences` (`userid`, `appid`, ' .
- '`configkey`, `configvalue`) VALUES (?, ?, ?, ?)',
- $entry
- );
- }
- $value = $config->getUserKeys('userFetch8', 'appFetch1');
- $this->assertEquals(['123', '456'], $value);
- $this->assertIsString($value[0]);
- $this->assertIsString($value[1]);
-
- $this->connection->executeUpdate('DELETE FROM `*PREFIX*preferences`');
- }
- public function testGetUserValueDefault(): void {
- $config = $this->getConfig();
- $this->assertEquals('', $config->getUserValue('userGetUnset', 'appGetUnset', 'keyGetUnset'));
- $this->assertEquals(null, $config->getUserValue('userGetUnset', 'appGetUnset', 'keyGetUnset', null));
- $this->assertEquals('foobar', $config->getUserValue('userGetUnset', 'appGetUnset', 'keyGetUnset', 'foobar'));
- }
- public function testGetUserValueForUsers(): void {
- $config = $this->getConfig();
-
- $data = [
- ['userFetch1', 'appFetch2', 'keyFetch1', 'value1'],
- ['userFetch2', 'appFetch2', 'keyFetch1', 'value2'],
- ['userFetch3', 'appFetch2', 'keyFetch1', 3],
- ['userFetch4', 'appFetch2', 'keyFetch1', 'value4'],
- ['userFetch5', 'appFetch2', 'keyFetch1', 'value5'],
- ['userFetch6', 'appFetch2', 'keyFetch1', 'value6'],
- ['userFetch7', 'appFetch2', 'keyFetch1', 'value7']
- ];
- foreach ($data as $entry) {
- $this->connection->executeUpdate(
- 'INSERT INTO `*PREFIX*preferences` (`userid`, `appid`, ' .
- '`configkey`, `configvalue`) VALUES (?, ?, ?, ?)',
- $entry
- );
- }
- $value = $config->getUserValueForUsers('appFetch2', 'keyFetch1',
- ['userFetch1', 'userFetch2', 'userFetch3', 'userFetch5']);
- $this->assertEquals([
- 'userFetch1' => 'value1',
- 'userFetch2' => 'value2',
- 'userFetch3' => 3,
- 'userFetch5' => 'value5'
- ], $value);
- $value = $config->getUserValueForUsers('appFetch2', 'keyFetch1',
- ['userFetch1', 'userFetch4', 'userFetch9']);
- $this->assertEquals([
- 'userFetch1' => 'value1',
- 'userFetch4' => 'value4'
- ], $value, 'userFetch9 is an non-existent user and should not be shown.');
-
- $this->connection->executeUpdate('DELETE FROM `*PREFIX*preferences`');
- }
- public function testDeleteAllUserValues(): void {
- $config = $this->getConfig();
-
- $data = [
- ['userFetch3', 'appFetch1', 'keyFetch1', 'value1'],
- ['userFetch3', 'appFetch1', 'keyFetch2', 'value2'],
- ['userFetch3', 'appFetch2', 'keyFetch3', 'value3'],
- ['userFetch3', 'appFetch1', 'keyFetch4', 'value4'],
- ['userFetch3', 'appFetch4', 'keyFetch1', 'value5'],
- ['userFetch3', 'appFetch5', 'keyFetch1', 'value6'],
- ['userFetch4', 'appFetch2', 'keyFetch1', 'value7']
- ];
- foreach ($data as $entry) {
- $this->connection->executeUpdate(
- 'INSERT INTO `*PREFIX*preferences` (`userid`, `appid`, ' .
- '`configkey`, `configvalue`) VALUES (?, ?, ?, ?)',
- $entry
- );
- }
- $config->deleteAllUserValues('userFetch3');
- $result = $this->connection->executeQuery(
- 'SELECT COUNT(*) AS `count` FROM `*PREFIX*preferences`'
- )->fetch();
- $actualCount = $result['count'];
- $this->assertEquals(1, $actualCount, 'After removing `userFetch3` there should be exactly 1 entry left.');
-
- $this->connection->executeUpdate('DELETE FROM `*PREFIX*preferences`');
- }
- public function testDeleteAppFromAllUsers(): void {
- $config = $this->getConfig();
-
- $data = [
- ['userFetch5', 'appFetch1', 'keyFetch1', 'value1'],
- ['userFetch5', 'appFetch1', 'keyFetch2', 'value2'],
- ['userFetch5', 'appFetch2', 'keyFetch3', 'value3'],
- ['userFetch5', 'appFetch1', 'keyFetch4', 'value4'],
- ['userFetch5', 'appFetch4', 'keyFetch1', 'value5'],
- ['userFetch5', 'appFetch5', 'keyFetch1', 'value6'],
- ['userFetch6', 'appFetch2', 'keyFetch1', 'value7']
- ];
- foreach ($data as $entry) {
- $this->connection->executeUpdate(
- 'INSERT INTO `*PREFIX*preferences` (`userid`, `appid`, ' .
- '`configkey`, `configvalue`) VALUES (?, ?, ?, ?)',
- $entry
- );
- }
- $config->deleteAppFromAllUsers('appFetch1');
- $result = $this->connection->executeQuery(
- 'SELECT COUNT(*) AS `count` FROM `*PREFIX*preferences`'
- )->fetch();
- $actualCount = $result['count'];
- $this->assertEquals(4, $actualCount, 'After removing `appFetch1` there should be exactly 4 entries left.');
- $config->deleteAppFromAllUsers('appFetch2');
- $result = $this->connection->executeQuery(
- 'SELECT COUNT(*) AS `count` FROM `*PREFIX*preferences`'
- )->fetch();
- $actualCount = $result['count'];
- $this->assertEquals(2, $actualCount, 'After removing `appFetch2` there should be exactly 2 entries left.');
-
- $this->connection->executeUpdate('DELETE FROM `*PREFIX*preferences`');
- }
- public function testGetUsersForUserValue(): void {
-
- $systemConfig = $this->getMockBuilder('\OC\SystemConfig')
- ->disableOriginalConstructor()
- ->getMock();
- $config = $this->getConfig($systemConfig);
-
- $data = [
- ['user1', 'appFetch9', 'keyFetch9', 'value9'],
- ['user2', 'appFetch9', 'keyFetch9', 'value9'],
- ['user3', 'appFetch9', 'keyFetch9', 'value8'],
- ['user4', 'appFetch9', 'keyFetch8', 'value9'],
- ['user5', 'appFetch8', 'keyFetch9', 'value9'],
- ['user6', 'appFetch9', 'keyFetch9', 'value9'],
- ];
- foreach ($data as $entry) {
- $this->connection->executeUpdate(
- 'INSERT INTO `*PREFIX*preferences` (`userid`, `appid`, ' .
- '`configkey`, `configvalue`) VALUES (?, ?, ?, ?)',
- $entry
- );
- }
- $value = $config->getUsersForUserValue('appFetch9', 'keyFetch9', 'value9');
- $this->assertEquals(['user1', 'user2', 'user6'], $value);
-
- $this->connection->executeUpdate('DELETE FROM `*PREFIX*preferences`');
- }
- public function testGetUsersForUserValueCaseInsensitive(): void {
-
- $systemConfig = $this->createMock(SystemConfig::class);
- $config = $this->getConfig($systemConfig);
- $config->setUserValue('user1', 'myApp', 'myKey', 'test123');
- $config->setUserValue('user2', 'myApp', 'myKey', 'TEST123');
- $config->setUserValue('user3', 'myApp', 'myKey', 'test12345');
- $users = $config->getUsersForUserValueCaseInsensitive('myApp', 'myKey', 'test123');
- $this->assertSame(2, count($users));
- $this->assertSame(['user1', 'user2'], $users);
- }
- }
|