view release on metacpan or  search on metacpan

t/99dbic_sqlt_parser.t  view on Meta::CPAN

use strict;
use warnings;

use Test::More;
use Test::Warn;
use Test::Exception;
use Scalar::Util ();

use DBIO::SQLite::Test;
use DBIO::Util 'sigwarn_silencer';

BEGIN {
  plan skip_all =>
    'Legacy SQL::Translator parser path. DBIO replaced SQLT with the native '
    . 'DBIO::SQLite::Introspect/DDL/Diff classes (clean break, see Changes).';
}

# Test for SQLT-related leaks
{
  my $s = DBIO::Test::Schema->clone;

  my @schemas = (
    create_schema ({ schema => $s }),
    create_schema ({ args => { parser_args => { dbic_schema => $s } } }),
  );

  for my $parser_args_key (qw(
    DBIO::Schema
    DBIx::Schema
    package
  )) {
    warnings_exist {
      push @schemas, create_schema({
        args => { parser_args => { $parser_args_key => $s } }
      });
    } qr/\Qparser_args => {\E.+?is deprecated.+\Q@{[__FILE__]}/,
    "deprecated crazy parser_arg '$parser_args_key' warned";
  }

  Scalar::Util::weaken ($s);

  ok (!$s, 'Schema not leaked');

  isa_ok ($_, 'SQL::Translator::Schema', "SQLT schema object $_ produced")
    for @schemas;
}

# make sure classname-style works
lives_ok { isa_ok (create_schema ({ schema => 'DBIO::Test::Schema' }), 'SQL::Translator::Schema', 'SQLT schema object produced') };

# make sure a connected instance passed via $args does not get the $dbh improperly serialized
SKIP: {

  # YAML is a build_requires dep of SQLT - it may or may not be here
  eval { require YAML } or skip "Test requires YAML.pm", 1;

  lives_ok {

    my $s = DBIO::SQLite::Test->init_schema(no_populate => 1);
    ok ($s->storage->connected, '$schema instance connected');

    # roundtrip through YAML
    my $yaml_rt_schema = SQL::Translator->new(
      parser => 'SQL::Translator::Parser::YAML'
    )->translate(
      data => SQL::Translator->new(
        parser_args => { dbic_schema => $s },
        parser => 'SQL::Translator::Parser::DBIO',
        producer => 'SQL::Translator::Producer::YAML',
      )->translate
    );

    isa_ok ( $yaml_rt_schema, 'SQL::Translator::Schema', 'SQLT schema object produced after YAML roundtrip');

    ok ($s->storage->connected, '$schema instance still connected');
  }

  eval <<'EOE' or die $@;
  END {
    # we are in END - everything remains global
    #
    $^W = 1;  # important, otherwise DBI won't trip the next fail()
    $SIG{__WARN__} = sub {
      fail "Unexpected global destruction warning"
        if $_[0] =~ /is not a DBI/;
      warn @_;
    };
  }
EOE

}

my $schema = DBIO::SQLite::Test->init_schema( no_deploy => 1 );

# Dummy was yanked out by the sqlt hook test
# CustomSql tests the horrific/deprecated ->name(\$sql) hack
# YearXXXXCDs are views
#
my @sources = grep
  { $_ !~ /^ (?: Dummy | CustomSql | Year\d{4}CDs ) $/x }