-rw-r--r-- | src/controller/selection_to_db.sqc | 41 |
1 files changed, 0 insertions, 41 deletions
diff --git a/src/controller/selection_to_db.sqc b/src/controller/selection_to_db.sqc deleted file mode 100644 index 0d7de7f..0000000 --- a/src/controller/selection_to_db.sqc +++ b/dev/null @@ -1,41 +0,0 @@ -#include "selection_to_db.h" -#include "../view/exp004state0.h" -#include <string.h> -#include "../util/check_error.h" -#include "sqlca.h" -extern struct sqlca 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; - check_error (__FILE__, __LINE__); - - 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; - check_error (__FILE__, __LINE__); - - return; -} |