Project

General

Profile

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: make test
40

    
41
General:
42
    To see a program's description, read its top-of-file comment
43
    To see a program's usage, run it without arguments
(2-2/3)