Project

General

Profile

« Previous | Next » 

Revision 4429

Added by Aaron Marcuse-Kubitza over 12 years ago

input.Makefile: Staging tables installation: Also translate MySQL data to PostgreSQL

View differences:

input.Makefile
191 191 
	($(inDatasrc); cat $+|grep -vF 'SET search_path')|"time" $(psqlAsBien)
192 192 

  		




  193
  193
  
    
# The export must be created with:


  		




  194
  
  
    
# `--compatible=postgresql --add-locks=false --set-charset`


  		




  
  194
  
    
# `--compatible=postgresql --add-locks=false --set-charset --no-data`


  		




  195
  195
  
    
%.schema.sql: _MySQL/%.schema.sql


  		




  196
  196
  
    
	$(bin)/my2pg <$< >$@


  		




  197
  197
  
    

  		




  
  198
  
    
# The export must be created with:


  		




  
  199
  
    
# `--compatible=postgresql --add-locks=false --set-charset --no-create-info`


  		




  
  200
  
    
%.data.sql: _MySQL/%.data.sql


  		




  
  201
  
    
	$(bin)/my2pg.data <$< >$@


  		




  
  202
  
    

  		




  198
  203
  
    
# For staging tables which are derived by joining together other staging tables.


  		




  199
  204
  
    
%/install %/header.csv: %/create.sql _always


  		




  200
  205
  
    
	($(inDatasrc); echo 'CREATE TABLE "$*" AS'; cat $<; echo ';'; \


  		












Also available in:  Unified diff