liquid_feedback_core
view README @ 1:23092eb00e16
Version beta2
Serious bugfix in SQL function create_snapshot(...), which caused wrong counting of opinions on suggestions
lf_update now deletes expired sessions
Redundancy in SQL function check_everything() removed by using existent views
Serious bugfix in SQL function create_snapshot(...), which caused wrong counting of opinions on suggestions
lf_update now deletes expired sessions
Redundancy in SQL function check_everything() removed by using existent views
| author | jbe |
|---|---|
| date | Tue Nov 03 12:00:00 2009 +0100 (2009-11-03) |
| parents | 8d021cb5eaf4 |
| children | e6faf5ff83af |
line source
2 Setup the database:
3 $ createdb liquid_feedback
4 $ psql -v ON_ERROR_STOP=1 -f core.sql liquid_feedback
6 Optionally insert demo data:
7 $ psql -v ON_ERROR_STOP=1 -f demo.sql liquid_feedback
9 Compile lf_update binary:
10 $ make
12 If you wish, copy the created lf_update file to /usr/local/bin or a
13 similar directory. Ensure that "lf_update dbname=liquid_feedback"
14 is called regularly. On successful run, lf_update will not produce
15 any output and exit with code 0.
17 NOTE: When writing to the database, some INSERTs must be executed
18 within the same transaction, e.g. issues can't exist without
19 an initiative and vice versa.
21 To uninstall the software, delete the lf_update binary
22 and drop the database by entering the following command:
23 $ dropdb liquid_feedback