-#
-#===============================================================================
-#
-# FILE: 03sql.t
-#
-# DESCRIPTION: test sql manipulation funtions
-#
-# FILES: ---
-# BUGS: ---
-# NOTES: ---
-# AUTHOR: Gordon Irving (), <goraxe@cpan.org>
-# VERSION: 1.0
-# CREATED: 12/12/09 12:44:57 GMT
-# REVISION: ---
-#===============================================================================
+use DBIx::Class::Optional::Dependencies -skip_all_without => 'admin';
use strict;
use warnings;
use Test::More;
-
use Test::Exception;
-use Test::Deep;
-
-BEGIN {
- eval "use DBIx::Class::Admin";
- plan skip_all => "Deps not installed: $@" if $@;
-}
use lib 't/lib';
use DBICTest;
-use ok 'DBIx::Class::Admin';
-
+use DBIx::Class::Admin;
{ # test data maniplulation functions
$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';
- cmp_deeply($data, $expected_data, 'DB matches whats expected');
+ 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'});
my $del_rs = $employees->search({name => 'Trout'});
is ($employees->count(), 1, "left Aran" );
}
-
-
done_testing;