borrower_message_preferences add missing borrowers

accounts opened authmatically from SAML don't currently have
inserts into borrower_message_preferences

diff --git a/borrower_message_preferences/add-missing.sh b/borrower_message_preferences/add-missing.sh
new file mode 100755 (executable)
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) ;'
+