1
# Copyright (c) 2008,2010 Oracle and/or its affiliates. All rights reserved.
2
# Use is subject to license terms.
4
# This program is free software; you can redistribute it and/or modify
5
# it under the terms of the GNU General Public License as published by
6
# the Free Software Foundation; version 2 of the License.
8
# This program is distributed in the hope that it will be useful, but
9
# WITHOUT ANY WARRANTY; without even the implied warranty of
10
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
11
# General Public License for more details.
13
# You should have received a copy of the GNU General Public License
14
# along with this program; if not, write to the Free Software
15
# Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301
18
package GenTest::Validator::DrizzleTransformer;
21
@ISA = qw(GenTest::Validator GenTest);
26
use GenTest::Constants;
27
use GenTest::Comparator;
28
#use GenTest::Simplifier::SQL;
29
#use GenTest::Simplifier::Test;
30
use GenTest::Translator;
31
use GenTest::Translator::Mysqldump2ANSI;
32
use GenTest::Translator::Mysqldump2javadb;
33
use GenTest::Translator::MysqlDML2ANSI;
35
my @transformer_names;
37
my $database_created = 0;
40
@transformer_names = (
41
'DrizzleExecuteString',
42
'DrizzleExecuteVariable'
45
say("Transformer Validator will use the following Transformers: ".join(', ', @transformer_names));
47
foreach my $transformer_name (@transformer_names) {
48
eval ("require GenTest::Transform::'".$transformer_name) or die $@;
49
my $transformer = ('GenTest::Transform::'.$transformer_name)->new();
50
push @transformers, $transformer;
55
my ($validator, $executors, $results) = @_;
57
my $executor = $executors->[0];
58
my $original_result = $results->[0];
59
my $original_query = $original_result->query();
61
if ($database_created == 0) {
62
$executor->dbh()->do("CREATE DATABASE IF NOT EXISTS transforms");
63
$database_created = 1;
66
return STATUS_WONT_HANDLE if $original_query !~ m{^\s*SELECT}sio;
67
return STATUS_WONT_HANDLE if defined $results->[0]->warnings();
68
return STATUS_WONT_HANDLE if $results->[0]->status() != STATUS_OK;
70
my $max_transformer_status;
71
foreach my $transformer (@transformers) {
72
my $transformer_status = $validator->transform($transformer, $executor, $results);
73
$transformer_status = STATUS_OK if ($transformer_status == STATUS_CONTENT_MISMATCH) && ($original_query =~ m{LIMIT}sio);
74
return $transformer_status if $transformer_status > STATUS_CRITICAL_FAILURE;
75
$max_transformer_status = $transformer_status if $transformer_status > $max_transformer_status;
78
return $max_transformer_status > STATUS_SELECT_REDUCTION ? $max_transformer_status - STATUS_SELECT_REDUCTION : $max_transformer_status;
82
my ($validator, $transformer, $executor, $results) = @_;
84
my $original_result = $results->[0];
85
my $original_query = $original_result->query();
87
my ($transform_outcome, $transformed_queries, $transformed_results) = $transformer->transformExecuteValidate($original_query, $original_result, $executor);
88
return $transform_outcome if ($transform_outcome > STATUS_CRITICAL_FAILURE) || ($transform_outcome eq STATUS_OK);
90
say("Original query: $original_query failed transformation with Transformer ".$transformer->name());
91
say("Transformed query: ".join('; ', @$transformed_queries));
93
say(GenTest::Comparator::dumpDiff($original_result, $transformed_results->[0]));
95
# NOTE: Removed Simplification code from here
97
return $transform_outcome;