| 1 |
702
|
aaronmk
|
Installation:
|
| 2 |
|
|
Install: make install
|
| 3 |
|
|
Uninstall: make uninstall
|
| 4 |
|
|
Warning: This will delete your VegBIEN DB!
|
| 5 |
554
|
aaronmk
|
|
| 6 |
702
|
aaronmk
|
Data import:
|
| 7 |
703
|
aaronmk
|
Import data into VegBIEN: make import &
|
| 8 |
|
|
Empty the DB: make empty_db
|
| 9 |
|
|
Re-import data: make empty_db import &
|
| 10 |
554
|
aaronmk
|
|
| 11 |
702
|
aaronmk
|
Schema changes:
|
| 12 |
|
|
Regenerate schema from installed DB: make schemas/remake
|
| 13 |
|
|
Reinstall DB from schema: make reinstall_db
|
| 14 |
|
|
Sync ERD with vegbien.sql schema:
|
| 15 |
|
|
Run make schemas/vegbien.my.sql
|
| 16 |
|
|
Open schemas/vegbien.ERD.mwb in MySQLWorkbench
|
| 17 |
|
|
Go to File > Export > Synchronize With SQL CREATE Script...
|
| 18 |
|
|
For Input File, select schemas/vegbien.my.sql
|
| 19 |
|
|
Click Continue
|
| 20 |
|
|
Click in the changes list and press Ctrl+A or Apple+A to select all
|
| 21 |
|
|
Click Update Model
|
| 22 |
|
|
Click Continue
|
| 23 |
|
|
Note: The generated SQL script will be empty because we are syncing in
|
| 24 |
|
|
the opposite direction
|
| 25 |
|
|
Click Execute
|
| 26 |
|
|
Reposition any lines that have been reset
|
| 27 |
|
|
Add any new tables by dragging them from the Catalog in the left sidebar
|
| 28 |
|
|
to the diagram
|
| 29 |
|
|
Remove any deleted tables by right-clicking the table's diagram element,
|
| 30 |
|
|
selecting Delete '<table name>', and clicking Delete
|
| 31 |
|
|
Save
|
| 32 |
|
|
Go to File > Export > Export as PNG...
|
| 33 |
|
|
Select schemas/vegbien.ERD.png
|
| 34 |
|
|
Go to File > Export > Export as SVG...
|
| 35 |
|
|
Select schemas/vegbien.ERD.svg
|
| 36 |
|
|
Go to File > Export > Export as Single Page PDF...
|
| 37 |
|
|
Select schemas/vegbien.ERD.pdf
|
| 38 |
203
|
aaronmk
|
|
| 39 |
702
|
aaronmk
|
Testing:
|
| 40 |
|
|
Data source tests: make test2
|
| 41 |
|
|
Unit tests (will eventually be merged into test2 above): make test
|
| 42 |
|
|
|
| 43 |
|
|
General:
|
| 44 |
|
|
To see a program's description, read its top-of-file comment
|
| 45 |
|
|
To see a program's usage, run it without arguments
|
