From 4459e82efa9e8f52e52b03ac01bd865fc38babd0 Mon Sep 17 00:00:00 2001 From: Don Pellegrino Date: Sat, 13 Jun 2009 21:50:12 +0000 Subject: Added use of database. --- diff --git a/src/controller/clear_selection.h b/src/controller/clear_selection.h new file mode 100644 index 0000000..c57e358 --- a/dev/null +++ b/src/controller/clear_selection.h @@ -0,0 +1,6 @@ +#ifndef CLEAR_SELECTION_H +#define CLEAR_SELECTION_H + +void clear_selection (void); + +#endif // CLEAR_SELECTION_H diff --git a/src/controller/clear_selection.sqc b/src/controller/clear_selection.sqc new file mode 100644 index 0000000..cf04681 --- a/dev/null +++ b/src/controller/clear_selection.sqc @@ -0,0 +1,45 @@ +/* I seem to need this for glGenBuffers as per + http://www.gamedev.net/community/forums/topic.asp?topic_id=422358 */ +#define GL_GLEXT_PROTOTYPES + +#include "clear_selection.h" +#include "../view/exp004state0.h" +#include + +EXEC SQL INCLUDE sqlca; + +/* + * A simple alias to make the code more readable. + */ +#define S exp004state0 + +void +clear_selection (void) +{ + /* + * 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; + + EXEC SQL COMMIT; + + for (unsigned int i = 0; i < ROWS; i++) + { + S.selection[i] = false; + S.base_colors_data[i][0] = DEFAULT_COLOR_R; + S.base_colors_data[i][1] = DEFAULT_COLOR_G; + S.base_colors_data[i][2] = DEFAULT_COLOR_B; + } + + glBindBuffer (GL_ARRAY_BUFFER, S.buffers[BASE_COLORS]); + glColorPointer (3, GL_FLOAT, 0, 0); + glBufferData (GL_ARRAY_BUFFER, + sizeof (S.base_colors_data), S.base_colors_data, + GL_STATIC_DRAW); + + glutPostRedisplay (); + + return; +} diff --git a/src/controller/keyboard.c b/src/controller/keyboard.c new file mode 100644 index 0000000..c6e3c48 --- a/dev/null +++ b/src/controller/keyboard.c @@ -0,0 +1,28 @@ +#include "keyboard.h" +#include "clear_selection.h" +#include "selection_from_db.h" + +void +keyboard (unsigned char key, int x, int y) +{ + switch (key) + { + case 27: + /* + * ESC Pressed. + */ + clear_selection (); + break; + + case 'g': + /* + * g has been pressed. This is used to load a selection from + * the database since it is the convention to use g for + * refreshing a buffer in Emacs. + */ + selection_from_db (); + break; + } + + return; +} diff --git a/src/controller/keyboard.h b/src/controller/keyboard.h new file mode 100644 index 0000000..c01fc5f --- a/dev/null +++ b/src/controller/keyboard.h @@ -0,0 +1,6 @@ +#ifndef KEYBOARD_H +#define KEYBOARD_H + +void keyboard (unsigned char key, int x, int y); + +#endif // KEYBOARD_H diff --git a/src/controller/selection_from_db.h b/src/controller/selection_from_db.h new file mode 100644 index 0000000..8f0d8a2 --- a/dev/null +++ b/src/controller/selection_from_db.h @@ -0,0 +1,9 @@ +#ifndef SELECTION_FROM_DB_H +#define SELECTION_FROM_DB_H + +/* + * Read a selection from the database into memory. + */ +void selection_from_db (void); + +#endif // SELECTION_FROM_DB_H diff --git a/src/controller/selection_from_db.sqc b/src/controller/selection_from_db.sqc new file mode 100644 index 0000000..20d277e --- a/dev/null +++ b/src/controller/selection_from_db.sqc @@ -0,0 +1,21 @@ +#include "selection_from_db.h" +#include "../view/exp004state0.h" + +EXEC SQL INCLUDE sqlca; + +/* + * A simple alias to make the code more readable. + */ +#define S exp004state0 + +void +selection_from_db (void) +{ + EXEC SQL BEGIN DECLARE SECTION; + + EXEC SQL END DECLARE SECTION; + + + + return; +} diff --git a/src/controller/selection_to_db.h b/src/controller/selection_to_db.h new file mode 100644 index 0000000..4344e0b --- a/dev/null +++ b/src/controller/selection_to_db.h @@ -0,0 +1,9 @@ +#ifndef SELECTION_TO_DB_H +#define SELECTION_TO_DB_H + +/* + * Send the current selection from memory to the database. + */ +void selection_to_db (void); + +#endif // SELECTION_TO_DB_H 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 + +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; +} diff --git a/src/model/exp004base.sqc b/src/model/exp004base.sqc new file mode 100644 index 0000000..6189b72 --- a/dev/null +++ b/src/model/exp004base.sqc @@ -0,0 +1,144 @@ +/* I seem to need this for glGenBuffers as per + http://www.gamedev.net/community/forums/topic.asp?topic_id=422358 */ +#define GL_GLEXT_PROTOTYPES + +#include "exp004base.h" +#include "../view/exp004state0.h" +#include +#include +#include + +EXEC SQL INCLUDE sqlca; + +/* + * A simple alias to make the code more readable. + */ +#define S exp004state0 + +void +exp004base (void) +{ + EXEC SQL CONNECT TO exp004; + + /* + * This implementation can be improved by mapping the video memory + * directly rather than loading into system memory and then copying + * into video memory. + */ + + /* + * db2dclgn -d exp004 -t coordinates + */ + EXEC SQL BEGIN DECLARE SECTION; + EXEC SQL INCLUDE 'model/coordinates.h'; + EXEC SQL END DECLARE SECTION; + + EXEC SQL DECLARE c2 CURSOR FOR + SELECT * FROM coordinates; + + EXEC SQL OPEN c2; + + /* + FILE* coords = + fopen ("/home/don/exp004/test/run20090514/run20090514.coords", "r"); + int i = 0; + */ + + /* + * Initialize the bounding box of the points. + */ + S.bb.min_x = 0.0; + S.bb.max_x = 0.0; + S.bb.min_y = 0.0; + S.bb.max_y = 0.0; + + // for (i = 0; i < ROWS; i++) + + EXEC SQL FETCH c2 INTO :coordinates; + while (sqlca.sqlcode != 100) + { + /* + fscanf (coords, "%s %f %f\n", + S.gi_data[i], + &S.base_vertices_data[i][0], + &S.base_vertices_data[i][1]); + */ + + int i = coordinates.coord_id; + + strncpy(S.gi_data[i], + coordinates.gi.data, + sizeof (S.gi_data[i])); + + S.base_vertices_data[i][0] = coordinates.x; + S.base_vertices_data[i][1] = coordinates.y; + + if (S.base_vertices_data[i][0] < S.bb.min_x) + S.bb.min_x = S.base_vertices_data[i][0]; + if (S.base_vertices_data[i][0] > S.bb.max_x) + S.bb.max_x = S.base_vertices_data[i][0]; + if (S.base_vertices_data[i][1] < S.bb.min_y) + S.bb.min_y = S.base_vertices_data[i][1]; + if (S.base_vertices_data[i][1] > S.bb.max_y) + S.bb.max_y = S.base_vertices_data[i][1]; + + /* + * Deselected by default. + */ + S.selection[i] = false; + + S.base_colors_data[i][0] = DEFAULT_COLOR_R; + S.base_colors_data[i][1] = DEFAULT_COLOR_G; + S.base_colors_data[i][2] = DEFAULT_COLOR_B; + + EXEC SQL FETCH c2 INTO :coordinates; + } + + EXEC SQL CLOSE c2; + + /* + fclose (coords); + */ + + /* + * Find the largest axis and use it to setup the projection. This + * is done to preserve the aspect ratio. The aspect ratio should be + * preserved since relative distance is a meaningful indicator in + * the map. + */ + + // Min of min x or min y. + if (S.bb.min_x <= S.bb.min_y) + S.ortho_min = S.bb.min_x; + else + S.ortho_min = S.bb.min_y; + S.ortho_min--; + + // Max of max x or max y. + if (S.bb.max_x >= S.bb.max_y) + S.ortho_max = S.bb.max_x; + else + S.ortho_max = S.bb.max_y; + S.ortho_max++; + + // Invert the y coordinate to match up with the LGL Java viewer. + for (int i = 0; i < ROWS; i++) + S.base_vertices_data[i][1] = + S.ortho_max - S.base_vertices_data[i][1]; + + glGenBuffers (2, S.buffers); + + glBindBuffer (GL_ARRAY_BUFFER, S.buffers[BASE_VERTICES]); + glVertexPointer (2, GL_FLOAT, 0, 0); + glBufferData (GL_ARRAY_BUFFER, + sizeof (S.base_vertices_data), S.base_vertices_data, + GL_STATIC_DRAW); + + glBindBuffer (GL_ARRAY_BUFFER, S.buffers[BASE_COLORS]); + glColorPointer (3, GL_FLOAT, 0, 0); + glBufferData (GL_ARRAY_BUFFER, + sizeof (S.base_colors_data), S.base_colors_data, + GL_STATIC_DRAW); + + return; +} diff --git a/src/util/pick_convert.c b/src/util/pick_convert.c new file mode 100644 index 0000000..baafcfb --- a/dev/null +++ b/src/util/pick_convert.c @@ -0,0 +1,50 @@ +#include "pick_convert.h" + +/* + * Width and height of a selection box about a single-click selection. + */ +#define N 3.0 + +void pick_convert (int select_x, int select_y, int x, int y, + double *c_x, double *c_y, double *w, double *h) +{ + /* + * Calculate X and the width. + */ + if (x > select_x) + { + *c_x = (x - select_x) / 2.0 + select_x; + *w = x - select_x; + } + else if (x < select_x) + { + *c_x = (select_x - x) / 2.0 + x; + *w = select_x - x; + } + else + { + *c_x = x; + *w = N; + } + + /* + * Calculate Y and the width. + */ + if (y > select_y) + { + *c_y = (y - select_y) / 2.0 + select_y; + *h = y - select_y; + } + else if (y < select_y) + { + *c_y = (select_y - y) / 2.0 + y; + *h = select_y - y; + } + else + { + *c_y = y; + *h = N; + } + + return; +} diff --git a/src/util/pick_convert.h b/src/util/pick_convert.h new file mode 100644 index 0000000..a532b6e --- a/dev/null +++ b/src/util/pick_convert.h @@ -0,0 +1,29 @@ +#ifndef PICK_CONVERT_H +#define PICK_CONVERT_H + +/* + * Convert bounding box coordinates to a center point and delta x and + * y coordinates. This function initially designed to convert a + * two-point mouse selection to the parameters needed for + * gluPickMatrix. + * + * select_x: X coordinate of point used to begin selection. + * + * select_y: Y coordinate of point used to begin selection. + * + * x: X coordinate of point used to end selection. + * + * y: Y coordinate of point used to end selection. + * + * c_x: X coordinate in the center of the picking region. + * + * c_y: Y coordinate in the center of the picking region. + * + * w: Width of the picking region. + * + * h: Height of the picking region. + */ +void pick_convert (int select_x, int select_y, int x, int y, + double *c_x, double *c_y, double *w, double *h); + +#endif // PICK_CONVERT_H -- cgit v0.8.3.1-22-g547a