|
1
|
Installation:
|
|
2
|
Install: make install
|
|
3
|
Uninstall: make uninstall
|
|
4
|
Warning: This will delete your VegBIEN DB!
|
|
5
|
|
|
6
|
Data import:
|
|
7
|
Import data into VegBIEN: make import &
|
|
8
|
Empty the DB: make empty_db
|
|
9
|
Re-import data: make empty_db import &
|
|
10
|
|
|
11
|
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
|
|
|
39
|
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
|
