Lines Matching +full:- +full:m
34 … $this->markTestSkipped('skipping all authpdo tests for sqlite. Need PDO_sqlite extension');
36 $this->assertTrue(true); // avoid being marked as risky for having no assertion
41 $this->dbfile = tempnam('/tmp/', 'pluginpdo_test_');
42 copy(__DIR__ . '/test.sqlite3', $this->dbfile);
47 $conf['plugin']['authpdo']['dsn'] = 'sqlite:' . $this->dbfile;
51 …$conf['plugin']['authpdo']['select-user'] = 'SELECT id AS uid, login AS user, name, pass AS clear,…
52 …$conf['plugin']['authpdo']['select-user-groups'] = 'SELECT * FROM member AS m, "group" AS g WHERE…
53 $conf['plugin']['authpdo']['select-groups'] = 'SELECT id AS gid, "group" FROM "group"';
55 …$conf['plugin']['authpdo']['insert-user'] = 'INSERT INTO user (login, pass, name, mail) VALUES (:u…
56 $conf['plugin']['authpdo']['delete-user'] = 'DELETE FROM user WHERE id = :uid';
58 $conf['plugin']['authpdo']['list-users'] = 'SELECT DISTINCT login as user
59 FROM user U, member M, "group" G
60 WHERE U.id = M.uid
61 AND M.gid = G.id
69 $conf['plugin']['authpdo']['count-users'] = 'SELECT COUNT(DISTINCT login) as count
70 FROM user U, member M, "group" G
71 WHERE U.id = M.uid
72 AND M.gid = G.id
79 …$conf['plugin']['authpdo']['update-user-login'] = 'UPDATE user SET login = :newlogin WHERE id = :u…
80 …$conf['plugin']['authpdo']['update-user-info'] = 'UPDATE user SET name = :name, mail = :mail WHERE…
81 … $conf['plugin']['authpdo']['update-user-pass'] = 'UPDATE user SET pass = :hash WHERE id = :uid';
83 … $conf['plugin']['authpdo']['insert-group'] = 'INSERT INTO "group" ("group") VALUES (:group)';
84 … $conf['plugin']['authpdo']['join-group'] = 'INSERT INTO member (uid, gid) VALUES (:uid, :gid)';
85 … $conf['plugin']['authpdo']['leave-group'] = 'DELETE FROM member WHERE uid = :uid AND gid = :gid';
90 unlink($this->dbfile);
99 $groups = $auth->selectGroups();
100 $this->assertArrayHasKey('user', $groups);
101 $this->assertEquals(1, $groups['user']['gid']);
102 $this->assertArrayHasKey('admin', $groups);
103 $this->assertEquals(2, $groups['admin']['gid']);
105 $ok = $auth->addGroup('test');
106 $this->assertTrue($ok);
107 $groups = $auth->selectGroups();
108 $this->assertArrayHasKey('test', $groups);
109 $this->assertEquals(4, $groups['test']['gid']);
120 $this->assertFalse($auth->checkPass('nobody', 'nope'));
121 $this->assertFalse($auth->checkPass('admin', 'nope'));
122 $this->assertTrue($auth->checkPass('admin', 'password'));
125 …$conf['plugin']['authpdo']['select-user'] = 'SELECT id AS uid, login AS user, name, pass AS hash, …
126 $this->assertFalse($auth->checkPass('admin', 'password'));
127 $this->assertFalse($auth->checkPass('user', md5('password')));
130 $info = $auth->getUserData('admin');
131 $this->assertEquals('admin', $info['user']);
132 $this->assertEquals('The Admin', $info['name']);
133 $this->assertEquals('admin@example.com', $info['mail']);
134 $this->assertEquals(array('additional', 'admin', 'user'), $info['grps']);
137 $this->assertEquals(array('additional', 'admin', 'user'), $auth->retrieveGroups());
138 $this->assertEquals(array('admin', 'user'), $auth->retrieveGroups(1));
139 $this->assertEquals(array('additional'), $auth->retrieveGroups(0, 1));
142 $auth->createUser('test', 'password', 'A Test user', 'test@example.com', array('newgroup'));
143 $info = $auth->getUserData('test');
144 $this->assertEquals('test', $info['user']);
145 $this->assertEquals('A Test user', $info['name']);
146 $this->assertEquals('test@example.com', $info['mail']);
147 $this->assertEquals(array('newgroup', 'user'), $info['grps']);
148 … $this->assertEquals(array('additional', 'admin', 'newgroup', 'user'), $auth->retrieveGroups());
151 …$auth->modifyUser('test', array('user' => 'tester', 'name' => 'The Test User', 'pass' => 'secret')…
152 $info = $auth->getUserData('tester');
153 $this->assertEquals('tester', $info['user']);
154 $this->assertEquals('The Test User', $info['name']);
155 $this->assertTrue($auth->checkPass('tester','secret'));
158 $auth->modifyUser('tester', array('grps' => array('user', 'admin', 'another')));
159 $info = $auth->getUserData('tester');
160 $this->assertEquals(array('admin', 'another', 'user'), $info['grps']);
188 $users = $auth->retrieveUsers();
189 $this->assertEquals(array($expect['admin'], $expect['tester'], $expect['user']), $users);
191 $users = $auth->retrieveUsers(1); // offset
192 $this->assertEquals(array($expect['tester'], $expect['user']), $users);
194 $users = $auth->retrieveUsers(1, 1); // offset + limit
195 $this->assertEquals(array($expect['tester']), $users);
197 $users = $auth->retrieveUsers(0, -1, array('group' => 'admin')); // full group
198 $this->assertEquals(array($expect['admin'], $expect['tester']), $users);
199 $count = $auth->getUserCount(array('grps' => 'admin'));
200 $this->assertSame(2, $count);
202 $users = $auth->retrieveUsers(0, -1, array('group' => 'dmi')); // substring
203 $this->assertEquals(array($expect['admin'], $expect['tester']), $users);
204 $count = $auth->getUserCount(array('grps' => 'dmi'));
205 $this->assertSame(2, $count);
207 $users = $auth->retrieveUsers(0, -1, array('user' => 'dmi')); // substring
208 $this->assertEquals(array($expect['admin']), $users);
209 $count = $auth->getUserCount(array('user' => 'dmi'));
210 $this->assertSame(1, $count);
213 $num = $auth->deleteUsers(array('tester', 'foobar'));
214 $this->assertSame(1, $num);