X-Git-Url: https://mop.ddnsfree.com/gitweb/?a=blobdiff_plain;f=sql%2Fbuilder.sh;h=83843d3065b0173307b70326de0116a452ef9bce;hb=d40b54308d7b7cbeaaf0b997fcf5f9dcbef64518;hp=4acc242f7555aa81d3fe7e8035da8882e1fa4ba0;hpb=e19ba01834625d96835b3adf385a1defc48f4166;p=brisk.git

diff --git a/sql/builder.sh b/sql/builder.sh
index 4acc242..83843d3 100755
--- a/sql/builder.sh
+++ b/sql/builder.sh
@@ -14,7 +14,8 @@ usage () {
     echo "       rebuild"
     echo "       psql"
     echo "       piped"
-    echo "       add <filesql>"
+    echo "       add <filesql> [<filesql2> [..]]"
+    echo "       del <filesql> [<filesql2> [..]]"
     echo "       dump [dumpfile]"
     echo "       dumpall [dumpfile]"
     echo "       all"
@@ -145,7 +146,10 @@ case $CMD in
         fi
         ;;
     "add")
-        cat "$1" | sqlexe
+        ( echo "-- MESG: add start" ; cat "$@" | egrep -iv "$MATCH_DROP" ; echo "-- MESG: add end" ;   ) | sqlexe
+        ;;
+    "del")
+        ( echo "-- MESG: del start" ; cat "$@" | egrep -i  "$MATCH_DROP" | tac ; echo "-- MESG: del end" ;   ) | sqlexe
         ;;
     "help"|"-h"|"--help")
         usage 0
@@ -155,4 +159,4 @@ case $CMD in
         ;;
 esac
 
-exit 0
\ No newline at end of file
+exit 0