# HG changeset patch
# User Michiel Broek <mbroek@mbse.eu>
# Date 1618325725 -7200
# Node ID d3d8e3b30a34eb7654dbc67518898b9d7b88f476
# Parent  23d972f5d784d2ddbd32168c3d528bca57bd6871
Use mariadb JSON support for mash and fermentation profiles.

diff -r 23d972f5d784 -r d3d8e3b30a34 www/includes/db_profile_fermentation.php
--- a/www/includes/db_profile_fermentation.php	Tue Apr 13 16:54:26 2021 +0200
+++ b/www/includes/db_profile_fermentation.php	Tue Apr 13 16:55:25 2021 +0200
@@ -10,8 +10,6 @@
 }
 mysqli_set_charset($connect, "utf8" );
 
-$escapers = array("\\", "/", "\"", "\n", "\r", "\t", "\x08", "\x0c");
-$replacements = array("\\\\", "\\/", "\\\"", "\\n", "\\r", "\\t", "\\f", "\\b");
 $rescapers = array("'");
 $rreplacements = array("\\'");
 
@@ -90,7 +88,8 @@
 
 } else {
 	// SELECT COMMAND
-	$query = "SELECT * FROM profile_fermentation ORDER BY name;";
+	$query = "SELECT record,JSON_QUOTE(uuid),JSON_QUOTE(name),inittemp_lo,inittemp_hi,fridgemode,totalsteps,duration,steps ";
+	$query .= "FROM profile_fermentation ORDER BY name;";
 	$result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect));
 	$profiles = '[';
 	$comma = FALSE;
@@ -101,9 +100,9 @@
 		}
 		$comma = TRUE;
 		$profiles .= '{"record":' . $row['record'];
-		$profiles .= ',"uuid":"' . $row['uuid'];
-		$profiles .= '","name":"'  . str_replace($escapers, $replacements, $row['name']);
-		$profiles .= '","inittemp_lo":' . $row['inittemp_lo'];
+		$profiles .= ',"uuid":' . $row['JSON_QUOTE(uuid)'];
+		$profiles .= ',"name":'  . $row['JSON_QUOTE(name)'];
+		$profiles .= ',"inittemp_lo":' . $row['inittemp_lo'];
 		$profiles .= ',"inittemp_hi":' . $row['inittemp_hi'];
 		$profiles .= ',"fridgemode":' . $row['fridgemode'];
 		$profiles .= ',"totalsteps":' . $row['totalsteps'];
diff -r 23d972f5d784 -r d3d8e3b30a34 www/includes/db_profile_mash.php
--- a/www/includes/db_profile_mash.php	Tue Apr 13 16:54:26 2021 +0200
+++ b/www/includes/db_profile_mash.php	Tue Apr 13 16:55:25 2021 +0200
@@ -10,11 +10,8 @@
 }
 mysqli_set_charset($connect, "utf8" );
 
-$escapers = array("\\", "/", "\"", "\n", "\r", "\t", "\x08", "\x0c");
-$replacements = array("\\\\", "\\/", "\\\"", "\\n", "\\r", "\\t", "\\f", "\\b");
 $rescapers = array("'");
 $rreplacements = array("\\'");
-$disallowed = array('visibleindex','uniqueid','boundindex','uid');
 
 if (isset($_POST['insert']) || isset($_POST['update'])) {
 	if (isset($_POST['insert'])) {
@@ -79,7 +76,7 @@
 
 } else {
 	// SELECT COMMAND
-	$query = "SELECT * FROM profile_mash ORDER BY name";
+	$query = "SELECT record,JSON_QUOTE(name),JSON_QUOTE(notes),steps FROM profile_mash ORDER BY name";
 	$result = mysqli_query($connect, $query) or die("SQL Error 1: " . mysqli_error($connect));
 	$mashprofiles = '[';
 	$comma = FALSE;
@@ -89,11 +86,12 @@
 			$mashprofiles .= ',';
 		}
 		$comma = TRUE;
-		$mashprofiles .= '{"record":' . $row['record'];
-	        $mashprofiles .= ',"name":"'  . str_replace($escapers, $replacements, $row['name']);
-		$mashprofiles .= '","notes":"' . str_replace($escapers, $replacements, $row['notes']);
-		$mashprofiles .= '","steps":' . $row['steps'];
-		$mashprofiles .= '}';
+		$mashprofile  = '{"record":' . $row['record'];
+		$mashprofile .= ',"name":'  . $row['JSON_QUOTE(name)'];
+		$mashprofile .= ',"notes":' . $row['JSON_QUOTE(notes)'];
+		$mashprofile .= ',"steps":' . $row['steps'] . '}';
+//syslog(LOG_NOTICE, $mashprofile);
+		$mashprofiles .= $mashprofile;
 	}
 	$mashprofiles .= ']';
 	header("Content-type: application/json");