From a9ef528951457a70a6a370a3cbe1211fa40d247f Mon Sep 17 00:00:00 2001 From: Dobrica Pavlinusic Date: Wed, 21 Feb 2018 12:55:43 +0100 Subject: [PATCH] borrower_message_preferences add missing borrowers accounts opened authmatically from SAML don't currently have inserts into borrower_message_preferences --- borrower_message_preferences/add-missing.sh | 11 +++++++++++ 1 file changed, 11 insertions(+) create mode 100755 borrower_message_preferences/add-missing.sh diff --git a/borrower_message_preferences/add-missing.sh b/borrower_message_preferences/add-missing.sh new file mode 100755 index 0000000..bcd0cf4 --- /dev/null +++ b/borrower_message_preferences/add-missing.sh @@ -0,0 +1,11 @@ +#!/bin/sh -xe + + +mysql --skip-column-names --batch -e 'select borrowernumber from borrowers order by borrowernumber asc' koha_fer > /dev/shm/1 + +mysql --batch -e 'select distinct borrowernumber from borrower_message_preferences order by borrowernumber asc' koha_fer > /dev/shm/2 + +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) ;' + -- 2.20.1