X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F11mysql_common.t;h=a895fcf20596b523402bb6ee6041e8e834619ee8;hb=62bc1e5df21ffcb34d9ce6257fd641be54a156e6;hp=34ae23bcc0ff730916a843da87a23a3a63ba20b0;hpb=26334ec166bf25d77c0342c85efebe853303ff41;p=dbsrgits%2FDBIx-Class-Schema-Loader.git diff --git a/t/11mysql_common.t b/t/11mysql_common.t index 34ae23b..a895fcf 100644 --- a/t/11mysql_common.t +++ b/t/11mysql_common.t @@ -18,7 +18,7 @@ my $tester = dbixcsl_common_tests->new( user => $user, password => $password, connect_info_opts=> { on_connect_call => 'set_strict_mode' }, - skip_rels => $test_innodb ? 0 : 1, + skip_rels => $test_innodb ? 0 : $skip_rels_msg, no_inline_rels => 1, no_implicit_rels => 1, data_types => { @@ -121,6 +121,30 @@ my $tester = dbixcsl_common_tests->new( "set('foo', 'bar', 'baz')" => { data_type => 'set', extra => { list => [qw/foo bar baz/] } }, }, + extra => { + create => [ + q{ + CREATE TABLE mysql_loader_test1 ( + id INT AUTO_INCREMENT PRIMARY KEY, + value varchar(100) + ) + }, + q{ + CREATE VIEW mysql_loader_test2 AS SELECT * FROM mysql_loader_test1 + }, + ], + pre_drop_ddl => [ 'DROP VIEW mysql_loader_test2', ], + drop => [ 'mysql_loader_test1', ], + count => 1, + run => sub { + my ($schema, $monikers, $classes) = @_; + + my $rsrc = $schema->resultset($monikers->{mysql_loader_test2})->result_source; + + is $rsrc->column_info('value')->{data_type}, 'varchar', + 'view introspected successfully'; + }, + }, ); if( !$dsn || !$user ) {