+ foreach my $id ( 6,1,4,5,2 ) {
+
+ insert 'borrower_message_preferences' => {
+ borrowernumber => $borrowernumber,
+ message_attribute_id => $id,
+ days_in_advance => $id == 2 ? 0 : undef,
+ };
+
+ insert 'borrower_message_transport_preferences' => {
+ borrower_message_preference_id => $k->{mysql_insertid},
+ message_transport_type => 'email',
+ } if $id == 4;
+
+ }
+
+ }
+}
+
+sub sql {
+ my ($db,$sql) = @_;
+ foreach (split(/;/,$sql)) {
+ next if m/^\s*$/;
+ warn "# sql $_";
+ $db->do($_);