Project

General

Profile

« Previous | Next » 

Revision 2979

Added by Aaron Marcuse-Kubitza about 12 years ago

schemas: Moved *.sql.make into Makefile to take advantage of % pattern matching

View differences:

schemas/functions.sql.make
1 
#!/bin/sh
2 
# Creates functions.sql by dumping vegbien's functions schema
3 

  		




  4
  
  
    
selfDir="$(dirname -- "$0")"


  		




  5
  
  
    

  		




  6
  
  
    
"$selfDir/../bin/pg_dump_vegbien" functions


  		




  7
  0
  
    

  		












  

    
      schemas/py_functions.sql.make
    
  





  1
  
  
    
#!/bin/sh


  		




  2
  
  
    
# Creates py_functions.sql by dumping vegbien's py_functions schema


  		




  3
  
  
    

  		




  4
  
  
    
selfDir="$(dirname -- "$0")"


  		




  5
  
  
    

  		




  6
  
  
    
env owners=1 "$selfDir/../bin/pg_dump_vegbien" py_functions


  		




  7
  0
  
    

  		












  

    
      schemas/vegbien.sql.make
    
  





  1
  
  
    
#!/bin/sh


  		




  2
  
  
    
# Creates vegbien.sql by dumping vegbien's public schema


  		




  3
  
  
    

  		




  4
  
  
    
selfDir="$(dirname -- "$0")"


  		




  5
  
  
    

  		




  6
  
  
    
"$selfDir/../bin/pg_dump_vegbien" public


  		




  7
  0
  
    

  		












  

    
      schemas/Makefile
    
  





  21
  21
  
    
clean: _always


  		




  22
  22
  
    
	$(RM) $(all)


  		




  23
  23
  
    

  		




  24
  
  
    
%:: %.make


  		




  25
  
  
    
	./$< >$@


  		




  26
  
  
    

  		




  27
  24
  
    
##### MySQL schema for ERD


  		




  28
  25
  
    

  		




  29
  26
  
    
repl = ../bin/repl


  		




  30
  27
  
    

  		




  31
  28
  
    
%.my.sql: %.sql ../lib/PostgreSQL-MySQL.csv filter_ERD.csv


  		




  32
  29
  
    
	$(repl) <$(wordlist 1,2,$+)|$(repl) $(word 3,$+) >$@


  		




  
  30
  
    

  		




  
  31
  
    
##### DDLs


  		




  
  32
  
    

  		




  
  33
  
    
pg_dump = ../bin/pg_dump_vegbien $(1) >$@


  		




  
  34
  
    

  		




  
  35
  
    
vegbien.sql:


  		




  
  36
  
    
	$(call pg_dump,public)


  		




  
  37
  
    

  		




  
  38
  
    
py_functions.sql:


  		




  
  39
  
    
	env owners=1 $(call pg_dump,py_functions)


  		




  
  40
  
    

  		




  
  41
  
    
# Must come after %.my.sql so that gets matched first


  		




  
  42
  
    
%.sql:


  		




  
  43
  
    
	$(call pg_dump,$*)


  		












Also available in:  Unified diff