Revision 4409
Added by Aaron Marcuse-Kubitza over 12 years ago
| input.Makefile | ||
|---|---|---|
| 177 | 177 |
|
| 178 | 178 |
# For staging tables which are derived by joining together other staging tables. |
| 179 | 179 |
%/install %/header.csv: %/create.sql _always |
| 180 |
(echo 'SET search_path TO "$(datasrc)";'; echo 'CREATE TABLE "$*" AS';\ |
|
| 181 |
cat $<; echo ';'; \ |
|
| 180 |
($(inDatasrc); echo 'CREATE TABLE "$*" AS'; cat $<; echo ';'; \ |
|
| 182 | 181 |
echo 'ALTER TABLE "$*" ADD COLUMN row_num serial NOT NULL PRIMARY KEY;'; \ |
| 183 | 182 |
echo 'VACUUM ANALYZE "$*";')|$(psqlAsBien) --echo-all |
| 184 | 183 |
(prefix=; . $(bin)/vegbien_dest; env schema=$(datasrc) table=$* \ |
| ... | ... | |
| 336 | 335 |
all += $(wildcard verify/*.out) |
| 337 | 336 |
|
| 338 | 337 |
%.ref: %.ref.sql |
| 339 |
(echo 'SET search_path TO "$(datasrc)";'; cat $<)|$(psqlExport) >$@
|
|
| 338 |
($(inDatasrc); cat $<)|$(psqlExport) >$@
|
|
| 340 | 339 |
|
| 341 | 340 |
##### Editing import |
| 342 | 341 |
|
Also available in: Unified diff
input.Makefile: Use $(inDatasrc) wherever its value was used