Project

General

Profile

« Previous | Next » 

Revision 218

Added by Aaron Marcuse-Kubitza about 13 years ago

Moved schema replacements from VegBank-VegBIEN.csv to VegBank-VegBIEN.schema.csv

View differences:

mappings/VegBank-VegBIEN.schema.csv
1 
"VegBank","VegBIEN","Comments"
2 
" (?:LC_COLLATE|LC_CTYPE) = '.*?'",,"support PostgreSQL before 8.4"
3 
"vegbank(?=; Type: DATABASE\b)","vegbien",
4 
"(?<=\bDATABASE )vegbank","vegbien",
5 
"(?<=\\connect )vegbank","vegbien",
6 
"vegbank","bien",
mappings/VegBank-VegBIEN.csv
1 1 
"VegBank","VegBIEN","Comments"
2 
,,"SQL script"
3 
" (?:LC_COLLATE|LC_CTYPE) = '.*?'",,"support PostgreSQL before 8.4"
4 
"vegbank(?=; Type: DATABASE\b)","vegbien",
5 
"(?<=\bDATABASE )vegbank","vegbien",
6 
"(?<=\\connect )vegbank","vegbien",
7 
"vegbank","bien",
8 2 
,,"table renames"
9 3 
"observation","plotevent",
10 4 
"taxonobservation","taxonoccurrence",
mappings/Makefile
17 17 

  		




  18
  18
  
    
VegBank-VegBIEN: schemas/vegbien.sql VegX-VegBIEN.organisms.csv


  		




  19
  19
  
    

  		




  20
  
  
    
repl = ../scripts/util/repl <$< VegBank-VegBIEN.csv$(if $(filter %.csv,$<), 1) \


  		




  21
  
  
    
>$@


  		




  
  20
  
    
repl = ../scripts/util/repl


  		




  22
  21
  
    

  		




  23
  22
  
    
schemas/vegbien.sql: schemas/vegbank.sql


  		




  24
  
  
    
	$(repl)


  		




  
  23
  
    
	$(repl) <$< VegBank-VegBIEN.schema.csv|$(repl) VegBank-VegBIEN.csv >$@


  		




  25
  24
  
    

  		




  26
  25
  
    
VegX-VegBIEN.organisms.csv: VegX-VegBank.organisms.csv


  		




  27
  
  
    
	$(repl)


  		




  
  26
  
    
	$(repl) <$< VegBank-VegBIEN.csv 1 >$@


  		




  28
  27
  
    

  		




  29
  28
  
    

  		




  30
  29
  
    
plots: $(subst .organisms.,.plots.,$(wildcard VegX-*.organisms.csv))


  		












Also available in:  Unified diff