Return to mysqli_set_local_infile_handler_new_query.phpt CVS log

Up to [ELWIX - Embedded LightWeight unIX -] / embedaddon / php / ext / mysqli / tests

Annotation of embedaddon/php/ext/mysqli/tests/mysqli_set_local_infile_handler_new_query.phpt, revision 1.1.1.1

1.1       misho       1: --TEST--
                      2: mysqli_set_local_infile_handler() - run new query on db link
                      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: require_once('connect.inc');
                     13: if (!$TEST_EXPERIMENTAL)
                     14:        die("skip - experimental (= unsupported) feature");
                     15: 
                     16: if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket))
                     17:        die("skip Cannot connect to MySQL");
                     18: 
                     19: include_once("local_infile_tools.inc");
                     20: if ($msg = check_local_infile_support($link, $engine))
                     21:        die(sprintf("skip %s, [%d] %s", $msg, $link->errno, $link->error));
                     22: 
                     23: mysqli_close($link);
                     24: ?>
                     25: --INI--
                     26: mysqli.allow_local_infile=1
                     27: --FILE--
                     28: <?php
                     29:        require_once('connect.inc');
                     30:        require_once('local_infile_tools.inc');
                     31:        require_once('table.inc');
                     32: 
                     33:        function callback_new_query($fp, &$buffer, $buflen, &$error) {
                     34:                global $link;
                     35:                static $invocation = 0;
                     36: 
                     37:                printf("Callback: %d\n", $invocation++);
                     38:                flush();
                     39:                if (is_object($link)) {
                     40:                        if (!$res = mysqli_query($link, "SELECT id, label FROM test")) {
                     41:                                printf("[Callback 001 - %03d] Cannot run query, [%d] %s\n",
                     42:                                        $invocation, mysqli_errno($link), mysqli_error($link));
                     43:                        }
                     44:                        if ($res)
                     45:                                mysqli_free_result($res);
                     46:                        }
                     47:                        $buffer = "1;'a';\n";
                     48:                        if ($invocation > 10)
                     49:                                return 0;
                     50: 
                     51:                        mysqli_set_local_infile_default($link);
                     52:                        return strlen($buffer);
                     53:        }
                     54: 
                     55:        $file = create_standard_csv(1);
                     56:        $expected = array(array('id' => 1, 'label' => 'a'));
                     57:        try_handler(20, $link, $file, 'callback_new_query', $expected);
                     58: 
                     59:        mysqli_close($link);
                     60:        print "done!";
                     61: ?>
                     62: --CLEAN--
                     63: <?php
                     64:        require_once("clean_table.inc");
                     65: ?>
                     66: --EXPECTF--
                     67: Callback set to 'callback_new_query'
                     68: Callback: 0
                     69: [Callback 001 - 001] Cannot run query, [2014] Commands out of sync; you can't run this command now
                     70: [022] LOAD DATA failed, [2000] Can't execute load data local init callback function
                     71: done!