Wed, 03 Aug 2022 17:24:05 +0200
Phase 4, yeasts as a viewer.
0 | 1 | /** |
2 | * @file mysql.h | |
3 | */ | |
4 | #ifndef _MYSQL_H | |
5 | #define _MYSQL_H | |
6 | ||
7 | ||
8 | /** | |
9 | * @brief Connect to the MySQL server and select the database. All parameters must be | |
10 | * set in the $HOME/.bms/bms.conf file. | |
11 | * @return 0 if success, any other value if the connection failed. | |
12 | */ | |
13 | int bms_mysql_init(void); | |
14 | ||
15 | /** | |
16 | * @brief Close MySQL connection and free resources. | |
17 | */ | |
18 | void bms_mysql_end(void); | |
19 | ||
20 | /** | |
405
ef3f0274a1ea
Added a private mysql_query function that does try to reconnect a lost MySQL connection.
Michiel Broek <mbroek@mbse.eu>
parents:
194
diff
changeset
|
21 | * @brief Send query to the MySQL server with one reconnect attempt. |
ef3f0274a1ea
Added a private mysql_query function that does try to reconnect a lost MySQL connection.
Michiel Broek <mbroek@mbse.eu>
parents:
194
diff
changeset
|
22 | * @param query The SQL query to send. |
ef3f0274a1ea
Added a private mysql_query function that does try to reconnect a lost MySQL connection.
Michiel Broek <mbroek@mbse.eu>
parents:
194
diff
changeset
|
23 | * @return Return 0 if no error, else the error code. |
ef3f0274a1ea
Added a private mysql_query function that does try to reconnect a lost MySQL connection.
Michiel Broek <mbroek@mbse.eu>
parents:
194
diff
changeset
|
24 | */ |
ef3f0274a1ea
Added a private mysql_query function that does try to reconnect a lost MySQL connection.
Michiel Broek <mbroek@mbse.eu>
parents:
194
diff
changeset
|
25 | int bms_mysql_query(const char *query); |
ef3f0274a1ea
Added a private mysql_query function that does try to reconnect a lost MySQL connection.
Michiel Broek <mbroek@mbse.eu>
parents:
194
diff
changeset
|
26 | |
0 | 27 | void node_mysql_insert(sys_node_list *node); |
28 | void node_mysql_update(sys_node_list *node); | |
29 | void node_mysql_death(char *node); | |
30 | ||
31 | void fermenter_mysql_insert(sys_fermenter_list *fermenter); | |
32 | void fermenter_mysql_update(sys_fermenter_list *fermenter); | |
33 | void fermenter_mysql_death(char *node, char *alias); | |
34 | ||
502
a8a6901b5a99
Added CO2 meter units to the daemon.
Michiel Broek <mbroek@mbse.eu>
parents:
405
diff
changeset
|
35 | void co2meter_mysql_insert(sys_co2meter_list *co2meter); |
a8a6901b5a99
Added CO2 meter units to the daemon.
Michiel Broek <mbroek@mbse.eu>
parents:
405
diff
changeset
|
36 | void co2meter_mysql_update(sys_co2meter_list *co2meter); |
a8a6901b5a99
Added CO2 meter units to the daemon.
Michiel Broek <mbroek@mbse.eu>
parents:
405
diff
changeset
|
37 | void co2meter_mysql_death(char *node, char *alias); |
a8a6901b5a99
Added CO2 meter units to the daemon.
Michiel Broek <mbroek@mbse.eu>
parents:
405
diff
changeset
|
38 | |
567
6bf0afc33e70
Initial code for iSpindel support in the daemon
Michiel Broek <mbroek@mbse.eu>
parents:
502
diff
changeset
|
39 | void ispindel_mysql_insert(sys_ispindel_list *ispindel); |
6bf0afc33e70
Initial code for iSpindel support in the daemon
Michiel Broek <mbroek@mbse.eu>
parents:
502
diff
changeset
|
40 | void ispindel_mysql_update(sys_ispindel_list *ispindel); |
6bf0afc33e70
Initial code for iSpindel support in the daemon
Michiel Broek <mbroek@mbse.eu>
parents:
502
diff
changeset
|
41 | void ispindel_mysql_death(char *alias); |
0 | 42 | |
579
1253a237b620
Added check for database changes for iSpindels such as a new beer, or changing mode. Added denity in Plato and SG to the iSpindel web screen. The iSpindels must be calibrated in Plato! A bit of documentation updated.
Michiel Broek <mbroek@mbse.eu>
parents:
567
diff
changeset
|
43 | |
0 | 44 | #endif |