Revision 356
Added by Aaron Marcuse-Kubitza almost 13 years ago
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", |
|
1 |
VegBank,VegBIEN,Comments |
|
2 |
,,table renames |
|
3 |
observation,plotevent, |
|
4 |
taxonobservation,taxonoccurrence, |
|
5 |
taxoninterpretation,taxondetermination, |
|
6 |
stemlocation,individual, |
|
7 |
taxonimportance,collectiveobs, |
|
8 |
stratum,taxonbin, |
|
9 |
(?:LC_COLLATE|LC_CTYPE) = '.*?',,support PostgreSQL before 8.4 |
|
10 |
vegbank(?=; Type: DATABASE\b),vegbien, |
|
11 |
(?<=\bDATABASE )vegbank,vegbien, |
|
12 |
(?<=\\connect )vegbank,vegbien, |
|
13 |
vegbank,bien, |
mappings/VegBank-VegBIEN.schema_only.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/Makefile | ||
---|---|---|
32 | 32 |
|
33 | 33 |
bin = ../bin |
34 | 34 |
in_place = $(bin)/in_place |
35 |
cat_csv = $(bin)/cat_csv |
|
35 | 36 |
repl = $(bin)/repl |
36 | 37 |
sort = $(bin)/sort 1 0 |
37 | 38 |
chRoot = $(bin)/ch_root <$< >$@ |
38 | 39 |
empty = $(SED) -n \ |
39 | 40 |
's/^CREATE TABLE ([0-9A-Za-z_]+) \($$/TRUNCATE \1 CASCADE;/p' <$< >$@ |
40 | 41 |
|
42 |
VegBank-VegBIEN.%.csv: VegBank-VegBIEN.csv VegBank-VegBIEN.%_only.csv |
|
43 |
$(bin)/cat_csv <$+ >$@ |
|
44 |
.PRECIOUS: VegBank-VegBIEN.%.csv |
|
45 |
|
|
41 | 46 |
schemas/vegbien.sql: schemas/vegbank.sql |
42 |
$(repl) <$< VegBank-VegBIEN.schema.csv|$(repl) VegBank-VegBIEN.csv >$@
|
|
47 |
$(repl) <$< VegBank-VegBIEN.schema.csv >$@ |
|
43 | 48 |
|
44 | 49 |
schemas/vegbien_empty.sql: schemas/vegbien.sql |
45 | 50 |
$(empty) |
Also available in: Unified diff
Generate VegBank-VegBIEN.schema.csv from VegBank-VegBIEN.schema_only.csv and VegBank-VegBIEN.csv