X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F57-class-dbi.t;h=b2a5eccb5cb38c2cc10c95ed410714a8a8abf637;hb=d8cf2279bd5e25db979d6251c5648d69fc5a298d;hp=ace3f53f5885a95f8dfa2fcc550d9e734f1f33f4;hpb=4c0d31c125be1c212c2b984f4a4d806a61b2bd6e;p=dbsrgits%2FSQL-Translator.git diff --git a/t/57-class-dbi.t b/t/57-class-dbi.t index ace3f53..b2a5ecc 100644 --- a/t/57-class-dbi.t +++ b/t/57-class-dbi.t @@ -23,7 +23,7 @@ use SQL::Translator::Producer::SQLite; my $view1_sql1 = [ SQL::Translator::Producer::SQLite::create_view( $view1, $create_opts ) ]; - my $view_sql_replace = [ "CREATE TEMPORARY VIEW IF NOT EXISTS view_foo AS + my $view_sql_replace = [ "CREATE TEMPORARY VIEW IF NOT EXISTS 'view_foo' AS SELECT id, name FROM thing" ]; is_deeply( $view1_sql1, $view_sql_replace, 'correct "CREATE TEMPORARY VIEW" SQL' ); @@ -35,7 +35,7 @@ use SQL::Translator::Producer::SQLite; my $view1_sql2 = [ SQL::Translator::Producer::SQLite::create_view( $view2, $create_opts ) ]; - my $view_sql_noreplace = [ "CREATE VIEW view_foo AS + my $view_sql_noreplace = [ "CREATE VIEW 'view_foo' AS SELECT id, name FROM thing" ]; is_deeply( $view1_sql2, $view_sql_noreplace, 'correct "CREATE VIEW" SQL' ); }