The Perl and Raku Conference 2025: Greenville, South Carolina - June 27-29 Learn more

#!perl
use Test::More no_plan;
use lib qw(t/lib);
use IO::All;
my $tempdir = tempdir;
# set up and populate schema
ok(my $schema = DBICTest->init_schema(db_dir => $tempdir), 'got schema');
my $config_dir = io->catfile(qw't var configs')->name;
# do dump
ok(my $fixtures = DBIx::Class::Fixtures->new({
config_dir => $config_dir,
debug => 0
}), 'object created with correct config dir'
);
foreach my $set ('simple', 'quantity', 'fetch', 'rules') {
no warnings 'redefine';
DBICTest->clear_schema($schema);
DBICTest->populate_schema($schema);
ok($fixtures->dump({
config => "$set.json",
schema => $schema,
directory => $tempdir
}), "$set dump executed okay"
);
$fixtures->populate({
ddl => io->catfile(qw[t lib sqlite.sql])->name,
connection_details => ['dbi:SQLite:'.io->catfile($tempdir, qw[ DBIxClass.db ])->name, '', ''],
directory => $tempdir
});
$schema = DBICTest->init_schema(db_dir => $tempdir, no_deploy => 1);
my $fixture_dir = dir($tempdir);
foreach my $class ($schema->sources) {
my $source_dir = dir($fixture_dir, lc($class));
is($schema->resultset($class)->count,
(-e $source_dir) ? scalar($source_dir->children) : 0,
"correct number of $set " . lc($class)
);
next unless (-e $source_dir);
my $rs = $schema->resultset($class);
foreach my $row ($rs->all) {
my $file = file($source_dir, $row->id . '.fix');
my $HASH1; eval($file->slurp());
is_deeply(
$HASH1,
{$row->get_columns},
"$set " . lc($class) . " row " . $row->id . " imported okay"
);
}
}
}
# use_create => 1
$schema = DBICTest->init_schema(db_dir => $tempdir);
$fixtures = DBIx::Class::Fixtures->new({
config_dir => $config_dir,
debug => 0
});
ok( $fixtures->dump({
config => "use_create.json",
schema => $schema,
directory => $tempdir
}), "use_create dump executed okay"
);
$schema = DBICTest->init_schema(db_dir => $tempdir, no_populate => 1 );
$fixtures->populate({
directory => $tempdir,
connection_details => ['dbi:SQLite:'.io->catfile($tempdir, qw[ DBIxClass.db ])->name, '', ''],
schema => $schema,
no_deploy => 1,
use_create => 1
});
$schema = DBICTest->init_schema(db_dir => $tempdir, no_deploy => 1, no_populate => 1 );
is( $schema->resultset( "Artist" )->find({ artistid => 4 })->name, "Test Name", "use_create => 1 ok" );
$schema = DBICTest->init_schema(db_dir => $tempdir, no_populate => 1 );
$fixtures->populate({
directory => $tempdir,
connection_details => ['dbi:SQLite:'.io->catfile($tempdir, qw[ DBIxClass.db ])->name, '', ''],
schema => $schema,
no_deploy => 1,
use_find_or_create => 1
});
is( $schema->resultset( "Artist" )->find({ artistid => 4 })->name, "Test Name", "use_find_or_create => 1 ok" );
$fixtures->populate({
directory => $tempdir,
connection_details => ['dbi:SQLite:'.io->catfile($tempdir, qw[ DBIxClass.db ])->name, '', ''],
schema => $schema,
no_deploy => 1,
use_find_or_create => 1
});
is( $schema->resultset( "Artist" )->find({ artistid => 4 })->name, "Test Name", "idempotent use_find_or_create => 1 ok" );