MySQL Lists are EOL. Please join:

List:Commits« Previous MessageNext Message »
From:uwendel Date:June 22 2007 12:19pm
Subject:PHP mysqlnd svn commit: r449 - trunk/tests/ext/mysqli
View as plain text  
Author: uwendel
Date: 2007-06-22 14:19:38 +0200 (Fri, 22 Jun 2007)
New Revision: 449

Added:
   trunk/tests/ext/mysqli/mysqli_set_local_infile_handler_replace_buffer.phpt
Log:
Another endless loop, although the file pointer gets advanced.



Added: trunk/tests/ext/mysqli/mysqli_set_local_infile_handler_replace_buffer.phpt
===================================================================
--- trunk/tests/ext/mysqli/mysqli_set_local_infile_handler_replace_buffer.phpt	2007-06-22
12:09:55 UTC (rev 448)
+++ trunk/tests/ext/mysqli/mysqli_set_local_infile_handler_replace_buffer.phpt	2007-06-22
12:19:38 UTC (rev 449)
@@ -0,0 +1,111 @@
+--TEST--
+mysqli_set_local_infile_handler()
+--SKIPIF--
+<?php 
+require_once('skipif.inc');
+require_once('skipifemb.inc'); 
+if (!function_exists('mysqli_set_local_infile_handler'))
+    die("skip - function not available.");
+?>
+--FILE--
+<?php
+    include "connect.inc";
+    include("table.inc");   
+    
+    function callback_replace_buffer($fp, &$buffer, $buflen, &$error) {
+        static $invocation = 0;            
+        
+        printf("Callback: %d\n", $invocation);
+        flush();
+        
+        $buffer = fread($fp, $buflen);
+        $ret = "1;'a';\n";
+        $buffer = $ret;
+        
+        return strlen($buffer);
+    }
+
+    function try_handler($offset, $link, $file, $handler, $expected) {
+        
+        if (!mysqli_set_local_infile_handler($link, $handler)) {
+            printf("[%03d] Cannot set infile handler to '%s'\n", $offset, $handler);
+            return false;
+        }
+        printf("Callback set to '%s'\n", $handler);
+        
+        if (!mysqli_query($link, sprintf("DELETE FROM test"))) {
+            printf("[%03d] Cannot remove records, [%d] %s\n", $offset + 1,
mysqli_errno($link), mysqli_error($link));
+            return false;
+        }
+        
+        
+        if (!mysqli_query($link, sprintf("LOAD DATA LOCAL INFILE '%s' 
+                                        INTO TABLE test
+                                        FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY
'\''
+                                        LINES TERMINATED BY '\n'",
+            mysqli_real_escape_string($link, $file)))) {
+            printf("[%03d] LOAD DATA failed, [%d] %s\n", 
+                    $offset + 2,
+                    mysqli_errno($link), mysqli_error($link));
+        }
+        
+        if (!$res = mysqli_query($link, "SELECT id, label FROM test ORDER BY id")) {
+            printf("[%03d] [%d] %s\n", $offset + 3, mysqli_errno($link),
mysqli_error($link));
+            return false;
+        }
+
+        foreach ($expected as $k => $values) {
+            if (!$tmp = mysqli_fetch_assoc($res)) {
+                printf("[%03d/%d] [%d] %s\n", $offset + 4, $k, mysqli_errno($link),
mysqli_error($link));
+                return false;
+            }
+            if ($values['id'] != $tmp['id']) {
+                printf("[%03d/%d] Expecting %s got %s\n", 
+                    $offset + 5, $k, 
+                    $values['id'], $tmp['id']);
+                return false;
+            }
+            if ($values['label'] != $tmp['label']) {
+                printf("[%03d/%d] Expecting %s got %s\n", 
+                    $offset + 6, $k,
+                    $values['label'], $tmp['label']);
+                return false;
+            }
+        }
+        
+        if ($res && $tmp = mysqli_fetch_assoc($res))
+            printf("[%03d] More results than expected!\n");
+        
+        if ($res)
+            mysqli_free_result($res);
+        
+        return true;
+    }    
+    
+    // create a CVS file
+    $file = tempnam(sys_get_temp_dir(), 'mysqli_test');
+    if (!$fp = fopen($file, 'w'))
+        printf("[005] Cannot create CVS file '%s'\n", $file);
+
+    if (!fwrite($fp, "97;'x';\n") ||
+        !fwrite($fp, "98;'y';\n") ||
+        !fwrite($fp, "99;'z';\n"))
+        printf("[006] Cannot write CVS file '%s'\n", $file);
+        
+    fclose($fp);    
+    
+    if (!chmod($file, 0644))
+        printf("[007] Cannot change the file perms of '%s' from 0600 to 0644, MySQL might
not be able to read it\n",
+            $file);
+
+    
+    $expected = array(array('id' => 1, 'label' => 'a'));
+    try_handler(20, $link, $file, 'callback_replace_buffer', $expected);    
+    
+    mysqli_close($link);    
+    print "done!";
+?>
+--EXPECTF--
+Callback set to 'callback_nofileop'
+Callback: 0
+done!
\ No newline at end of file

Thread
PHP mysqlnd svn commit: r449 - trunk/tests/ext/mysqliuwendel22 Jun