+BEGIN { do "./t/lib/ANFANG.pm" or die ( $@ || $! ) }
+use DBIx::Class::Optional::Dependencies -skip_all_without => 'admin';
+
use strict;
use warnings;
use Test::More;
-
use Test::Exception;
-BEGIN {
- require DBIx::Class;
- plan skip_all => 'Test needs ' . DBIx::Class::Optional::Dependencies->req_missing_for('admin')
- unless DBIx::Class::Optional::Dependencies->req_ok_for('admin');
-}
-use lib 't/lib';
use DBICTest;
-use ok 'DBIx::Class::Admin';
-
+use DBIx::Class::Admin;
{ # test data maniplulation functions
sqlite_use_file => 1,
);
+ my $storage = $schema->storage;
+ $storage = $storage->master
+ if $storage->isa('DBIx::Class::Storage::DBI::Replicated');
+
my $admin = DBIx::Class::Admin->new(
schema_class=> "DBICTest::Schema",
- connect_info => $schema->storage->connect_info(),
+ connect_info => $storage->connect_info(),
quiet => 1,
_confirm=>1,
);
$admin->insert('Employee', {name =>'Aran'});
- my $expected_data = [
+ my $expected_data = [
[$employee->result_source->columns() ],
- [1,1,undef,undef,undef,'Trout'],
- [2,2,undef,undef,undef,'Aran']
+ [1,1,undef,undef,undef,'Trout',undef],
+ [2,2,undef,undef,undef,'Aran',undef]
];
my $data;
- lives_ok { $data = $admin->select('Employee')} 'can retrive data from database';
+ lives_ok { $data = $admin->select('Employee', undef, { order_by => 'employee_id' })} 'can retrive data from database';
is_deeply($data, $expected_data, 'DB matches whats expected');
$admin->delete('Employee', {name=>'Trout'});