Bug 14637: Fix add patron category under MySQL 5.7 - tests

[koha.git] / t / Letters.t

diff --git a/t/Letters.t b/t/Letters.t
index 18ae129..a072044 100755 (executable)
--- a/t/Letters.t
+++ b/t/Letters.t
@@ -17,30 +17,41 @@
 
 use Modern::Perl;
 
-use DBI;
 use Test::MockModule;
-use Test::More tests => 5;
-use t::lib::Mocks;
-my $module = new Test::MockModule('C4::Context');
-$module->mock(
-    '_new_dbh',
-    sub {
-        my $dbh = DBI->connect( 'DBI:Mock:', '', '' )
-          || die "Cannot create handle: $DBI::errstr\n";
-        return $dbh;
+use Test::More;
+
+use Module::Load::Conditional qw/check_install/;
+
+BEGIN {
+    if ( check_install( module => 'Test::DBIx::Class' ) ) {
+        plan tests => 6;
+    } else {
+        plan skip_all => "Need Test::DBIx::Class"
     }
-);
-my $mock_letters = [
-    [ 'module', 'code', 'branchcode', 'name', 'is_html', 'title', 'content' ],
-    [ 'blah',   'ISBN', 'NBSI',       'book', 1,         'green', 'blahblah' ],
-    [ 'bleh',   'ISSN', 'NSSI',       'page', 0,         'blue',  'blehbleh' ]
-];
+}
 
-use_ok('C4::Letters');
+use Test::DBIx::Class {
+    schema_class => 'Koha::Schema',
+    connect_info => ['dbi:SQLite:dbname=:memory:','',''],
+    connect_opts => { name_sep => '.', quote_char => '`', },
+    fixture_class => '::Populate',
+}, 'Letter' ;
+use t::lib::Mocks;
+
+fixtures_ok [
+    Letter => [
+        [ 'module', 'code', 'branchcode', 'name', 'is_html', 'title', 'content' ],
+        [ 'blah',   'ISBN', 'NBSI',       'book', 1,         'green', 'blahblah' ],
+        [ 'bleh',   'ISSN', 'NSSI',       'page', 0,         'blue',  'blehbleh' ]
+    ],
+], 'add fixtures';
 
-my $dbh = C4::Context->dbh();
+my $db = Test::MockModule->new('Koha::Database');
+$db->mock( _new_schema => sub { return Schema(); } );
+
+use_ok('C4::Letters');
 
-$dbh->{mock_add_resultset} = $mock_letters;
+t::lib::Mocks::mock_preference('dateformat', 'metric');
 
 my $letters = C4::Letters::GetLetters();