11 files changed, 385 insertions, 0 deletions

diff --git a/src/controller/selection_to_db.sqc b/src/controller/selection_to_db.sqc
new file mode 100644
index 0000000..a6c91b9
--- a/dev/null
+++ b/src/controller/selection_to_db.sqc
@@ -0,0 +1,38 @@
+#include "selection_to_db.h"
+#include "../view/exp004state0.h"
+#include <string.h>
+
+EXEC SQL INCLUDE sqlca;
+
+/*
+ * A simple alias to make the code more readable.
+ */
+#define S exp004state0
+
+void
+selection_to_db (void)
+{
+  EXEC SQL BEGIN DECLARE SECTION;
+  char gi[255];
+  EXEC SQL END DECLARE SECTION;
+
+  /*
+   * WHERE gi IS NOT NULL is added to prevent the PRECOMPILE command
+   * from throwing a warning about modifying an entire table.  Since
+   * gi is defined as NOT NULL this will clear the entire table.
+   */
+  EXEC SQL DELETE FROM vis_selection WHERE gi IS NOT NULL;
+  
+  for (unsigned int i = 0; i < ROWS; i++)
+    {
+      if (S.selection[i] == true)
+        {
+          strncpy (gi, S.gi_data[i] + 3, sizeof(gi));
+          EXEC SQL INSERT INTO vis_selection VALUES (:gi);
+        }
+    }
+
+  EXEC SQL COMMIT;
+
+  return;
+}