Debian Codegraph @

src/interfaces/ecpg/test/preproc/outofscope.pgc

raw
1 #include <stdio.h>
2 #include <stdlib.h>
3 #include <string.h>
4 #include <limits.h>
5
6 exec sql include ../regression;
7
8 exec sql include pgtypes_numeric.h;
9
10 exec sql begin declare section;
11 exec sql include struct.h;
12 exec sql end declare section;
13
14 exec sql whenever sqlerror stop;
15
16 /* Functions for test 1 */
17
18 static void
19 get_var1(MYTYPE **myvar0, MYNULLTYPE **mynullvar0)
20 {
21 exec sql begin declare section;
22 MYTYPE *myvar = malloc(sizeof(MYTYPE));
23 MYNULLTYPE *mynullvar = malloc(sizeof(MYNULLTYPE));
24 exec sql end declare section;
25
26 /* Test DECLARE ... SELECT ... INTO with pointers */
27
28 exec sql declare mycur cursor for select * INTO :myvar :mynullvar from a1;
29
30 if (sqlca.sqlcode != 0)
31 exit(1);
32
33 *myvar0 = myvar;
34 *mynullvar0 = mynullvar;
35 }
36
37 static void
38 open_cur1(void)
39 {
40 exec sql open mycur;
41 }
42
43 static void
44 get_record1(void)
45 {
46 exec sql fetch mycur;
47 }
48
49 static void
50 close_cur1(void)
51 {
52 exec sql close mycur;
53 }
54
55 int
56 main (void)
57 {
58 MYTYPE *myvar;
59 MYNULLTYPE *mynullvar;
60 int loopcount;
61 char msg[128];
62
63 ECPGdebug(1, stderr);
64
65 strcpy(msg, "connect");
66 exec sql connect to REGRESSDB1;
67
68 strcpy(msg, "set");
69 exec sql set datestyle to iso;
70
71 strcpy(msg, "create");
72 exec sql create table a1(id serial primary key, t text, d1 numeric, d2 float8, c character(10));
73
74 strcpy(msg, "insert");
75 exec sql insert into a1(id, t, d1, d2, c) values (default, 'a', 1.0, 2, 'a');
76 exec sql insert into a1(id, t, d1, d2, c) values (default, null, null, null, null);
77 exec sql insert into a1(id, t, d1, d2, c) values (default, 'b', 2.0, 3, 'b');
78
79 strcpy(msg, "commit");
80 exec sql commit;
81
82 /* Test out-of-scope DECLARE/OPEN/FETCH/CLOSE */
83
84 get_var1(&myvar, &mynullvar);
85 open_cur1();
86
87 for (loopcount = 0; loopcount < 100; loopcount++)
88 {
89 memset(myvar, 0, sizeof(MYTYPE));
90 get_record1();
91 if (sqlca.sqlcode == ECPG_NOT_FOUND)
92 break;
93 printf("id=%d%s t='%s'%s d1=%f%s d2=%f%s c = '%s'%s\n",
94 myvar->id, mynullvar->id ? " (NULL)" : "",
95 myvar->t, mynullvar->t ? " (NULL)" : "",
96 myvar->d1, mynullvar->d1 ? " (NULL)" : "",
97 myvar->d2, mynullvar->d2 ? " (NULL)" : "",
98 myvar->c, mynullvar->c ? " (NULL)" : "");
99 }
100
101 close_cur1();
102
103 free(myvar);
104 free(mynullvar);
105
106 strcpy(msg, "drop");
107 exec sql drop table a1;
108
109 strcpy(msg, "commit");
110 exec sql commit;
111
112 strcpy(msg, "disconnect");
113 exec sql disconnect;
114
115 return 0;
116 }