$field = Key($data[$row]); if (strcmp(strval($data[$row][$field]), strval($value[$column]))) { $pass = 0; echo "FAILED!{$eol}"; $failed++; echo "Test {$test}: the query row field \"{$field}\" of for row {$row} was returned in \"" . $value[$column] . "\" unlike \"" . $data[$row][$field] . "\" as expected{$eol}"; break 2; } } } } if ($success && $pass) { for (Reset($data[0]), $column = 0; $column < count($data[0]); Next($data[0]), $column++) { $field = Key($data[0]); $type = $types[$column]; if (!($success = MetabaseQueryColumn($database, "SELECT {$field},user_id FROM users ORDER BY 2", $value, $type))) { break; } for ($row = 0; $row < $total_rows; $row++) { if (strcmp(strval($data[$row][$field]), strval($value[$row]))) { $pass = 0; echo "FAILED!{$eol}"; $failed++; echo "Test {$test}: the query column field \"{$field}\" of type {$type} for row {$row} was returned in \"" . $value[$row] . "\" unlike \"" . $data[$row][$field] . "\" as expected{$eol}"; break 2; } } } } if ($success && $pass) { for ($fields = "", Reset($data[0]), $column = 0; $column < count($data[0]); Next($data[0]), $column++) {
$data["access_date"] = MetabaseToday(); $data["access_time"] = MetabaseTime(); $data["approved"] = MetabaseNow(); for ($v = 0, Reset($values); $v < count($values); Next($values), $v++) { $data["user_name"] = $values[$data["user_id"] = Key($values)]; if (!InsertTestValues($database, $prepared_query, $data)) { $success = 0; break; } } MetabaseFreePreparedQuery($database, $prepared_query); if ($success) { $queries = array(MetabaseBeginsWith($database, "%") => array(1), MetabaseEndsWith($database, "%") => array(3), MetabaseContains($database, "%") => array(1, 2, 3, 9), "NOT " . MetabaseContains($database, "%") => array(4, 5, 6, 7, 8), MetabaseBeginsWith($database, "_") => array(5), MetabaseEndsWith($database, "_") => array(7), MetabaseContains($database, "_") => array(5, 6, 7, 9), "NOT " . MetabaseContains($database, "_") => array(1, 2, 3, 4, 8), MetabaseMatchPattern($database, array("begin", "%", "end")) => array(2, 4, 6, 8), MetabaseMatchPattern($database, array("begin", "_", "end")) => array(2, 6), MetabaseMatchPattern($database, array("%", "%", "end")) => array(1), MetabaseMatchPattern($database, array("_", "%", "end")) => array(5), MetabaseMatchPattern($database, array(" _@%\\ ]['?*")) => array(9)); for ($q = 0, Reset($queries); $q < count($queries); Next($queries), $q++) { $condition = Key($queries); if (!MetabaseQueryColumn($database, "SELECT user_id FROM users WHERE user_name " . $condition . " ORDER BY user_id", $rows, "integer")) { $success = 0; break; } if (count($queries[$condition]) != count($rows)) { $pass = 0; } else { for ($v = 0; $v < count($rows); $v++) { if ($queries[$condition][$v] != $rows[$v]) { $pass = 0; break; } } } if (!$pass) { $pass = 0;