Commit | Line | Data |
8c4efd11 |
1 | #!/usr/bin/perl |
2 | use strict; |
3 | |
4 | use FindBin qw/$Bin/; |
5 | use Test::More; |
6 | use Test::SQL::Translator; |
7 | use Test::Exception; |
4d438549 |
8 | use Test::Differences; |
8c4efd11 |
9 | use Data::Dumper; |
10 | use SQL::Translator; |
11 | use SQL::Translator::Schema::Constants; |
12 | |
13 | |
14 | BEGIN { |
15 | maybe_plan(1, 'SQL::Translator::Parser::XML::SQLFairy', |
16 | 'SQL::Translator::Producer::SQLite'); |
17 | } |
18 | |
19 | my $xmlfile = "$Bin/data/xml/schema.xml"; |
20 | |
21 | my $sqlt; |
22 | $sqlt = SQL::Translator->new( |
23 | no_comments => 1, |
24 | show_warnings => 1, |
25 | add_drop_table => 1, |
26 | ); |
27 | |
28 | die "Can't find test schema $xmlfile" unless -e $xmlfile; |
29 | |
30 | my $sql = $sqlt->translate( |
31 | from => 'XML-SQLFairy', |
32 | to => 'SQLite', |
33 | filename => $xmlfile, |
34 | ) or die $sqlt->error; |
35 | |
36 | # print ">>$sql<<\n"; |
37 | |
4d438549 |
38 | eq_or_diff($sql, << "SQL"); |
8c4efd11 |
39 | BEGIN TRANSACTION; |
40 | |
41 | |
8c4efd11 |
42 | DROP TABLE Basic; |
43 | CREATE TABLE Basic ( |
44 | id INTEGER PRIMARY KEY NOT NULL, |
45 | title varchar(100) NOT NULL DEFAULT 'hello', |
46 | description text DEFAULT '', |
47 | email varchar(255), |
48 | explicitnulldef varchar, |
49 | explicitemptystring varchar DEFAULT '', |
50 | -- Hello emptytagdef |
08d91aad |
51 | emptytagdef varchar DEFAULT '', |
b08b5416 |
52 | another_id int(10) DEFAULT '2', |
08d91aad |
53 | timest timestamp |
8c4efd11 |
54 | ); |
55 | |
4d438549 |
56 | CREATE INDEX titleindex_Basic ON Basic (title); |
57 | CREATE UNIQUE INDEX emailuniqueindex_Basic ON Basic (email); |
8c4efd11 |
58 | |
b08b5416 |
59 | DROP TABLE Another; |
60 | CREATE TABLE Another ( |
61 | id INTEGER PRIMARY KEY NOT NULL |
62 | ); |
63 | |
64 | |
8c4efd11 |
65 | COMMIT; |
66 | SQL |