Revision 10784
Added by Aaron Marcuse-Kubitza over 11 years ago
| README.TXT | ||
|---|---|---|
| 142 | 142 |
"assert sql.table_col_names(db, table) == header": |
| 143 | 143 |
Figure out which TNRS CSV columns have changed |
| 144 | 144 |
On local machine: |
| 145 |
Make the changes in inputs/.TNRS/schema.sql |
|
| 146 |
rm inputs/.TNRS/tnrs/header.csv |
|
| 147 |
make inputs/.TNRS/reinstall schema_only=1 |
|
| 148 |
make schemas/public/reinstall |
|
| 149 |
If there are errors "column ... does not exist", etc.: |
|
| 150 |
Make the necessary changes in schemas/vegbien.sql |
|
| 151 |
make schemas/public/reinstall |
|
| 145 |
Make the changes in the DB's TNRS and public schemas |
|
| 146 |
rm=1 inputs/.TNRS/schema.sql.run export_ |
|
| 152 | 147 |
make schemas/remake |
| 153 | 148 |
inputs/test_taxonomic_names/test_scrub |
| 154 |
In inputs/test_taxonomic_names/_scrub/TNRS.sql, copy the |
|
| 155 |
"COPY tnrs ..." statement to inputs/.TNRS/data.sql |
|
| 149 |
rm=1 inputs/.TNRS/data.sql.run export_ |
|
| 156 | 150 |
Commit |
| 157 | 151 |
On vegbiendev: |
| 158 | 152 |
If dropping a column, save the dependent views |
Also available in: Unified diff
/README.TXT: Full database import: fixing TNRS errors: updated instructions for new TNRS schema editing workflow