Annotation of embedaddon/php/ext/mysqli/tests/mysqli_set_local_infile_default.phpt, revision 1.1.1.1
1.1 misho 1: --TEST--
2: mysqli_set_local_infile_default()
3: --SKIPIF--
4: <?php
5: require_once('skipif.inc');
6: require_once('skipifemb.inc');
7: require_once('skipifconnectfailure.inc');
8:
9: if (!function_exists('mysqli_set_local_infile_handler'))
10: die("skip - function not available.");
11:
12: $link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket);
13: if (!$link)
14: die(sprintf("skip Can't connect [%d] %s", mysqli_connect_errno(), mysqli_connect_error()));
15:
16: include_once("local_infile_tools.inc");
17: if ($msg = check_local_infile_support($link, $engine))
18: die(sprintf("skip %s, [%d] %s", $msg, $link->errno, $link->error));
19:
20: mysqli_close($link);
21: ?>
22: --INI--
23: mysqli.allow_local_infile=1
24: --FILE--
25: <?php
26: require_once('connect.inc');
27: require_once('local_infile_tools.inc');
28:
29: $link = $tmp = null;
30: if (!is_null($tmp = @mysqli_set_local_infile_default()))
31: printf("[001] Expecting NULL got %s/%s\n", gettype($tmp), $tmp);
32:
33: if (!is_null($tmp = @mysqli_set_local_infile_default($link)))
34: printf("[002] Expecting NULL got %s/%s\n", gettype($tmp), $tmp);
35:
36: $link = new mysqli();
37: if (!is_null($tmp = @mysqli_set_local_infile_default($link)))
38: printf("[002a] Expecting NULL got %s/%s\n", gettype($tmp), $tmp);
39:
40: include("table.inc");
41:
42: if (!is_null($tmp = @mysqli_set_local_infile_default($link, 'foo')))
43: printf("[003] Expecting NULL got %s/%s\n", gettype($tmp), $tmp);
44:
45:
46: function callback_simple($fp, &$buffer, $buflen, &$error) {
47: static $invocation = 0;
48:
49: printf("Callback: %d\n", $invocation);
50:
51: $invocation++;
52: if (!is_resource($fp))
53: printf("[012] First argument passed to callback is not a resource but %s/%s\n",
54: $fp, gettype($fp));
55:
56: if (!$buffer = fread($fp, $buflen)) {
57: if ($invocation == 1) {
58: printf("[013] Cannot read from stream\n");
59: $error = 'Cannot read from stream';
60: } else {
61: return strlen($buffer);
62: }
63: }
64:
65: $lines = explode("\n", $buffer);
66: if (count($lines) != 4 && strlen($buffer) > 0) {
67: printf("[014] Test is too simple to handle a buffer of size %d that cannot hold all lines\n", $buflen);
68: $error = 'Parser too simple';
69: }
70:
71: $buffer = '';
72: foreach ($lines as $k => $line) {
73: if ('' === trim($line))
74: continue;
75:
76: $columns = explode(';', $line);
77: if (empty($columns)) {
78: printf("[015] Cannot parse columns\n");
79: $error = 'Cannot parse columns';
80: }
81:
82: // increase id column value
83: $columns[0] += 1;
84: $buffer .= implode(';', $columns);
85: $buffer .= "\n";
86: }
87:
88: return strlen($buffer);
89: }
90:
91: $file = create_standard_csv(4);
92: $expected = array(
93: array('id' => 98, 'label' => 'x'),
94: array('id' => 99, 'label' => 'y'),
95: array('id' => 100, 'label' => 'z'),
96: );
97: try_handler(10, $link, $file, 'callback_simple', $expected);
98:
99: $expected = array(
100: array('id' => 97, 'label' => 'x'),
101: array('id' => 98, 'label' => 'y'),
102: array('id' => 99, 'label' => 'z'),
103: );
104: try_handler(20, $link, $file, 'default', $expected);
105:
106: $expected = array(
107: array('id' => 98, 'label' => 'x'),
108: array('id' => 99, 'label' => 'y'),
109: array('id' => 100, 'label' => 'z'),
110: );
111: try_handler(30, $link, $file, 'callback_simple', $expected);
112:
113: mysqli_close($link);
114:
115: if (!is_null($tmp = @mysqli_set_local_infile_default($link)))
116: printf("[300] Expecting NULL/NULL got %s/%s\n", $tmp, gettype($tmp));
117:
118: print "done!";
119: ?>
120: --CLEAN--
121: <?php
122: require_once("clean_table.inc");
123: ?>
124: --EXPECTF--
125: Callback set to 'callback_simple'
126: Callback: 0
127: Callback: 1
128: Callback set to 'default'
129: Callback set to 'callback_simple'
130: Callback: 2
131: Callback: 3
132: done!
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>