mysql_plugin_authpdo_test::test_pgsql() - Code Metrics - Inspection of "test postgres on travis" - splitbrain/dokuwiki - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — authpdo ( 0476c5...3b7a97 )

by Andreas

created 2016-03-11 14:20 UTC

mysql_plugin_authpdo_test::test_pgsql() B

↳ Parent: mysql_plugin_authpdo_test

Complexity

Conditions	4
Paths	5

Size

Total Lines	32
Code Lines	21

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	1

Metric	Value
c	1
b	0
f	1
dl	0
loc	32
rs	8.5806
cc	4
eloc	21
nc	5
nop	0

<?php

/**
 * mysql tests for the authpdo plugin
 *
 * @group plugin_authpdo
 * @group plugins
 */
class mysql_plugin_authpdo_test extends DokuWikiTest {

    protected $driver = 'mysql';
    protected $host = '';
    protected $database = 'authpdo_testing';
    protected $user = '';
    protected $pass = '';
    protected $port = '';

    public function setUp() {
        parent::setUp();
        $configuration = DOKU_UNITTEST . "{$this->driver}.conf.php";
        if(!file_exists($configuration)) {
            return;
        }
        /** @var $conf array */
        include $configuration;
        $this->host = $conf['host'];

        $this->user = $conf['user'];
        $this->pass = $conf['pass'];
        $this->port = $conf['port'];
    }

    /**
     * try to remove the last set up database
     *
     * it might still be there if something went wrong
     */
    public function tearDown() {
        parent::tearDown();
        $this->dropDatabase();
    }

    /**
     * Check if database credentials and extensions exist
     */
    public function test_requirements() {
        if(!$this->host || !$this->user) {
            $this->markTestSkipped("Skipped {$this->driver} tests. Missing configuration");
        }
        if(!class_exists('PDO')) {
            $this->markTestSkipped("Skipped {$this->driver} tests. Missing PDO extension");
        }
        if(!in_array($this->driver, pdo_drivers())) {
            $this->markTestSkipped("Skipped {$this->driver} tests. Missing pdo_{$this->driver} extension");
        }
    }

    /**
     * create the database for testing
     */
    protected function createDatabase() {
        $pdo = new PDO(
            "{$this->driver}:host={$this->host};port={$this->port}", $this->user, $this->pass,
            array(
                PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, // we want exceptions, not error codes
            )
        );
        $pdo->exec("DROP DATABASE IF EXISTS {$this->database}");
        $pdo->exec("CREATE DATABASE {$this->database}");
        $pdo = null;
$myVar = 'Value';
$higher = false;

if (rand(1, 6) > 3) {
    $higher = true;
} else {
    $higher = false;
}
    }

    /**
     * remove the database
     */
    protected function dropDatabase() {
        $pdo = new PDO(
            "{$this->driver}:host={$this->host};port={$this->port}", $this->user, $this->pass,
            array(
                PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, // we want exceptions, not error codes
            )
        );
        try {
            $pdo->exec("DROP DATABASE IF EXISTS {$this->database}");
        } catch (PDOException $e) {
            // ignore - sometimes this fails even though the database was deleted
        }
        $pdo = null;
$myVar = 'Value';
$higher = false;

if (rand(1, 6) > 3) {
    $higher = true;
} else {
    $higher = false;
}
    }

    /**
     * imports a database dump
     *
     * @param $file
     */
    protected function importDatabase($file) {
        // connect to database and import dump
        $pdo = null;
$myVar = 'Value';
$higher = false;

if (rand(1, 6) > 3) {
    $higher = true;
} else {
    $higher = false;
}
        $pdo = new PDO(
            "{$this->driver}:dbname={$this->database};host={$this->host};port={$this->port}", $this->user, $this->pass,
            array(
                PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, // we want exceptions, not error codes
            )
        );
        $sql = file_get_contents($file);
        $pdo->exec($sql);
        $pdo = null;
$myVar = 'Value';
$higher = false;

if (rand(1, 6) > 3) {
    $higher = true;
} else {
    $higher = false;
}
    }

    /**
     * Run general tests on all users
     *
     * @param auth_plugin_authpdo $auth
     * @param array $users
     */
    protected function runGeneralTests(auth_plugin_authpdo $auth, $users) {
        global $conf;
        $info = 'DSN: ' . $auth->getConf('dsn');
        $this->assertTrue($auth->success, $info);

        if($auth->canDo('getUsers')) {
            $list = $auth->retrieveUsers();
            $this->assertGreaterThanOrEqual(count($users), count($list), $info);
        }

        if($auth->canDo('getGroups')) {
            $list = $auth->retrieveGroups();
            $this->assertGreaterThanOrEqual(1, $list, $info);
        }

        if($auth->canDo('getUserCount')) {
            $count = $auth->getUserCount();
            $this->assertGreaterThanOrEqual(count($users), $count);
        }

        if($auth->canDo('addUser')) {
            $newuser = array(
                'user' => 'newuserfoobar',
                'name' => 'First LastFoobar',
                'pass' => 'password',
                'mail' => '[email protected]',
                'grps' => array('acompletelynewgroup')
            );
            $ok = $auth->createUser(
                $newuser['user'],
                $newuser['pass'],
                $newuser['name'],
                $newuser['mail'],
                $newuser['grps']
            );
            $this->assertTrue($ok, $info);
            $check = $auth->getUserData($newuser['user']);
            $this->assertEquals($newuser['user'], $check['user'], $info);
            $this->assertEquals($newuser['mail'], $check['mail'], $info);
            $groups = array_merge($newuser['grps'], array($conf['defaultgroup']));
            $this->assertEquals($groups, $check['grps'], $info);
        }
    }

    /**
     * run all the tests with the given user, depending on the capabilities
     *
     * @param auth_plugin_authpdo $auth
     * @param $user
     */
    protected function runUserTests(auth_plugin_authpdo $auth, $user) {
        global $conf;
        $info = 'DSN: ' . $auth->getConf('dsn') . ' User:' . $user['user'];

        // minimal setup
        $this->assertTrue($auth->checkPass($user['user'], $user['pass']), $info);
        $check = $auth->getUserData($user['user']);
        $this->assertEquals($user['user'], $check['user'], $info);
        $this->assertEquals($user['name'], $check['name'], $info);
        $this->assertEquals($user['mail'], $check['mail'], $info);
        $groups = array_merge($user['grps'], array($conf['defaultgroup']));
        $this->assertEquals($groups, $check['grps'], $info);

        // getUsers
        if($auth->canDo('getUsers')) {
            $list = $auth->retrieveUsers(0, -1, array('user' => $user['user']));
            $this->assertGreaterThanOrEqual(1, count($list));
            $list = $auth->retrieveUsers(0, -1, array('name' => $user['name']));
            $this->assertGreaterThanOrEqual(1, count($list));
            $list = $auth->retrieveUsers(0, -1, array('mail' => $user['mail']));
            $this->assertGreaterThanOrEqual(1, count($list));
        }

        // getUserCount
        if($auth->canDo('getUserCount')) {
            $count = $auth->getUserCount(array('user' => $user['user']));
            $this->assertGreaterThanOrEqual(1, $count);
            $count = $auth->getUserCount(array('name' => $user['name']));
            $this->assertGreaterThanOrEqual(1, $count);
            $count = $auth->getUserCount(array('mail' => $user['mail']));
            $this->assertGreaterThanOrEqual(1, $count);
        }

        // modGroups
        if($auth->canDo('modGroups')) {
            $newgroup = 'foobar';
            $ok = $auth->modifyUser($user['user'], array('grps' => array($newgroup)));
            $this->assertTrue($ok, $info);
            $check = $auth->getUserData($user['user']);
            $this->assertTrue(in_array($newgroup, $check['grps']), $info);
        }

        // modPass
        if($auth->canDo('modPass')) {
            $newpass = 'foobar';
            $ok = $auth->modifyUser($user['user'], array('pass' => $newpass));
            $this->assertTrue($ok, $info);
            $this->assertTrue($auth->checkPass($user['user'], $newpass), $info);
        }

        // modMail
        if($auth->canDo('modMail')) {
            $newmail = '[email protected]';
            $ok = $auth->modifyUser($user['user'], array('mail' => $newmail));
            $this->assertTrue($ok, $info);
            $check = $auth->getUserData($user['user']);
            $this->assertEquals($newmail, $check['mail'], $info);
        }

        // modName
        if($auth->canDo('modName')) {
            $newname = 'FirstName Foobar';
            $ok = $auth->modifyUser($user['user'], array('name' => $newname));
            $this->assertTrue($ok, $info);
            $check = $auth->getUserData($user['user']);
            $this->assertEquals($newname, $check['name'], $info);
        }

        // modLogin
        if($auth->canDo('modLogin')) {
            $newuser = 'foobar' . $user['user'];
            $ok = $auth->modifyUser($user['user'], array('user' => $newuser));
            $this->assertTrue($ok, $info);
            $check = $auth->getUserData($newuser);
            $this->assertEquals($newuser, $check['user'], $info);
            // rename back
            $ok = $auth->modifyUser($newuser, array('user' => $user['user']));
            $this->assertTrue($ok, $info);
        }

        // delUser
        if($auth->canDo('delUser')) {
            $num = $auth->deleteUsers(array($user['user']));
            $this->assertEquals(1, $num, $info);
            $this->assertFalse($auth->getUserData($user['user']), $info);
        }
    }

    /**
     * This triggers all the tests based on the dumps and configurations
     *
     * @depends test_requirements
     */
    public function test_pgsql() {
        global $conf;

        $files = glob(__DIR__ . "/{$this->driver}/*.php");
        foreach($files as $file) {
            $dump = preg_replace('/\.php$/', '.sql', $file);
            $this->database = 'authpdo_testing_' . basename($file, '.php');

            $this->createDatabase();
            $this->importDatabase($dump);

            // Setup the configuration and initialize a new auth object
            /** @var $data array */
            include $file;

            $conf['plugin']['authpdo'] = array();
            $conf['plugin']['authpdo'] = $data['conf'];

            $conf['plugin']['authpdo']['dsn'] = "{$this->driver}:dbname={$this->database};host={$this->host};port={$this->port}";
            $conf['plugin']['authpdo']['user'] = $this->user;
            $conf['plugin']['authpdo']['pass'] = $this->pass;
            $conf['plugin']['authpdo']['debug'] = 1;
            if($data['passcrypt']) $conf['passcrypt'] = $data['passcrypt'];
            $auth = new auth_plugin_authpdo();

            $this->runGeneralTests($auth, $data['users']);
            foreach($data['users'] as $user) {
                $this->runUserTests($auth, $user);
            }

            $this->dropDatabase();
        }
    }

}


1			<?php
2
3			/**
4			* mysql tests for the authpdo plugin
5			*
6			* @group plugin_authpdo
7			* @group plugins
8			*/
9			class mysql_plugin_authpdo_test extends DokuWikiTest {
10
11			protected $driver = 'mysql';
12			protected $host = '';
13			protected $database = 'authpdo_testing';
14			protected $user = '';
15			protected $pass = '';
16			protected $port = '';
17
18			public function setUp() {
19			parent::setUp();
20			$configuration = DOKU_UNITTEST . "{$this->driver}.conf.php";
21			if(!file_exists($configuration)) {
22			return;
23			}
24			/** @var $conf array */
25			include $configuration;
26			$this->host = $conf['host'];
			0 ignored issues – show Bug introduced 2016-02-12 15:43 UTC by Report Bug Copy Issue Report The variable `$conf` does not exist. Did you forget to declare it? This check marks access to variables or properties that have not been declared yet. While PHP has no explicit notion of declaring a variable, accessing it before a value is assigned to it is most likely a bug. Loading history...
27			$this->user = $conf['user'];
28			$this->pass = $conf['pass'];
29			$this->port = $conf['port'];
30			}
31
32			/**
33			* try to remove the last set up database
34			*
35			* it might still be there if something went wrong
36			*/
37			public function tearDown() {
38			parent::tearDown();
39			$this->dropDatabase();
40			}
41
42			/**
43			* Check if database credentials and extensions exist
44			*/
45			public function test_requirements() {
46			if(!$this->host \|\| !$this->user) {
47			$this->markTestSkipped("Skipped {$this->driver} tests. Missing configuration");
48			}
49			if(!class_exists('PDO')) {
50			$this->markTestSkipped("Skipped {$this->driver} tests. Missing PDO extension");
51			}
52			if(!in_array($this->driver, pdo_drivers())) {
53			$this->markTestSkipped("Skipped {$this->driver} tests. Missing pdo_{$this->driver} extension");
54			}
55			}
56
57			/**
58			* create the database for testing
59			*/
60			protected function createDatabase() {
61			$pdo = new PDO(
62			"{$this->driver}:host={$this->host};port={$this->port}", $this->user, $this->pass,
63			array(
64			PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, // we want exceptions, not error codes
65			)
66			);
67			$pdo->exec("DROP DATABASE IF EXISTS {$this->database}");
68			$pdo->exec("CREATE DATABASE {$this->database}");
69			$pdo = null;
			0 ignored issues – show Unused Code introduced 2016-02-12 15:43 UTC by Report Bug Copy Issue Report `$pdo` is not used, you could remove the assignment. This check looks for variable assignements that are either overwritten by other assignments or where the variable is not used subsequently. $myVar = 'Value'; $higher = false; if (rand(1, 6) > 3) { $higher = true; } else { $higher = false; } Both the `$myVar` assignment in line 1 and the `$higher` assignment in line 2 are dead. The first because `$myVar` is never used and the second because `$higher` is always overwritten for every possible time line. Loading history...
70			}
71
72			/**
73			* remove the database
74			*/
75			protected function dropDatabase() {
76			$pdo = new PDO(
77			"{$this->driver}:host={$this->host};port={$this->port}", $this->user, $this->pass,
78			array(
79			PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, // we want exceptions, not error codes
80			)
81			);
82			try {
83			$pdo->exec("DROP DATABASE IF EXISTS {$this->database}");
84			} catch (PDOException $e) {
85			// ignore - sometimes this fails even though the database was deleted
86			}
87			$pdo = null;
			0 ignored issues – show Unused Code introduced 2016-02-12 15:43 UTC by Report Bug Copy Issue Report `$pdo` is not used, you could remove the assignment. This check looks for variable assignements that are either overwritten by other assignments or where the variable is not used subsequently. $myVar = 'Value'; $higher = false; if (rand(1, 6) > 3) { $higher = true; } else { $higher = false; } Both the `$myVar` assignment in line 1 and the `$higher` assignment in line 2 are dead. The first because `$myVar` is never used and the second because `$higher` is always overwritten for every possible time line. Loading history...
88			}
89
90			/**
91			* imports a database dump
92			*
93			* @param $file
94			*/
95			protected function importDatabase($file) {
96			// connect to database and import dump
97			$pdo = null;
			0 ignored issues – show Unused Code introduced 2016-02-12 15:43 UTC by Report Bug Copy Issue Report `$pdo` is not used, you could remove the assignment. This check looks for variable assignements that are either overwritten by other assignments or where the variable is not used subsequently. $myVar = 'Value'; $higher = false; if (rand(1, 6) > 3) { $higher = true; } else { $higher = false; } Both the `$myVar` assignment in line 1 and the `$higher` assignment in line 2 are dead. The first because `$myVar` is never used and the second because `$higher` is always overwritten for every possible time line. Loading history...
98			$pdo = new PDO(
99			"{$this->driver}:dbname={$this->database};host={$this->host};port={$this->port}", $this->user, $this->pass,
100			array(
101			PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, // we want exceptions, not error codes
102			)
103			);
104			$sql = file_get_contents($file);
105			$pdo->exec($sql);
106			$pdo = null;
			0 ignored issues – show Unused Code introduced 2016-02-12 15:43 UTC by Report Bug Copy Issue Report `$pdo` is not used, you could remove the assignment. This check looks for variable assignements that are either overwritten by other assignments or where the variable is not used subsequently. $myVar = 'Value'; $higher = false; if (rand(1, 6) > 3) { $higher = true; } else { $higher = false; } Both the `$myVar` assignment in line 1 and the `$higher` assignment in line 2 are dead. The first because `$myVar` is never used and the second because `$higher` is always overwritten for every possible time line. Loading history...
107			}
108
109			/**
110			* Run general tests on all users
111			*
112			* @param auth_plugin_authpdo $auth
113			* @param array $users
114			*/
115			protected function runGeneralTests(auth_plugin_authpdo $auth, $users) {
116			global $conf;
117			$info = 'DSN: ' . $auth->getConf('dsn');
118			$this->assertTrue($auth->success, $info);
119
120			if($auth->canDo('getUsers')) {
121			$list = $auth->retrieveUsers();
122			$this->assertGreaterThanOrEqual(count($users), count($list), $info);
123			}
124
125			if($auth->canDo('getGroups')) {
126			$list = $auth->retrieveGroups();
127			$this->assertGreaterThanOrEqual(1, $list, $info);
128			}
129
130			if($auth->canDo('getUserCount')) {
131			$count = $auth->getUserCount();
132			$this->assertGreaterThanOrEqual(count($users), $count);
133			}
134
135			if($auth->canDo('addUser')) {
136			$newuser = array(
137			'user' => 'newuserfoobar',
138			'name' => 'First LastFoobar',
139			'pass' => 'password',
140			'mail' => '[email protected]',
141			'grps' => array('acompletelynewgroup')
142			);
143			$ok = $auth->createUser(
144			$newuser['user'],
145			$newuser['pass'],
146			$newuser['name'],
147			$newuser['mail'],
148			$newuser['grps']
149			);
150			$this->assertTrue($ok, $info);
151			$check = $auth->getUserData($newuser['user']);
152			$this->assertEquals($newuser['user'], $check['user'], $info);
153			$this->assertEquals($newuser['mail'], $check['mail'], $info);
154			$groups = array_merge($newuser['grps'], array($conf['defaultgroup']));
155			$this->assertEquals($groups, $check['grps'], $info);
156			}
157			}
158
159			/**
160			* run all the tests with the given user, depending on the capabilities
161			*
162			* @param auth_plugin_authpdo $auth
163			* @param $user
164			*/
165			protected function runUserTests(auth_plugin_authpdo $auth, $user) {
166			global $conf;
167			$info = 'DSN: ' . $auth->getConf('dsn') . ' User:' . $user['user'];
168
169			// minimal setup
170			$this->assertTrue($auth->checkPass($user['user'], $user['pass']), $info);
171			$check = $auth->getUserData($user['user']);
172			$this->assertEquals($user['user'], $check['user'], $info);
173			$this->assertEquals($user['name'], $check['name'], $info);
174			$this->assertEquals($user['mail'], $check['mail'], $info);
175			$groups = array_merge($user['grps'], array($conf['defaultgroup']));
176			$this->assertEquals($groups, $check['grps'], $info);
177
178			// getUsers
179			if($auth->canDo('getUsers')) {
180			$list = $auth->retrieveUsers(0, -1, array('user' => $user['user']));
181			$this->assertGreaterThanOrEqual(1, count($list));
182			$list = $auth->retrieveUsers(0, -1, array('name' => $user['name']));
183			$this->assertGreaterThanOrEqual(1, count($list));
184			$list = $auth->retrieveUsers(0, -1, array('mail' => $user['mail']));
185			$this->assertGreaterThanOrEqual(1, count($list));
186			}
187
188			// getUserCount
189			if($auth->canDo('getUserCount')) {
190			$count = $auth->getUserCount(array('user' => $user['user']));
191			$this->assertGreaterThanOrEqual(1, $count);
192			$count = $auth->getUserCount(array('name' => $user['name']));
193			$this->assertGreaterThanOrEqual(1, $count);
194			$count = $auth->getUserCount(array('mail' => $user['mail']));
195			$this->assertGreaterThanOrEqual(1, $count);
196			}
197
198			// modGroups
199			if($auth->canDo('modGroups')) {
200			$newgroup = 'foobar';
201			$ok = $auth->modifyUser($user['user'], array('grps' => array($newgroup)));
202			$this->assertTrue($ok, $info);
203			$check = $auth->getUserData($user['user']);
204			$this->assertTrue(in_array($newgroup, $check['grps']), $info);
205			}
206
207			// modPass
208			if($auth->canDo('modPass')) {
209			$newpass = 'foobar';
210			$ok = $auth->modifyUser($user['user'], array('pass' => $newpass));
211			$this->assertTrue($ok, $info);
212			$this->assertTrue($auth->checkPass($user['user'], $newpass), $info);
213			}
214
215			// modMail
216			if($auth->canDo('modMail')) {
217			$newmail = '[email protected]';
218			$ok = $auth->modifyUser($user['user'], array('mail' => $newmail));
219			$this->assertTrue($ok, $info);
220			$check = $auth->getUserData($user['user']);
221			$this->assertEquals($newmail, $check['mail'], $info);
222			}
223
224			// modName
225			if($auth->canDo('modName')) {
226			$newname = 'FirstName Foobar';
227			$ok = $auth->modifyUser($user['user'], array('name' => $newname));
228			$this->assertTrue($ok, $info);
229			$check = $auth->getUserData($user['user']);
230			$this->assertEquals($newname, $check['name'], $info);
231			}
232
233			// modLogin
234			if($auth->canDo('modLogin')) {
235			$newuser = 'foobar' . $user['user'];
236			$ok = $auth->modifyUser($user['user'], array('user' => $newuser));
237			$this->assertTrue($ok, $info);
238			$check = $auth->getUserData($newuser);
239			$this->assertEquals($newuser, $check['user'], $info);
240			// rename back
241			$ok = $auth->modifyUser($newuser, array('user' => $user['user']));
242			$this->assertTrue($ok, $info);
243			}
244
245			// delUser
246			if($auth->canDo('delUser')) {
247			$num = $auth->deleteUsers(array($user['user']));
248			$this->assertEquals(1, $num, $info);
249			$this->assertFalse($auth->getUserData($user['user']), $info);
250			}
251			}
252
253			/**
254			* This triggers all the tests based on the dumps and configurations
255			*
256			* @depends test_requirements
257			*/
258			public function test_pgsql() {
259			global $conf;
260
261			$files = glob(__DIR__ . "/{$this->driver}/*.php");
262			foreach($files as $file) {
263			$dump = preg_replace('/\.php$/', '.sql', $file);
264			$this->database = 'authpdo_testing_' . basename($file, '.php');
265
266			$this->createDatabase();
267			$this->importDatabase($dump);
268
269			// Setup the configuration and initialize a new auth object
270			/** @var $data array */
271			include $file;
272
273			$conf['plugin']['authpdo'] = array();
274			$conf['plugin']['authpdo'] = $data['conf'];
			0 ignored issues – show Bug introduced 2016-02-12 15:43 UTC by Report Bug Copy Issue Report The variable `$data` does not exist. Did you forget to declare it? This check marks access to variables or properties that have not been declared yet. While PHP has no explicit notion of declaring a variable, accessing it before a value is assigned to it is most likely a bug. Loading history...
275			$conf['plugin']['authpdo']['dsn'] = "{$this->driver}:dbname={$this->database};host={$this->host};port={$this->port}";
276			$conf['plugin']['authpdo']['user'] = $this->user;
277			$conf['plugin']['authpdo']['pass'] = $this->pass;
278			$conf['plugin']['authpdo']['debug'] = 1;
279			if($data['passcrypt']) $conf['passcrypt'] = $data['passcrypt'];
280			$auth = new auth_plugin_authpdo();
281
282			$this->runGeneralTests($auth, $data['users']);
283			foreach($data['users'] as $user) {
284			$this->runUserTests($auth, $user);
285			}
286
287			$this->dropDatabase();
288			}
289			}
290
291			}
292

splitbrain / dokuwiki

Push — authpdo ( 0476c5...3b7a97 )

mysql_plugin_authpdo_test::test_pgsql() B

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like