1--TEST--
2MySQL PDO->__construct(), options
3--SKIPIF--
4<?php
5require_once(__DIR__ . DIRECTORY_SEPARATOR . 'skipif.inc');
6require_once(__DIR__ . DIRECTORY_SEPARATOR . 'mysql_pdo_test.inc');
7MySQLPDOTest::skip();
8?>
9--FILE--
10<?php
11    require_once(__DIR__ . DIRECTORY_SEPARATOR . 'mysql_pdo_test.inc');
12
13    function set_option_and_check($offset, $option, $value, $option_desc) {
14
15        $dsn = MySQLPDOTest::getDSN();
16        $user = PDO_MYSQL_TEST_USER;
17        $pass = PDO_MYSQL_TEST_PASS;
18
19        try {
20            $db = new PDO($dsn, $user, $pass, array($option => $value));
21            $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_SILENT);
22            if (!is_object($db) || ($value !== ($tmp = @$db->getAttribute($option))))
23                printf("[%03d] Expecting '%s'/%s got '%s'/%s' for options '%s'\n",
24                    $offset,
25                    $value, gettype($value),
26                    $tmp, gettype($tmp),
27                    $option_desc);
28        } catch (PDOException $e) {
29            printf("[%03d] %s\n", $offset, $e->getMessage());
30        }
31
32    }
33
34    try {
35
36        $dsn = MySQLPDOTest::getDSN();
37        $user = PDO_MYSQL_TEST_USER;
38        $pass = PDO_MYSQL_TEST_PASS;
39
40        $valid_options = array(
41            /* pdo_dbh.c */
42            PDO::ATTR_PERSISTENT									=> 'PDO::ATTR_PERSISTENT',
43            PDO::ATTR_AUTOCOMMIT									=> 'PDO::ATTR_AUTOCOMMIT',
44            /* mysql_driver.c */
45            /* TODO Possible bug PDO::ATTR_TIMEOUT != MYSQLI_OPT_CONNECT_TIMEOUT*/
46            PDO::ATTR_TIMEOUT 										=> 'PDO::ATTR_TIMEOUT',
47            PDO::ATTR_EMULATE_PREPARES						=> 'PDO::ATTR_EMULATE_PREPARES',
48
49            PDO::MYSQL_ATTR_USE_BUFFERED_QUERY		=> 'PDO::MYSQL_ATTR_USE_BUFFERED_QUERY',
50            PDO::MYSQL_ATTR_LOCAL_INFILE					=> 'PDO::MYSQL_ATTR_LOCAL_INFILE',
51            PDO::MYSQL_ATTR_DIRECT_QUERY					=> 'PDO::MYSQL_ATTR_DIRECT_QUERY',
52
53            PDO::MYSQL_ATTR_INIT_COMMAND					=> 'PDO::MYSQL_ATTR_INIT_COMMAND',
54            PDO::ATTR_EMULATE_PREPARES						=> 'PDO::ATTR_EMULATE_PREPARES',
55        );
56
57        $defaults = array(
58            PDO::ATTR_PERSISTENT									=> false,
59            PDO::ATTR_AUTOCOMMIT									=> 1,
60            /* TODO - why is this a valid option if getAttribute() does not support it?! */
61            PDO::ATTR_TIMEOUT 										=> false,
62            PDO::ATTR_EMULATE_PREPARES						=> 1,
63            PDO::MYSQL_ATTR_USE_BUFFERED_QUERY		=> 1,
64            /* TODO getAttribute() does not handle it */
65            PDO::MYSQL_ATTR_LOCAL_INFILE					=> false,
66            /* TODO getAttribute() does not handle it */
67            PDO::MYSQL_ATTR_DIRECT_QUERY					=> 1,
68            PDO::MYSQL_ATTR_INIT_COMMAND					=> '',
69        );
70
71        try {
72            if (NULL !== ($db = @new PDO($dsn, $user, $pass, 'wrong type')))
73                printf("[001] Expecting NULL got %s/%s\n", gettype($db), $db);
74        } catch (TypeError $e) {
75        }
76
77        if (!is_object($db = new PDO($dsn, $user, $pass, array())))
78            printf("[002] Expecting object got %s/%s¸\n", gettype($db), $db);
79
80        $invalid = 999;
81        if (is_object($db = new PDO($dsn, $user, $pass, array($invalid => true))))
82            printf("[003] [TODO][CHANGEREQUEST] Please, lets not ignore invalid options and bail out!\n");
83
84        $db = new PDO($dsn, $user, $pass);
85        $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_SILENT);
86        foreach ($valid_options as $option => $name) {
87            /* TODO getAttribute() is pretty poor in supporting the options, suppress errors */
88            $tmp = @$db->getAttribute($option);
89            if ($tmp !== $defaults[$option])
90                printf("[003a] Expecting default value for '%s' of '%s'/%s, getAttribute() reports setting '%s'/%s\n",
91                    $name, $defaults[$option], gettype($defaults[$option]),
92                    $tmp, gettype($tmp));
93        }
94
95        $db = new PDO($dsn, $user, $pass, array(PDO::ATTR_AUTOCOMMIT => true));
96        if (!is_object($db) || !$db->getAttribute(PDO::ATTR_AUTOCOMMIT))
97            printf("[004] Autocommit should be on\n");
98
99        $db = new PDO($dsn, $user, $pass, array(PDO::ATTR_AUTOCOMMIT => false));
100        if (!is_object($db) || $db->getAttribute(PDO::ATTR_AUTOCOMMIT))
101            printf("[005] Autocommit should be off\n");
102
103        /* TODO: no way to check ATTR_TIMEOUT settings */
104        if (!is_object($db = new PDO($dsn, $user, $pass, array(PDO::ATTR_TIMEOUT => 10))))
105            printf("[006] ATTR_TIMEOUT should be accepted\n");
106
107        if (!is_object($db = new PDO($dsn, $user, $pass, array(PDO::ATTR_TIMEOUT => PHP_INT_MAX))))
108            printf("[007] ATTR_TIMEOUT should be accepted\n");
109
110        if (!is_object($db = new PDO($dsn, $user, $pass, array(PDO::ATTR_TIMEOUT => -PHP_INT_MAX))))
111            printf("[008] ATTR_TIMEOUT should be accepted\n");
112
113        /* TODO: Its ugly that PDO::ATTR_EMULATE_PREPARES == PDO::MYSQL_ATTR_DIRECT_QUERY */
114        $db = new PDO($dsn, $user, $pass, array(PDO::ATTR_EMULATE_PREPARES => true));
115        if (!is_object($db))
116            printf("[009] ATTR_EMULATE_PREPARES should be accepted and on\n");
117        if (!$db->getAttribute(PDO::ATTR_EMULATE_PREPARES))
118            printf("[010] [TODO][CHANGEREQUEST] ATTR_EMULATE_PREPARES should be on\n");
119        if (!$db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY))
120            printf("[011] As PDO::MYSQL_ATTR_DIRECT_QUERY == PDO::ATTR_EMULATE_PREPARES
121                and PDO::ATTR_EMULATE_PREPARES overrules the other, PDO::MYSQL_ATTR_DIRECT_QUERY should be on\n");
122
123        $db = new PDO($dsn, $user, $pass, array(PDO::ATTR_EMULATE_PREPARES => false));
124        if (!is_object($db))
125            printf("[012] ATTR_EMULATE_PREPARES should be accepted and on\n");
126        if ($db->getAttribute(PDO::ATTR_EMULATE_PREPARES))
127            printf("[013] [TODO][CHANGEREQUEST] ATTR_EMULATE_PREPARES should be off\n");
128        if ($db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY))
129            printf("[014] As PDO::MYSQL_ATTR_DIRECT_QUERY == PDO::ATTR_EMULATE_PREPARES
130                and PDO::ATTR_EMULATE_PREPARES overrules the other, PDO::MYSQL_ATTR_DIRECT_QUERY should be off\n");
131
132        // PDO::ATTR_EMULATE_PREPARES overrules PDO::MYSQL_ATTR_DIRECT_QUERY
133        // TODO: is it clever that a generic setting overrules a specific setting?
134        $db = new PDO($dsn, $user, $pass, array(PDO::ATTR_EMULATE_PREPARES => true, PDO::MYSQL_ATTR_DIRECT_QUERY => false));
135        if (!$db->getAttribute(PDO::ATTR_EMULATE_PREPARES))
136            printf("[015] PDO::ATTR_EMULATE_PREPARES should be on\n");
137        if (!$db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY))
138            printf("[016] PDO::MYSQL_ATTR_DIRECT_QUERY should be on\n");
139
140        $db = new PDO($dsn, $user, $pass, array(PDO::ATTR_EMULATE_PREPARES => false, PDO::MYSQL_ATTR_DIRECT_QUERY => true));
141        if ($db->getAttribute(PDO::ATTR_EMULATE_PREPARES))
142            printf("[017] PDO::ATTR_EMULATE_PREPARES should be off\n");
143        if ($db->getAttribute(PDO::MYSQL_ATTR_DIRECT_QUERY))
144            printf("[018] PDO::MYSQL_ATTR_DIRECT_QUERY should be off\n");
145
146        set_option_and_check(19, PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, 1, 'PDO::MYSQL_ATTR_USE_BUFFERED_QUERY');
147        set_option_and_check(20, PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, 0, 'PDO::MYSQL_ATTR_USE_BUFFERED_QUERY');
148
149        set_option_and_check(21, PDO::MYSQL_ATTR_LOCAL_INFILE, true, 'PDO::MYSQL_ATTR_LOCAL_INFILE');
150        set_option_and_check(22, PDO::MYSQL_ATTR_LOCAL_INFILE, false, 'PDO::MYSQL_ATTR_LOCAL_INFILE');
151
152        set_option_and_check(23, PDO::MYSQL_ATTR_INIT_COMMAND, 'SET @a=1', 'PDO::MYSQL_ATTR_INIT_COMMAND');
153        set_option_and_check(24, PDO::MYSQL_ATTR_INIT_COMMAND, '', 'PDO::MYSQL_ATTR_INIT_COMMAND');
154        set_option_and_check(25, PDO::MYSQL_ATTR_INIT_COMMAND, 'INSERT INTO nonexistent(invalid) VALUES (1)', 'PDO::MYSQL_ATTR_INIT_COMMAND');
155
156        set_option_and_check(33, PDO::MYSQL_ATTR_DIRECT_QUERY, 1, 'PDO::MYSQL_ATTR_DIRECT_QUERY');
157        set_option_and_check(34, PDO::MYSQL_ATTR_DIRECT_QUERY, 0, 'PDO::MYSQL_ATTR_DIRECT_QUERY');
158
159    } catch (PDOException $e) {
160        printf("[001] %s, [%s] %s Line: %s\n",
161            $e->getMessage(),
162            (is_object($db)) ? $db->errorCode() : 'n/a',
163            (is_object($db)) ? implode(' ', $db->errorInfo()) : 'n/a',
164            $e->getLine());
165    }
166
167    print "done!";
168?>
169--EXPECTF--
170[003] [TODO][CHANGEREQUEST] Please, lets not ignore invalid options and bail out!
171[003a] Expecting default value for 'PDO::MYSQL_ATTR_INIT_COMMAND' of ''/string, getAttribute() reports setting ''/boolean
172[015] PDO::ATTR_EMULATE_PREPARES should be on
173[016] PDO::MYSQL_ATTR_DIRECT_QUERY should be on
174[017] PDO::ATTR_EMULATE_PREPARES should be off
175[018] PDO::MYSQL_ATTR_DIRECT_QUERY should be off
176[023] Expecting 'SET @a=1'/string got ''/boolean' for options 'PDO::MYSQL_ATTR_INIT_COMMAND'
177[024] SQLSTATE[42000] [1065] Query was empty
178[025] SQLSTATE[42S02] [1146] Table '%s.nonexistent' doesn't exist
179done!
180