bmsd/mysql.h@544d7d0183b2
bmsd/mysql.h
Sun, 02 Jun 2019 12:48:54 +0200
- author
- Michiel Broek <mbroek@mbse.eu>
- date
- Sun, 02 Jun 2019 12:48:54 +0200
- changeset 392
- 544d7d0183b2
- parent 194
- d202777ebae5
- child 405
- ef3f0274a1ea
- permissions
- -rw-r--r--
Added 15 fields to the recipes table. Added 18 fields to the products table. These are calculated values that are now stored in the database so export programs can use these values without calculating them again. Product and recipe print have water and mash schedule added. Product print has brewday results added if the brewday is over. The ingredients layout changed in the product and recipe prints.
/** * @file mysql.h */ #ifndef _MYSQL_H #define _MYSQL_H /** * @brief Connect to the MySQL server and select the database. All parameters must be * set in the $HOME/.bms/bms.conf file. * @return 0 if success, any other value if the connection failed. */ int bms_mysql_init(void); /** * @brief Close MySQL connection and free resources. */ void bms_mysql_end(void); /** * @brief Ping MySQL connection and try to reconnect if the connection is broken. */ void bms_mysql_ping(void); void node_mysql_insert(sys_node_list *node); void node_mysql_update(sys_node_list *node); void node_mysql_death(char *node); void fermenter_mysql_insert(sys_fermenter_list *fermenter); void fermenter_mysql_update(sys_fermenter_list *fermenter); void fermenter_mysql_death(char *node, char *alias); #endif
