Exemple #1
0
 public static string UpdateQuery(Watch watch)
 => $"UPDATE `watch` SET `name`='{watch.Name}', `expression`='{watch.Expression}', `message`='{watch.Message}', `sent`=b'{watch.Sent}' WHERE  `watchId`={watch.WatchId};";
Exemple #2
0
 public static string DeleteQuery(Watch watch)
 => $"DELETE FROM `watch` WHERE  `watchId`={watch.WatchId};";
Exemple #3
0
 public static string InsertQuery(Watch watch)
 => $"INSERT INTO `watch` (`metricId`, `name`, `expression`, `message`, `sent`) VALUES ('{watch.MetricId}', '{watch.Name}', '{watch.Expression}', '{watch.Message}', b'{watch.Sent}');";