Project

General

Profile

« Previous | Next » 

Revision 4431

Added by Aaron Marcuse-Kubitza over 12 years ago

input.Makefile: Staging tables installation: MySQL exports: Run all non-data-only exports through my2pg, not just schema-only exports. This supports transforming a combined schema+data export.

View differences:

inputs/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 --no-data`


  		




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


  		




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


  		




  197
  
  
    

  		




  198
  
  
    
# The export must be created with:


  		




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


  		




  
  195
  
    
# Must come before `%.sql: _MySQL/%.sql` to override it


  		




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


  		




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


  		




  202
  198
  
    

  		




  
  199
  
    
# The export must be created with:


  		




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


  		




  
  201
  
    
# Add `--no-data` to create a schema-only export.


  		




  
  202
  
    
%.sql: _MySQL/%.sql


  		




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


  		




  
  204
  
    

  		




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


  		




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


  		




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


  		












Also available in:  Unified diff