Debian Codegraph @

mysql-test/suite/ndb/t/ndb_import1.test

raw
1 --source include/have_ndb.inc
2
3 perl;
4 use strict;
5 require 'suite/ndb/t/ndb_import.pl';
6
7 # tables
8
9 # native numbers
10 my $t1attrs = [
11 { name=>"a", type=>"bigint", unsigned=>1, pk=>1 },
12 { name=>'b', type=>"bigint" },
13 { name=>'c', type=>"int", unsigned=>1 },
14 { name=>'d', type=>"int" },
15 { name=>'e', type=>"mediumint", unsigned=>1 },
16 { name=>'f', type=>"mediumint" },
17 { name=>'g', type=>"smallint", unsigned=>1 },
18 { name=>'h', type=>"smallint" },
19 { name=>'i', type=>"tinyint", unsigned=>1 },
20 { name=>'j', type=>"tinyint" },
21 { name=>'k', type=>"double" },
22 { name=>'l', type=>"float" },
23 ];
24 my $t1 = {
25 name => 't1',
26 attrs => $t1attrs,
27 rows => 1000,
28 };
29
30 # char
31 my $t2attrs = [
32 { name=>"a", type=>"char", len=>10, pk=>1 },
33 { name=>"b", type=>"char", len=>255 },
34 { name=>"c", type=>"varchar", len=>10 },
35 { name=>"d", type=>"varchar", len=>1000 },
36 ];
37 my $t2 = {
38 name => 't2',
39 attrs => $t2attrs,
40 rows => 1000,
41 };
42
43 # binary
44 my $t3attrs = [
45 { name=>"a", type=>"binary", len=>10, pk=>1 },
46 { name=>"b", type=>"binary", len=>255 },
47 { name=>"c", type=>"varbinary", len=>10 },
48 { name=>"d", type=>"varbinary", len=>1000 },
49 ];
50 my $t3 = {
51 name => 't3',
52 attrs => $t3attrs,
53 rows => 1000,
54 };
55
56 # decimal
57 my $t4attrs = [
58 { name=>"a", type=>"decimal", prec=>10, scale=>0 },
59 { name=>"b", type=>"decimal", prec=>20, scale=>0 },
60 { name=>"c", type=>"decimal", prec=>10, scale=>5 },
61 { name=>"d", type=>"decimal", prec=>20, scale=>5 },
62 { name=>"e", type=>"decimal", prec=>10, scale=>10 },
63 { name=>"f", type=>"decimal", prec=>20, scale=>10 },
64 { name=>"g", type=>"int", pk=>1 },
65 ];
66 my $t4 = {
67 name => 't4',
68 attrs => $t4attrs,
69 rows => 1000,
70 };
71
72 # bit XXX fix odd lengths
73 my $t5attrs = [
74 { name=>"a", type=>"bit", len=>1 },
75 { name=>"b", type=>"bit", len=>8 },
76 { name=>"c", type=>"bit", len=>16 },
77 { name=>"d", type=>"bit", len=>32 },
78 { name=>"e", type=>"bit", len=>64 },
79 { name=>"f", type=>"int", pk=>1 },
80 ];
81 my $t5 = {
82 name => 't5',
83 attrs => $t5attrs,
84 rows => 1000,
85 };
86
87 # date and time
88 my $t6attrs = [
89 { name=>"a", type=>"year" },
90 { name=>"b", type=>"date" },
91 { name=>"c", type=>"time", prec=>6 },
92 { name=>"d", type=>"datetime", prec=>3 },
93 { name=>"e", type=>"timestamp", prec=>6, notnull=>1 },
94 { name=>"f", type=>"int", pk=>1 }
95 ];
96 my $t6 = {
97 name => 't6',
98 attrs => $t6attrs,
99 rows => 1000,
100 };
101
102 # blobs
103 my $t7attrs = [
104 { name=>"a", type=>"text", len=>10 },
105 { name=>"b", type=>"text", len=>255 },
106 { name=>"c", type=>"text", len=>65536 },
107 { name=>"d", type=>"int", pk=>1 },
108 { name=>"e", type=>"blob", len=>10 },
109 { name=>"f", type=>"blob", len=>256 },
110 { name=>"g", type=>"blob", len=>65535 },
111 ];
112 my $t7 = {
113 name => 't7',
114 attrs => $t7attrs,
115 rows => 20,
116 };
117
118 # simple table for rejects testing
119 my $t8attrs = [
120 { name=>"a", type=>"int", unsigned=>1, pk=>1 },
121 { name=>"b", type=>"smallint", notnull=>1 },
122 { name=>"c", type=>"float", notnull=>1 },
123 { name=>"d", type=>"char", len=>10, minlen=>1, notnull=>1 },
124 ];
125 my $t8 = {
126 name => 't8',
127 attrs => $t8attrs,
128 rows => 1000,
129 };
130
131 # tests
132
133 my $test1 = {
134 tag => "a",
135 desc => "all data types, csv default format",
136 tables => [ $t1, $t2, $t3, $t4, $t5, $t6, $t7 ],
137 csvfmt => get_csvfmt1(),
138 rejectsopt => 0, # option to ndb_import
139 rejectsgen => 0, # number of bad rows to generate
140 verify => 'all',
141 };
142
143 my $test2 = {
144 tag => "b",
145 desc => "all data types, csv complex format",
146 tables => [ $t1, $t2, $t3, $t4, $t5, $t6, $t7 ],
147 csvfmt => get_csvfmt2(),
148 rejectsopt => 0,
149 rejectsgen => 0,
150 resumeopt => 0,
151 verify => 'all',
152 };
153
154 my $test3 = {
155 tag => "c",
156 desc => "success, with rejected rows",
157 tables => [ $t8 ],
158 csvfmt => get_csvfmt1(),
159 rejectsopt => 100,
160 rejectsgen => 100,
161 resumeopt => 0,
162 verify => 'pk',
163 dumpdata => 1,
164 };
165
166 my $test4 = {
167 tag => "d",
168 desc => "success, with rejected rows and resume",
169 tables => [ $t8 ],
170 csvfmt => get_csvfmt1(),
171 rejectsopt => 0,
172 rejectsgen => 10,
173 resumeopt => 1,
174 verify => 'pk',
175 dumpdata => 1,
176 };
177
178 my $tests = {
179 tag => '1',
180 testlist => [ $test1, $test2, $test3, $test4 ],
181 };
182
183 write_tests($tests);
184 exit(0);
185 EOF
186
187 # run test
188
189 --source include/have_ndb.inc
190 --source $MYSQLTEST_VARDIR/tmp/ndb_import1.inc
191
192 --remove_files_wildcard $MYSQLTEST_VARDIR/tmp t*.csv
193 --remove_files_wildcard $MYSQLTEST_VARDIR/tmp t*.map
194 --remove_files_wildcard $MYSQLTEST_VARDIR/tmp t*.rej
195 --remove_files_wildcard $MYSQLTEST_VARDIR/tmp t*.res
196 --remove_files_wildcard $MYSQLTEST_VARDIR/tmp t*.sto
197 --remove_files_wildcard $MYSQLTEST_VARDIR/tmp t*.stt
198 --remove_files_wildcard $MYSQLTEST_VARDIR/tmp t*.dump
199 --remove_files_wildcard $MYSQLTEST_VARDIR/tmp t*genrej
200 --remove_file $MYSQLTEST_VARDIR/tmp/ndb_import1.inc
201 --remove_file $NDB_TOOLS_OUTPUT
202
203 # vim:set ft=perl: