From 8f2b7888a1f7b567ffc0d0747221378ad183739e Mon Sep 17 00:00:00 2001 From: Dobrica Pavlinusic Date: Wed, 21 Feb 2018 13:17:45 +0100 Subject: [PATCH] insert email into borrower_message_preferences --- borrower_message_preferences/add-missing.sh | 7 +++++++ 1 file changed, 7 insertions(+) diff --git a/borrower_message_preferences/add-missing.sh b/borrower_message_preferences/add-missing.sh index bcd0cf4..72b7ec8 100755 --- a/borrower_message_preferences/add-missing.sh +++ b/borrower_message_preferences/add-missing.sh @@ -9,3 +9,10 @@ wc -l /dev/shm/[12] diff /dev/shm/[12] | grep '^< ' | cut -d' ' -f2 | xargs -i mysql -e 'insert into borrower_message_preferences (borrowernumber,message_attribute_id,days_in_advance) values ({},2,0),({},1,null),({},4,null),({},5,null),({},6,null) ;' +mysql --batch -e 'select distinct borrower_message_preference_id from borrower_message_transport_preferences order by borrower_message_preference_id asc' koha_fer > /dev/shm/3 + +mysql --batch -e 'select borrower_message_preference_id from borrower_message_preferences where message_attribute_id = 4 order by borrower_message_preference_id asc' > /dev/shm/4 + +diff /dev/shm/[34] | grep '^> ' | cut -d' ' -f2 | xargs -i mysql -e "insert into borrower_message_transport_preferences (borrower_message_preference_id,message_transport_type) values ({},'email')" + + -- 2.20.1