Debian Codegraph @

src/interfaces/ecpg/test/sql/binary.pgc

raw
1 #include <stdio.h>
2 #include <stdlib.h>
3
4 EXEC SQL include ../regression;
5
6 EXEC SQL BEGIN DECLARE SECTION;
7 struct TBempl
8 {
9 long idnum;
10 char name[21];
11 short accs;
12 char byte[20];
13 };
14 EXEC SQL END DECLARE SECTION;
15
16 EXEC SQL WHENEVER SQLERROR STOP;
17
18 int
19 main (void)
20 {
21 EXEC SQL BEGIN DECLARE SECTION;
22 struct TBempl empl;
23 char *pointer = NULL;
24 char *data = "\\001\\155\\000\\212";
25 EXEC SQL END DECLARE SECTION;
26 int i;
27
28 ECPGdebug (1, stderr);
29
30 empl.idnum = 1;
31 EXEC SQL connect to REGRESSDB1;
32 EXEC SQL set bytea_output = escape;
33 EXEC SQL create table empl
34 (idnum integer, name char (20), accs smallint, byte bytea);
35 EXEC SQL insert into empl values (1, 'first user', 320, :data);
36 EXEC SQL DECLARE C CURSOR FOR select name, accs, byte from empl where idnum =:empl.idnum;
37 EXEC SQL OPEN C;
38 EXEC SQL FETCH C INTO:empl.name,:empl.accs,:empl.byte;
39 printf ("name=%s, accs=%d byte=%s\n", empl.name, empl.accs, empl.byte);
40
41 EXEC SQL CLOSE C;
42
43 memset(empl.name, 0, 21L);
44 EXEC SQL DECLARE B BINARY CURSOR FOR select name, accs, byte from empl where idnum =:empl.idnum;
45 EXEC SQL OPEN B;
46 EXEC SQL FETCH B INTO :empl.name,:empl.accs,:empl.byte;
47 EXEC SQL CLOSE B;
48
49 /* do not print a.accs because big/little endian will have different outputs here */
50 printf ("name=%s, byte=", empl.name);
51 for (i=0; i<4; i++)
52 printf("(%o)", (unsigned char)empl.byte[i]);
53 printf("\n");
54
55 EXEC SQL DECLARE A BINARY CURSOR FOR select byte from empl where idnum =:empl.idnum;
56 EXEC SQL OPEN A;
57 EXEC SQL FETCH A INTO :pointer;
58 EXEC SQL CLOSE A;
59
60 if (pointer) {
61 printf ("pointer=");
62 for (i=0; i<4; i++)
63 printf("(%o)", (unsigned char)pointer[i]);
64 printf("\n");
65 free(pointer);
66 }
67
68 EXEC SQL disconnect;
69 exit (0);
70 }