blob: f48e8011800cc28edc8e648ba1a950bccd96d949 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
|
# file : evolution/drop-foreign-key/testscript
# license : GNU GPL v2; see accompanying LICENSE file
.include ../../database-options.testscript
.include ../../$db-schema.testscript
test.arguments += $($(db)_options)
: basics
:
if! $sqlite
{
ss =; # Schema modification base file names.
# Drop everything.
#
for s: $schemas
ss =+ $s
end;
# Add base schema.
#
ss += test3-002-pre test3-002-post;
# Add migration.
#
ss += test3-003-pre test3-003-post;
# Run tests.
#
for s: $ss
f = $out_base/"$s".sql
if $mysql
cat $f | $create_schema_cmd
elif $pgsql
$create_schema_cmd -f $f
elif $oracle
$create_schema_cmd "@$f"
elif $mssql
$create_schema_cmd -i $f
end
if ($s == 'test3-002-post')
$* 1
elif ($s == 'test3-003-pre')
$* 2
elif ($s == 'test3-003-post')
$* 3
end
end
}
else
{
# Note that SQLite doesn't support dropping of foreign keys and so the
# driver is trivial. We, however, still run it once for good measure.
#
$* 1
}
|