3 # This file is part of Koha.
5 # Copyright 2014 - Biblibre SARL
7 # Koha is free software; you can redistribute it and/or modify it
8 # under the terms of the GNU General Public License as published by
9 # the Free Software Foundation; either version 3 of the License, or
10 # (at your option) any later version.
12 # Koha is distributed in the hope that it will be useful, but
13 # WITHOUT ANY WARRANTY; without even the implied warranty of
14 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
15 # GNU General Public License for more details.
17 # You should have received a copy of the GNU General Public License
18 # along with Koha; if not, see <http://www.gnu.org/licenses>.
22 use Test
::More tests
=> 41;
27 use_ok
('t::lib::TestBuilder');
30 my $schema = Koha
::Database
->new->schema;
31 $schema->storage->txn_begin;
33 my $builder = t
::lib
::TestBuilder
->new();
35 is
( $builder->build(), undef, 'build without arguments returns undef' );
37 my @sources = $builder->schema->sources;
38 my @source_in_failure;
39 for my $source (@sources) {
40 eval { $builder->build( { source
=> $source } ); };
41 push @source_in_failure, $source if $@
;
43 is
( @source_in_failure, 0, 'TestBuilder should be able to create an object for every sources' );
44 if ( @source_in_failure ) {
45 diag
("The following sources have not been generated correctly: " . join ', ', @source_in_failure)
48 my $my_overduerules_transport_type = {
49 message_transport_type
=> {
50 message_transport_type
=> 'my msg_t_t',
54 branchcode
=> 'codeB',
55 categorycode
=> 'codeC',
57 categorycode
=> undef,
59 $my_overduerules_transport_type->{categorycode
} = $my_overduerules_transport_type->{branchcode
};
60 my $overduerules_transport_type = $builder->build({
61 source
=> 'OverduerulesTransportType',
62 value
=> $my_overduerules_transport_type,
65 $overduerules_transport_type->{message_transport_type
},
66 $my_overduerules_transport_type->{message_transport_type
}->{message_transport_type
},
67 'build stores the message_transport_type correctly'
70 $overduerules_transport_type->{letternumber
},
71 $my_overduerules_transport_type->{letternumber
},
72 'build stores the letternumber correctly'
75 $overduerules_transport_type->{branchcode
},
76 $my_overduerules_transport_type->{branchcode
}->{branchcode
},
77 'build stores the branchcode correctly'
80 $overduerules_transport_type->{categorycode
},
81 $my_overduerules_transport_type->{categorycode
}->{categorycode
},
82 'build stores the categorycode correctly'
85 $overduerules_transport_type->{_fk
}->{message_transport_type
}->{message_transport_type
},
86 $my_overduerules_transport_type->{message_transport_type
}->{message_transport_type
},
87 'build stores the foreign key message_transport_type correctly'
90 $overduerules_transport_type->{_fk
}->{branchcode
}->{branchcode
},
91 $my_overduerules_transport_type->{branchcode
}->{branchcode
},
92 'build stores the foreign key branchcode correctly'
95 $overduerules_transport_type->{_fk
}->{categorycode
}->{categorycode
},
96 $my_overduerules_transport_type->{categorycode
}->{categorycode
},
97 'build stores the foreign key categorycode correctly'
100 $overduerules_transport_type->{_fk
}->{branchcode
},
101 $overduerules_transport_type->{_fk
}->{categorycode
},
102 'build links the branchcode and the categorycode correctly'
105 $overduerules_transport_type->{_fk
}->{branchcode
}->{letter2
},
107 'build generates values if they are not given'
110 my $my_user_permission = $t::lib
::TestBuilder
::default_value
->{UserPermission
};
111 my $user_permission = $builder->build({
112 source
=> 'UserPermission',
115 $user_permission->{borrowernumber
},
117 'build generates a borrowernumber correctly'
120 $user_permission->{module_bit
},
121 $my_user_permission->{module_bit
}->{module_bit
}->{bit
},
122 'build stores the default value correctly'
125 $user_permission->{code
},
126 $my_user_permission->{module_bit
}->{code
},
127 'build stores the default value correctly'
130 $user_permission->{borrowernumber
},
131 $user_permission->{_fk
}->{borrowernumber
}->{borrowernumber
},
132 'build links the foreign key correctly'
135 $user_permission->{_fk
}->{borrowernumber
}->{surname
},
136 $my_user_permission->{borrowernumber
}->{surname
},
137 'build stores the foreign key value correctly'
140 $user_permission->{_fk
}->{borrowernumber
}->{address
},
141 $my_user_permission->{borrowernumber
}->{address
},
142 'build stores the foreign key value correctly'
145 $user_permission->{_fk
}->{borrowernumber
}->{city
},
146 $my_user_permission->{borrowernumber
}->{city
},
147 'build stores the foreign key value correctly'
150 $user_permission->{_fk
}->{borrowernumber
}->{_fk
}->{branchcode
}->{branchcode
},
151 $my_user_permission->{borrowernumber
}->{branchcode
}->{branchcode
},
152 'build stores the foreign key value correctly'
155 $user_permission->{_fk
}->{borrowernumber
}->{_fk
}->{branchcode
}->{branchname
},
156 $my_user_permission->{borrowernumber
}->{branchcode
}->{branchname
},
157 'build stores the foreign key value correctly'
160 $user_permission->{_fk
}->{borrowernumber
}->{_fk
}->{categorycode
}->{categorycode
},
161 $my_user_permission->{borrowernumber
}->{categorycode
}->{categorycode
},
162 'build stores the foreign key value correctly'
165 $user_permission->{_fk
}->{borrowernumber
}->{_fk
}->{categorycode
}->{hidelostitems
},
166 $my_user_permission->{borrowernumber
}->{categorycode
}->{hidelostitems
},
167 'build stores the foreign key value correctly'
170 $user_permission->{_fk
}->{borrowernumber
}->{_fk
}->{categorycode
}->{category_type
},
171 $my_user_permission->{borrowernumber
}->{categorycode
}->{category_type
},
172 'build stores the foreign key value correctly'
175 $user_permission->{_fk
}->{borrowernumber
}->{_fk
}->{categorycode
}->{defaultprivacy
},
176 $my_user_permission->{borrowernumber
}->{categorycode
}->{defaultprivacy
},
177 'build stores the foreign key value correctly'
180 $user_permission->{_fk
}->{borrowernumber
}->{privacy
},
181 $my_user_permission->{borrowernumber
}->{privacy
},
182 'build stores the foreign key value correctly'
185 $user_permission->{_fk
}->{module_bit
}->{_fk
}->{module_bit
}->{bit
},
186 $my_user_permission->{module_bit
}->{module_bit
}->{bit
},
187 'build stores the foreign key value correctly'
190 $user_permission->{_fk
}->{module_bit
}->{code
},
191 $my_user_permission->{module_bit
}->{code
},
192 'build stores the foreign key value correctly'
195 $user_permission->{_fk
}->{module_bit
},
196 $user_permission->{_fk
}->{code
},
197 'build links the codes correctly'
200 $user_permission->{_fk
}->{borrowernumber
}->{cardnumber
},
202 'build generates values if they are not given'
205 $user_permission->{_fk
}->{borrowernumber
}->{_fk
}->{branchcode
}->{branchaddress1
},
207 'build generates values if they are not given'
210 $user_permission->{_fk
}->{borrowernumber
}->{_fk
}->{categorycode
}->{description
},
212 'build generates values if they are not given'
215 $user_permission->{_fk
}->{module_bit
}->{description
},
217 'build generates values if they are not given'
220 $user_permission->{_fk
}->{module_bit
}->{_fk
}->{module_bit
}->{flag
},
222 'build generates values if they are not given'
226 my $nb_basket = $builder->schema->resultset('Aqbasket')->search();
227 isnt
( $nb_basket, 0, 'add stores the generated entries correctly' );
228 $builder->clear( { source
=> 'Aqbasket' } );
229 $nb_basket = $builder->schema->resultset('Aqbasket')->search();
230 is
( $nb_basket, 0, 'clear removes all the entries correctly' );
233 my $rs_aqbookseller = $builder->schema->resultset('Aqbookseller');
234 my $bookseller = $builder->build({
235 source
=> 'Aqbookseller',
238 delete $bookseller->{_fk
};
239 my $bookseller_from_db = $rs_aqbookseller->find($bookseller);
240 is
( $bookseller_from_db, undef, 'build with only_fk = 1 does not store the entry' );
241 my $bookseller_result = $rs_aqbookseller->create($bookseller);
242 is
( $bookseller_result->in_storage, 1, 'build with only_fk = 1 creates the foreign keys correctly' );
244 $bookseller = $builder->build({
245 source
=> 'Aqbookseller',
247 ok
( length( $bookseller->{phone
} ) <= 30, 'The length for a generated string should not be longer than the size of the DB field' );
248 delete $bookseller->{_fk
};
249 $bookseller_from_db = $rs_aqbookseller->find($bookseller);
250 is
( $bookseller_from_db->in_storage, 1, 'build without the parameter only_sk stores the entry correctly' );
252 $bookseller = $builder->build({
253 source
=> 'Aqbookseller',
256 delete $bookseller->{_fk
};
257 $bookseller_from_db = $rs_aqbookseller->find($bookseller);
258 is
( $bookseller_from_db->in_storage, 1, 'build with only_fk = 0 stores the entry correctly' );
260 $schema->storage->txn_rollback;