/[hr-web]/sql/Makefile
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Diff of /sql/Makefile

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 1.3 by dpavlin, Sat Apr 21 14:14:42 2001 UTC revision 1.4 by ravilov, Wed Jun 19 16:38:10 2002 UTC
# Line 1  Line 1 
1  db=education  db = education
2  portal=portal.pliva.hr  portal = portal.pliva.hr
3    
4  all:  all:
5          @echo dump,create,drop,insert,fill          @echo dump, create, drop, insert, fill
6    
7  dump:  dump:
8          pg_dump $(db) > $(db).sql          pg_dump "$(db)" >"$(db).sql"
9    
10  create:  create:
11          createdb $(db)          createdb "$(db)"
12    
13  drop:  drop:
14          psql -c "drop database $(db)" template1          dropdb "$(db)"
15    
16  insert:  insert:
17  #       psql $(db) < $(db).sql          cat "$(db).sql" | sed -e 's/::text//g' -e 's/::bool//g' | psql "$(db)"
         cat $(db).sql | sed 's/::text//' | sed 's/::bool//' | psql $(db)  
18    
19  fill: drop create insert  fill: drop create insert
20    
21  fill2:  fill2:
22          psql -c "drop database $(db)2" template1          dropdb "$(db)2"
23          createdb $(db)2          createdb "$(db)2"
24          cat $(db).sql | sed 's/::text//' | sed 's/::bool//' | psql $(db)2          cat "$(db).sql" | sed -e 's/::text//g' -e 's/::bool//g' | psql "$(db)2"
25    
26  convert: dump  convert: dump
27          cat $(db).sql | sed 's/::text//' | sed 's/::bool//' | sed 's/   \([01][0-9]\)-\([0123][0-9]\)-\([12][0-9][0-9][0-9]\)/  \2-\1-\3/g' | sed 's,/usr/lib/pgsql/,/usr/lib/postgresql/lib/,g' > $(db)-7.sql          cat "$(db).sql" | sed -e 's/::text//' -e 's/::bool//' | sed 's/ \([01][0-9]\)-\([0123][0-9]\)-\([12][0-9][0-9][0-9]\)/  \2-\1-\3/g' | sed 's,/usr/lib/pgsql/,/usr/lib/postgresql/lib/,g' > $(db)-7.sql
   
28    
29  dist2portal:  dist2portal:
30          psql -h $(portal) -c "drop database $(db)" template1          psql -h $(portal) -c "drop database $(db)" template1
Legend:
Removed from v.1.3  
changed lines
  Added in v.1.4
  ViewVC Help
Powered by ViewVC 1.1.26