summaryrefslogtreecommitdiff
path: root/ext/pdo/tests/pdo_test.inc
blob: 2498d43f58025ad9ad169d77b70868b32dbdeb90 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
<?php
# PDO test framework utilities

class PDOTest {
	// create an instance of the PDO driver, based on
	// the current environment
	static function factory($classname = 'PDO') {
		$dsn = getenv('PDOTEST_DSN');
		$user = getenv('PDOTEST_USER');
		$pass = getenv('PDOTEST_PASS');
		$attr = getenv('PDOTEST_ATTR');
		if (is_string($attr) && strlen($attr)) {
			$attr = unserialize($attr);
		} else {
			$attr = null;
		}

		if ($user === false) $user = NULL;
		if ($pass === false) $pass = NULL;
		
		$db = new $classname($dsn, $user, $pass, $attr);

		// clean up any crufty test tables we might have left behind
		// on a previous run
		static $test_tables = array(
			'test',
			'classtypes'
			);
		foreach ($test_tables as $table) {
			$db->exec("DROP TABLE $table");
		}
		
		$db->setAttribute(PDO_ATTR_ERRMODE, PDO_ERRMODE_WARNING);
		$db->setAttribute(PDO_ATTR_CASE, PDO_CASE_LOWER);
		$db->setAttribute(PDO_ATTR_STRINGIFY_FETCHES, true);
		return $db;
	}

	static function skip() {
		try {
			$db = PDOTest::factory();
		} catch (PDOException $e) {
			die("skip " . $e->getMessage());
		}
	}

	static function detect_transactional_mysql_engine($db) {
		foreach ($db->query('show engines') as $row) {
			if ($row[1] == 'YES' && ($row[0] == 'INNOBASE' || $row[0] == 'BDB')) {
				return $row[0];
			}
		}
		return false;
	}

	static function test_factory($file) {
		$data = file_get_contents($file);
		$data = preg_replace('/^.*--REDIRECTTEST--/s', '', $data);
		$config = eval($data);
		foreach ($config['ENV'] as $k => $v) {
			putenv("$k=$v");
		}
		return self::factory();
	}
}



?>