Annotation of embedaddon/php/ext/pdo/tests/pdo_032.phpt, revision 1.1.1.1
1.1 misho 1: --TEST--
2: PDO Common: PDO::ATTR_CASE
3: --SKIPIF--
4: <?php # vim:ft=php
5: if (!extension_loaded('pdo')) die('skip');
6: $dir = getenv('REDIR_TEST_DIR');
7: if (false == $dir) die('skip no driver');
8: require_once $dir . 'pdo_test.inc';
9: PDOTest::skip();
10: ?>
11: --FILE--
12: <?php
13: if (getenv('REDIR_TEST_DIR') === false) putenv('REDIR_TEST_DIR='.dirname(__FILE__) . '/../../pdo/tests/');
14: require_once getenv('REDIR_TEST_DIR') . 'pdo_test.inc';
15: $db = PDOTest::factory();
16:
17: $db->exec('CREATE TABLE test(id int NOT NULL PRIMARY KEY, val VARCHAR(10))');
18: $db->exec("INSERT INTO test VALUES(1, 'A')");
19: $db->exec("INSERT INTO test VALUES(2, 'B')");
20: $db->exec("INSERT INTO test VALUES(3, 'C')");
21:
22: // Lower case columns
23: $db->setAttribute(PDO::ATTR_CASE, PDO::CASE_LOWER);
24: $stmt = $db->prepare('SELECT * from test');
25: $stmt->execute();
26: var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
27: $stmt->closeCursor();
28:
29: // Upper case columns
30: $db->setAttribute(PDO::ATTR_CASE, PDO::CASE_UPPER);
31: $stmt = $db->prepare('SELECT * from test');
32: $stmt->execute();
33: var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
34: $stmt->closeCursor();
35:
36: ?>
37: --EXPECT--
38: array(3) {
39: [0]=>
40: array(2) {
41: ["id"]=>
42: string(1) "1"
43: ["val"]=>
44: string(1) "A"
45: }
46: [1]=>
47: array(2) {
48: ["id"]=>
49: string(1) "2"
50: ["val"]=>
51: string(1) "B"
52: }
53: [2]=>
54: array(2) {
55: ["id"]=>
56: string(1) "3"
57: ["val"]=>
58: string(1) "C"
59: }
60: }
61: array(3) {
62: [0]=>
63: array(2) {
64: ["ID"]=>
65: string(1) "1"
66: ["VAL"]=>
67: string(1) "A"
68: }
69: [1]=>
70: array(2) {
71: ["ID"]=>
72: string(1) "2"
73: ["VAL"]=>
74: string(1) "B"
75: }
76: [2]=>
77: array(2) {
78: ["ID"]=>
79: string(1) "3"
80: ["VAL"]=>
81: string(1) "C"
82: }
83: }
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>