# HG changeset patch
# User Michiel Broek <mbroek@mbse.eu>
# Date 1697369424 -7200
# Node ID af4a8649245e97ce0a53708acd71a7ce89544376
# Parent  7f2ec2bc9d2e1de4c53713c94129555bfda7d4b3
Added MySQL query example in the source.

diff -r 7f2ec2bc9d2e -r af4a8649245e src/CalibrateiSpindel.cpp
--- a/src/CalibrateiSpindel.cpp	Sat Oct 14 18:50:47 2023 +0200
+++ b/src/CalibrateiSpindel.cpp	Sun Oct 15 13:30:24 2023 +0200
@@ -21,6 +21,19 @@
 #include "polyfit.h"
 #include "MainWindow.h"
 
+/*
+ * The following MySQL query produces a table with historic real results:
+ *
+ * SELECT pr.code,
+ *        pr.og,
+ *        (SELECT angle FROM log_ispindel WHERE code=pr.code ORDER BY datetime LIMIT 1) as og_angle,
+ *        pr.fg,
+ *        (SELECT angle FROM log_ispindel WHERE code=pr.code ORDER BY datetime DESC LIMIT 1) as fg_angle
+ *   FROM products AS pr
+ *   WHERE pr.stage=11 AND pr.log_ispindel=1
+ *   ORDER BY pr.fg DESC
+ * ;
+ */
 
 
 CalibrateiSpindel::CalibrateiSpindel(int id, QWidget *parent) : QDialog(parent), ui(new Ui::CalibrateiSpindel)