From cc0d29947a257b19708571db2c22e7af45867294 Mon Sep 17 00:00:00 2001 From: "Matteo Nastasi (mop)" Date: Mon, 14 Feb 2011 08:28:25 +0100 Subject: [PATCH] dot configurations file management fixed --- sql/builder.sh | 47 +++++++++++++++++++++++++---------------------- 1 file changed, 25 insertions(+), 22 deletions(-) diff --git a/sql/builder.sh b/sql/builder.sh index cdb8a31..0417a05 100755 --- a/sql/builder.sh +++ b/sql/builder.sh @@ -3,16 +3,22 @@ # # all this part is from mopshop and we will use it to construct the brisk database # -DBHOST=127.0.0.1 -DBUSER=brisk -DBBASE=brisk -DBPASS=briskpass -PFX="bsk_" + +if [ -f $HOME/.db.conf ]; then + source $HOME/.db.conf +else + DBHOST=127.0.0.1 + DBUSER=brisk + DBBASE=brisk + DBPASS=briskpass + PFX="bsk_" +fi if [ -f $HOME/.brisk_install ]; then - . $HOME/.brisk_install + source $HOME/.brisk_install fi + sqlexe () { local sht sht=$1 @@ -38,9 +44,6 @@ one_or_all() { # MAIN # sht=0 -if [ -f $HOME/.db.conf ]; then - source $HOME/.db.conf -fi if [ "$1" = "-s" ]; then shift @@ -59,24 +62,24 @@ elif [ "$1" = "build" ]; then ( echo "-- MESG: build start" ; one_or_all $2 | grep -iv '^drop' ; echo "-- MESG: build end" ; ) | sqlexe $sht elif [ "$1" = "rebuild" ]; then ( echo "-- MESG: clean start" ; one_or_all $2 | grep -i '^drop' | tac ; echo "-- MESG: clean end" ; \ - echo "-- MESG: build start" ; one_or_all $2 | grep -iv '^drop' ; echo "-- MESG: build end" ; ) \ + echo "-- MESG: build start" ; one_or_all $2 | grep -iv '^drop' ; echo "-- MESG: build end" ; ) \ | sqlexe $sht elif [ "$1" = "psql" ]; then - psql -h $DBHOST -U $DBUSER $DBBASE + psql -h $DBHOST -U $DBUSER $DBBASE elif [ "$1" = "dump" ]; then - if [ $# -eq 1 ]; then - pg_dump -a --inserts -h $DBHOST -U $DBUSER $DBBASE - else - pg_dump -a --inserts -h $DBHOST -U $DBUSER $DBBASE > $2 - fi + if [ $# -eq 1 ]; then + pg_dump -a --inserts -h $DBHOST -U $DBUSER $DBBASE + else + pg_dump -a --inserts -h $DBHOST -U $DBUSER $DBBASE > $2 + fi elif [ "$1" = "dumpall" ]; then - if [ $# -eq 1 ]; then - pg_dump -h $DBHOST -U $DBUSER $DBBASE - else - pg_dump -h $DBHOST -U $DBUSER $DBBASE > $2 - fi + if [ $# -eq 1 ]; then + pg_dump -h $DBHOST -U $DBUSER $DBBASE + else + pg_dump -h $DBHOST -U $DBUSER $DBBASE > $2 + fi elif [ "$1" = "add" ]; then - cat "$2" | psql -h $DBHOST -U $DBUSER $DBBASE + cat "$2" | psql -h $DBHOST -U $DBUSER $DBBASE else echo " USAGE" echo " ./builder create" -- 2.17.1