README.design

Tue, 22 Jan 2019 22:46:58 +0100

author
Michiel Broek <mbroek@mbse.eu>
date
Tue, 22 Jan 2019 22:46:58 +0100
changeset 196
531d5458782f
parent 195
2ac491548d8d
child 198
f0ec83e1e01f
permissions
-rw-r--r--

Hops database bool to int types. Dropdown lists are using tables with indexes. Dropdown lists display in Dutch. Save and delete in the database now use POST instead of GET. Removed the useat field. Redesigned the web page. Code cleanup.

0
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
1 Centrale daemon 'bmsd' regelt de dagelijkse berichten tussen MQTT en de
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
2 database. Om deze berichten betrouwbaar af te handelen is MQTT er tussen
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
3 gezet.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
4 Alle sensoren en controllers communiceren uitsluitend via MQTT.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
5
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
6 Sensoren en controllers:
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
7
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
8 1. Vergisting controllers.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
9 2. Temperatuur loggen.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
10 3. Hergisting drukmeters. (druk + temp).
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
11 4. Brouw controllers.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
12 5. Ispindel.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
13
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
14
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
15 Stappen:
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
16
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
17 1. Importeren oude vergisting en brouw logs. DONE.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
18 2. Thermferm moet DLOG berichten gaan sturen, per wijziging en per 5 minuten. DONE.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
19 3. bmsd moet deze DLOG berichten verwerken. Versie 0.0.2. Bier producten in database. DONE.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
20 4. Versie 0.0.2 handmatig installeren op productie. DONE.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
21 5. Thermferm uitbreiden met vergisting stage. DONE.
104
0c6ad9e0f143 Updated ideas
Michiel Broek <mbroek@mbse.eu>
parents: 63
diff changeset
22 6. Brouw controller uitbreiden met MQTT. Niet, ESP32 wordt onstabiel.
0c6ad9e0f143 Updated ideas
Michiel Broek <mbroek@mbse.eu>
parents: 63
diff changeset
23 7. bmsd uitbreiden met brouw controller berichten. Niet, zie hierboven.
0c6ad9e0f143 Updated ideas
Michiel Broek <mbroek@mbse.eu>
parents: 63
diff changeset
24 8. bmsd productie platform upgraden, versie 0.0.3 DONE.
0c6ad9e0f143 Updated ideas
Michiel Broek <mbroek@mbse.eu>
parents: 63
diff changeset
25 9. bmsd recepten editor implementeren, geschikt voor enkel recepten en productie.
0c6ad9e0f143 Updated ideas
Michiel Broek <mbroek@mbse.eu>
parents: 63
diff changeset
26 10. bmsd uitbreiden met productie stappen, met hieraan productie recepten.
0c6ad9e0f143 Updated ideas
Michiel Broek <mbroek@mbse.eu>
parents: 63
diff changeset
27 11. bmsd koppelen logs aan productie.
0c6ad9e0f143 Updated ideas
Michiel Broek <mbroek@mbse.eu>
parents: 63
diff changeset
28
0
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
29
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
30
54
294dda7f1779 Beginning of water totals and selecting
Michiel Broek <mbroek@mbse.eu>
parents: 40
diff changeset
31 Web interface bouwen met jqwidgets.
0
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
32
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
33
195
2ac491548d8d Fermentables database bool to int types. Dropdown lists are using tables with indexes. Dropdown lists display in Dutch. Save and delete in the database now use POST instead of GET. Added the added and dissolved_protein fields. Removed the ibu_gal_per_lb field. Redesigned the web page. Code cleanup.
Michiel Broek <mbroek@mbse.eu>
parents: 194
diff changeset
34 Database inventaris: Werking Maten Index/Strings Bool/Ints Utf-8 POST
2ac491548d8d Fermentables database bool to int types. Dropdown lists are using tables with indexes. Dropdown lists display in Dutch. Save and delete in the database now use POST instead of GET. Added the added and dissolved_protein fields. Removed the ibu_gal_per_lb field. Redesigned the web page. Code cleanup.
Michiel Broek <mbroek@mbse.eu>
parents: 194
diff changeset
35 ---------------------------- ------- ------- ------------- --------- ----- ----
29
a12d0a4d621e Some final patches
Michiel Broek <mbroek@mbse.eu>
parents: 27
diff changeset
36 inventory_equipments Ok. Ok.
196
531d5458782f Hops database bool to int types. Dropdown lists are using tables with indexes. Dropdown lists display in Dutch. Save and delete in the database now use POST instead of GET. Removed the useat field. Redesigned the web page. Code cleanup.
Michiel Broek <mbroek@mbse.eu>
parents: 195
diff changeset
37 inventory_fermentables Ok. Ok. Ok. Ok. Ok. Ok.
531d5458782f Hops database bool to int types. Dropdown lists are using tables with indexes. Dropdown lists display in Dutch. Save and delete in the database now use POST instead of GET. Removed the useat field. Redesigned the web page. Code cleanup.
Michiel Broek <mbroek@mbse.eu>
parents: 195
diff changeset
38 inventory_hops Ok. Ok. Ok. Ok. Ok. Ok.
21
acb2d8098f19 Added inventory miscs and water sources.
Michiel Broek <mbroek@mbse.eu>
parents: 20
diff changeset
39 inventory_miscs Ok.
34
a720353fada9 Formatting and measurements
Michiel Broek <mbroek@mbse.eu>
parents: 30
diff changeset
40 inventory_suppliers Ok. Ok.
54
294dda7f1779 Beginning of water totals and selecting
Michiel Broek <mbroek@mbse.eu>
parents: 40
diff changeset
41 inventory_water Ok. Ok.
34
a720353fada9 Formatting and measurements
Michiel Broek <mbroek@mbse.eu>
parents: 30
diff changeset
42 inventory_yeasts Ok. Ok.
195
2ac491548d8d Fermentables database bool to int types. Dropdown lists are using tables with indexes. Dropdown lists display in Dutch. Save and delete in the database now use POST instead of GET. Added the added and dissolved_protein fields. Removed the ibu_gal_per_lb field. Redesigned the web page. Code cleanup.
Michiel Broek <mbroek@mbse.eu>
parents: 194
diff changeset
43 profile_mash Ok. Ok.
2ac491548d8d Fermentables database bool to int types. Dropdown lists are using tables with indexes. Dropdown lists display in Dutch. Save and delete in the database now use POST instead of GET. Added the added and dissolved_protein fields. Removed the ibu_gal_per_lb field. Redesigned the web page. Code cleanup.
Michiel Broek <mbroek@mbse.eu>
parents: 194
diff changeset
44 profile_profiles Ok. Ok. Ok.
2ac491548d8d Fermentables database bool to int types. Dropdown lists are using tables with indexes. Dropdown lists display in Dutch. Save and delete in the database now use POST instead of GET. Added the added and dissolved_protein fields. Removed the ibu_gal_per_lb field. Redesigned the web page. Code cleanup.
Michiel Broek <mbroek@mbse.eu>
parents: 194
diff changeset
45 profile_styles Ok. Ok.
2ac491548d8d Fermentables database bool to int types. Dropdown lists are using tables with indexes. Dropdown lists display in Dutch. Save and delete in the database now use POST instead of GET. Added the added and dissolved_protein fields. Removed the ibu_gal_per_lb field. Redesigned the web page. Code cleanup.
Michiel Broek <mbroek@mbse.eu>
parents: 194
diff changeset
46 profile_water Ok. Ok.
2ac491548d8d Fermentables database bool to int types. Dropdown lists are using tables with indexes. Dropdown lists display in Dutch. Save and delete in the database now use POST instead of GET. Added the added and dissolved_protein fields. Removed the ibu_gal_per_lb field. Redesigned the web page. Code cleanup.
Michiel Broek <mbroek@mbse.eu>
parents: 194
diff changeset
47 recipes
2ac491548d8d Fermentables database bool to int types. Dropdown lists are using tables with indexes. Dropdown lists display in Dutch. Save and delete in the database now use POST instead of GET. Added the added and dissolved_protein fields. Removed the ibu_gal_per_lb field. Redesigned the web page. Code cleanup.
Michiel Broek <mbroek@mbse.eu>
parents: 194
diff changeset
48 products
18
395833e20f88 Better error messages in syslog
Michiel Broek <mbroek@mbse.eu>
parents: 0
diff changeset
49
21
acb2d8098f19 Added inventory miscs and water sources.
Michiel Broek <mbroek@mbse.eu>
parents: 20
diff changeset
50 Handelsmaten (een zooitje ongeregeld):
acb2d8098f19 Added inventory miscs and water sources.
Michiel Broek <mbroek@mbse.eu>
parents: 20
diff changeset
51 vergistbare ingredienten: Prijs per kilo, hoeveelheid in gram.
acb2d8098f19 Added inventory miscs and water sources.
Michiel Broek <mbroek@mbse.eu>
parents: 20
diff changeset
52 hoppen Prijs per ons, hoeveelheid in gram.
acb2d8098f19 Added inventory miscs and water sources.
Michiel Broek <mbroek@mbse.eu>
parents: 20
diff changeset
53 Kruiden Prijs per gram, hoeveelheden in gram.
acb2d8098f19 Added inventory miscs and water sources.
Michiel Broek <mbroek@mbse.eu>
parents: 20
diff changeset
54 Additieven Prijs per 100 ml, hoeveeheid in ml.
acb2d8098f19 Added inventory miscs and water sources.
Michiel Broek <mbroek@mbse.eu>
parents: 20
diff changeset
55 Water Prijs per liter of kuub, hoveelheden in liters.
acb2d8098f19 Added inventory miscs and water sources.
Michiel Broek <mbroek@mbse.eu>
parents: 20
diff changeset
56 Gist Prijs per gram / ml. hoeveelheden in gram/ml.
acb2d8098f19 Added inventory miscs and water sources.
Michiel Broek <mbroek@mbse.eu>
parents: 20
diff changeset
57
acb2d8098f19 Added inventory miscs and water sources.
Michiel Broek <mbroek@mbse.eu>
parents: 20
diff changeset
58 Alles naar standaard maten in de database en presentatie naar behoefte?
acb2d8098f19 Added inventory miscs and water sources.
Michiel Broek <mbroek@mbse.eu>
parents: 20
diff changeset
59 Opslag kilos, liter en Euros met veel cijfers achter de comma.
18
395833e20f88 Better error messages in syslog
Michiel Broek <mbroek@mbse.eu>
parents: 0
diff changeset
60
0
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
61 Database:
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
62
104
0c6ad9e0f143 Updated ideas
Michiel Broek <mbroek@mbse.eu>
parents: 63
diff changeset
63 1. Recepten opslaan standaard maar ingredienten in json formaat omdat dit flexibel is.
0c6ad9e0f143 Updated ideas
Michiel Broek <mbroek@mbse.eu>
parents: 63
diff changeset
64 2. Productie Brouwsels bevatten ook logs, en linken naar een extra recepten database (brews).
63
1d1e3002f26b Design update
Michiel Broek <mbroek@mbse.eu>
parents: 54
diff changeset
65 3. Inventaris ingredienten in MySQL. Voorraad historie is extra arrays.
0
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
66 4. Export naar beerxml.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
67 5. Import van brouwhulp xml met sync vanuit backup locatie.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
68 6. Brouwerij configuratie voornamelijk in json.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
69
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
70
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
71 MQTT structuur volgens Sparkplug model.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
72
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
73 mbv1.0/fermenters/[NBIRTH,DBIRTH]/<hostname>/
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
74 mbv1.0/fermenters/DDATA/<hostname>/<unitalias>/
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
75
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
76 ---------------------------------------------------------------------------
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
77
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
78 namespace/group_id/message_type/edge_node_id/{device_id}
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
79
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
80 namespace is de root, "mbv1.0"
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
81
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
82 group_id oa: fermenters, brewcontrol, env_sensor
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
83
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
84 message_type: NBIRTH - Birth certificate for MQTT EoN nodes.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
85 NDEATH - Death certificate for MQTT EoN nodes.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
86 NCMD - Node command message.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
87 DBIRTH - Birth certificate for devices.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
88 DDEATH - Death certificate for devices.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
89 NDATA - Node data message.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
90 DDATA - Device data message.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
91 DLOG - Device data logging.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
92 DCMD - Device command message.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
93 STATE - Critical application state message.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
94
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
95 NCMD: reboot (application restart)
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
96 rebirth
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
97
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
98 DCMD: fermenter state change + temperature settings.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
99 fermenter profile install.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
100 fermenter load product.
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
101 fermenter set stage
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
102
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
103
109
3c334f3ca7f9 Noted some ideas and added some in the menu.
Michiel Broek <mbroek@mbse.eu>
parents: 108
diff changeset
104 Product: code, uuid en naam.
3c334f3ca7f9 Noted some ideas and added some in the menu.
Michiel Broek <mbroek@mbse.eu>
parents: 108
diff changeset
105 Stage: Plan Wait Brew Primary Secondary Tertiary Package Carbonation Mature Taste Ready Closed
3c334f3ca7f9 Noted some ideas and added some in the menu.
Michiel Broek <mbroek@mbse.eu>
parents: 108
diff changeset
106 | | | | | |
3c334f3ca7f9 Noted some ideas and added some in the menu.
Michiel Broek <mbroek@mbse.eu>
parents: 108
diff changeset
107 | | | | | +------------- Log/rapport
3c334f3ca7f9 Noted some ideas and added some in the menu.
Michiel Broek <mbroek@mbse.eu>
parents: 108
diff changeset
108 | | | | +------------------------ rapport/etiketten
3c334f3ca7f9 Noted some ideas and added some in the menu.
Michiel Broek <mbroek@mbse.eu>
parents: 108
diff changeset
109 | +-------+---------+--------------------------------- Log/rapport
3c334f3ca7f9 Noted some ideas and added some in the menu.
Michiel Broek <mbroek@mbse.eu>
parents: 108
diff changeset
110 +--------------------------------------------------------- Log/rapport
0
033898178630 Versio 0.0.2 initial check in
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
111
174
12aacf0da982 Updated the README
Michiel Broek <mbroek@mbse.eu>
parents: 114
diff changeset
112 Main table: products.
12aacf0da982 Updated the README
Michiel Broek <mbroek@mbse.eu>
parents: 114
diff changeset
113 In progress: overview.
180
a5aa3502310c Updated README. Getfermenter and getnode scripts return 0 and 1 instead of false and true for boolean values. Global variable my_uuid added. Moved the javascript out of mon_fermenter.php. Added log chart view button in the fermenter monitor.
Michiel Broek <mbroek@mbse.eu>
parents: 174
diff changeset
114 In Progress: view charts. DONE fermenters, todo brewlogs.
174
12aacf0da982 Updated the README
Michiel Broek <mbroek@mbse.eu>
parents: 114
diff changeset
115 In Progress: view logs.
12aacf0da982 Updated the README
Michiel Broek <mbroek@mbse.eu>
parents: 114
diff changeset
116 In Progress: update state.
12aacf0da982 Updated the README
Michiel Broek <mbroek@mbse.eu>
parents: 114
diff changeset
117 In Progress: Tabbed screens. DONE.
12aacf0da982 Updated the README
Michiel Broek <mbroek@mbse.eu>
parents: 114
diff changeset
118 Start new: some sort of wizzard like a new recipe. DONE.
109
3c334f3ca7f9 Noted some ideas and added some in the menu.
Michiel Broek <mbroek@mbse.eu>
parents: 108
diff changeset
119 Archive: select via name/code/date.
3c334f3ca7f9 Noted some ideas and added some in the menu.
Michiel Broek <mbroek@mbse.eu>
parents: 108
diff changeset
120 Calendar: shows upcoming events.
174
12aacf0da982 Updated the README
Michiel Broek <mbroek@mbse.eu>
parents: 114
diff changeset
121 Recipes can be copied to 'recipes' or 'brews', imported from 'recipes'/'products' or created manual.
180
a5aa3502310c Updated README. Getfermenter and getnode scripts return 0 and 1 instead of false and true for boolean values. Global variable my_uuid added. Moved the javascript out of mon_fermenter.php. Added log chart view button in the fermenter monitor.
Michiel Broek <mbroek@mbse.eu>
parents: 174
diff changeset
122 Products recipes Beerxml import.
a5aa3502310c Updated README. Getfermenter and getnode scripts return 0 and 1 instead of false and true for boolean values. Global variable my_uuid added. Moved the javascript out of mon_fermenter.php. Added log chart view button in the fermenter monitor.
Michiel Broek <mbroek@mbse.eu>
parents: 174
diff changeset
123 Recipes Beerxml import.
106
c64d979613ab Prepare for production brews databases
Michiel Broek <mbroek@mbse.eu>
parents: 104
diff changeset
124
114
4935e86b2775 Small fixes for prject import from Brouwhulp. Fixes for poduct database read/write. New menu entries. Equipment select in product editor. Started brewday editor. Added conditions on some buttons and edit fields. Screen layout changes.
Michiel Broek <mbroek@mbse.eu>
parents: 109
diff changeset
125 Een cronjob om de Stage bij te werken in geval van Package .. Taste.
194
d202777ebae5 Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents: 180
diff changeset
126
d202777ebae5 Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents: 180
diff changeset
127 -----------------------------------------------------------------------------
d202777ebae5 Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents: 180
diff changeset
128
d202777ebae5 Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents: 180
diff changeset
129 Formaat csv vergisting logs.
d202777ebae5 Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents: 180
diff changeset
130
d202777ebae5 Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents: 180
diff changeset
131 Directory: www/logs/fermentation
d202777ebae5 Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents: 180
diff changeset
132 Filenaam: product_code\ product_name.log
d202777ebae5 Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents: 180
diff changeset
133
d202777ebae5 Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents: 180
diff changeset
134 2014-11-15 18:39,BEER,PRIMARY,20.312,19.750,-1.500,20.5,18.6,18.8,35,12345,0,67890,Whatsup,Fermenter
d202777ebae5 Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents: 180
diff changeset
135 | | | | | | | | | | | | | | |
d202777ebae5 Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents: 180
diff changeset
136 0 datetime + | | | | | | | | | | | | | |
d202777ebae5 Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents: 180
diff changeset
137 1 mode --------------+ | | | | | | | | | | | | |
d202777ebae5 Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents: 180
diff changeset
138 2 stage -------------------+ | | | | | | | | | | | |
d202777ebae5 Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents: 180
diff changeset
139 3 temp air -----------------------+ | | | | | | | | | | |
d202777ebae5 Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents: 180
diff changeset
140 4 temp beer -----------------------------+ | | | | | | | | | |
d202777ebae5 Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents: 180
diff changeset
141 5 temp chiller ---------------------------------+ | | | | | | | | |
d202777ebae5 Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents: 180
diff changeset
142 6 temp room -------------------------------------------+ | | | | | | | |
d202777ebae5 Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents: 180
diff changeset
143 7 setpoint low ---------------------------------------------+ | | | | | | |
d202777ebae5 Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents: 180
diff changeset
144 8 setpoint high -------------------------------------------------+ | | | | | |
d202777ebae5 Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents: 180
diff changeset
145 9 heater power ------------------------------------------------------+ | | | | |
d202777ebae5 Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents: 180
diff changeset
146 10 heater usage ----------------------------------------------------------+ | | | |
d202777ebae5 Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents: 180
diff changeset
147 11 cooler power --------------------------------------------------------------+ | | |
d202777ebae5 Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents: 180
diff changeset
148 12 cooler usage ------------------------------------------------------------------+ | |
d202777ebae5 Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents: 180
diff changeset
149 13 event --------------------------------------------------------------------------------+ |
d202777ebae5 Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents: 180
diff changeset
150 14 fermenter uuid --------------------------------------------------------------------------------+
d202777ebae5 Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents: 180
diff changeset
151
d202777ebae5 Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents: 180
diff changeset
152 De oude logs zijn geimporteerd en geconverteerd. Nieuwe worden geschreven
d202777ebae5 Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents: 180
diff changeset
153 door bmsd welke de log gegevens ontvangt via MQTT DLOG berichten.
d202777ebae5 Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents: 180
diff changeset
154 Vanwege de snelheid van verwerken staan de logs niet in de database.
d202777ebae5 Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents: 180
diff changeset
155
d202777ebae5 Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents: 180
diff changeset
156 -----------------------------------------------------------------------------
d202777ebae5 Added design notes for the csv log format from fermenters. In bmsd configuration added the web_root entry. Switched fermenter DLOG messages to store the log in flat csv files instead of the database. This is much faster and the graphs look better.
Michiel Broek <mbroek@mbse.eu>
parents: 180
diff changeset
157

mercurial