Scripts per actualització de versió de l'ERP

db_backup.sh

#!/bin/sh
source VARS.sh
for DBNAME in `psql -ltA | grep '|erp|' | cut -d '|' -f 1`; do
  echo "Dumping $DBNAME" && \
  mkdir -p /home/erp/var/backups/${DBNAME} && \
  pg_dump $DBNAME > "/home/erp/var/backups/${DBNAME}/${DBNAME}_pre_${VERSION}.sql" && \
  echo "$DBNAME backup done." &
done

db_bz2.sh

#!/bin/sh
source VARS.sh
for DBNAME in `psql -ltA | grep '|erp|' | cut -d '|' -f 1`; do
  echo "Bziping $DBNAME" && \
  bzip2 "/home/erp/var/backups/${DBNAME}/${DBNAME}_pre_${VERSION}.sql" && \
  echo "$DBNAME backup done." &
done

db_sql_file.sh

#!/bin/sh
for DBNAME in `psql -ltA | grep '|erp|' | cut -d '|' -f 1`; do
  echo "Executing in $DBNAME" && \
  psql $DBNAME < $1 && \
  echo "$DBNAME done."
done

restarterp_supervisor.sh

source /home/supervisor/bin/activate
supervisorctl restart `supervisorctl status | grep 'ERP_' | cut -d ' ' -f 1 | xargs `

update_server.sh

#!/bin/sh
cd /home/erp/src/erp/server/bin
for SCONF in `ls -1 /home/erp/conf | grep -v mongo`; do
  echo "Updating $SCONF..." && \
  ./openerp-server.py --config=/home/erp/conf/$SCONF --price_accuracy=6 --update=all --stop-after-init && \
  echo "******* $SCONF Done ********" &
done

VARS.sh

VERSION="2.35.0"