| 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 |
} |