path:
root/
src/
controller/
selection_from_db.sqc (
plain)
blob: 9467ab32f6683c07ff7e3b8fae0cfd4a3f860460
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
|
#define GL_GLEXT_PROTOTYPES
#include "selection_from_db.h"
#include "../view/exp004state0.h"
#include <GL/glut.h>
EXEC SQL INCLUDE sqlca;
/*
* A simple alias to make the code more readable.
*/
#define S exp004state0
void
selection_from_db (void)
{
/*
* db2dclgn -d exp004 -t vis_sel_set
*/
EXEC SQL BEGIN DECLARE SECTION;
EXEC SQL INCLUDE 'controller/vis_sel_set.h';
EXEC SQL END DECLARE SECTION;
EXEC SQL DECLARE c3 CURSOR FOR
SELECT * FROM vis_sel_set
ORDER BY title, id DESC;
EXEC SQL OPEN c3;
/*
* This loop currently assumes only one set in the table and does
* not use the title assigned to that set. This should be improved
* to allow the user to manage multiple sets by name.
*/
EXEC SQL FETCH c3 INTO :vis_sel_set;
while (sqlca.sqlcode != 100)
{
S.selection[vis_sel_set.id] = true;
S.base_colors_data[vis_sel_set.id][0] = vis_sel_set.r;
S.base_colors_data[vis_sel_set.id][1] = vis_sel_set.g;
S.base_colors_data[vis_sel_set.id][2] = vis_sel_set.b;
S.base_colors_data[vis_sel_set.id][3] = 0.6;
EXEC SQL FETCH c3 INTO :vis_sel_set;
}
EXEC SQL CLOSE c3;
EXEC SQL COMMIT;
/*
* Update the graphics memory.
*/
glBindBuffer (GL_ARRAY_BUFFER, S.buffers[BASE_COLORS]);
glColorPointer (4, GL_FLOAT, 0, 0);
glBufferData (GL_ARRAY_BUFFER,
sizeof (S.base_colors_data), S.base_colors_data,
GL_STATIC_DRAW);
glutPostRedisplay ();
return;
}
|
