Debian Codegraph @

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

raw
1 #include <stdlib.h>
2 #include <string.h>
3 #include <stdio.h>
4 #include <time.h>
5
6 exec sql include ../regression;
7 exec sql whenever sqlerror sqlprint;
8
9 static void
10 dump_binary(char *buf, int len, int ind)
11 {
12 int i;
13
14 printf("len=%d, ind=%d, data=0x", len, ind);
15 for (i = 0; i < len; ++i)
16 printf("%02x", 0xff & buf[i]);
17 printf("\n");
18 }
19
20 #define DATA_SIZE 0x200
21 #define LACK_SIZE 13
22 #
23 int
24 main(void)
25 {
26 exec sql begin declare section;
27 bytea send_buf[2][512];
28 bytea recv_buf[2][DATA_SIZE];
29 bytea recv_vlen_buf[][DATA_SIZE];
30 bytea recv_short_buf[DATA_SIZE - LACK_SIZE];
31 int ind[2];
32 exec sql end declare section;
33 int i, j, c;
34
35 #define init() { \
36 for (i = 0; i < 2; ++i) \
37 { \
38 memset(recv_buf[i].arr, 0x0, sizeof(recv_buf[i].arr)); \
39 recv_buf[i].len = 0; \
40 ind[i] = 0; \
41 } \
42 recv_vlen_buf = NULL, \
43 memset(recv_short_buf.arr, 0x0, sizeof(recv_short_buf.arr)); \
44 } \
45 while (0)
46
47 ECPGdebug(1, stderr);
48
49 for (i = 0; i < 2; ++i)
50 {
51 for (j = 0, c = 0xff; (c == -1 ? c = 0xff : 1), j < DATA_SIZE; ++j, --c)
52 send_buf[i].arr[j] = c;
53
54 send_buf[i].len = DATA_SIZE;
55 }
56
57 exec sql connect to REGRESSDB1;
58
59 exec sql create table if not exists test (data1 bytea, data2 bytea);
60
61 exec sql prepare ins_stmt from "insert into test values(?,?)";
62 exec sql prepare sel_stmt from "select data1,data2 from test";
63 exec sql allocate descriptor idesc;
64 exec sql allocate descriptor odesc;
65
66 /* Test for static sql statement with normal host variable, indicator */
67 init();
68 exec sql truncate test;
69 exec sql insert into test values(:send_buf[0], :send_buf[1]);
70 exec sql select data1,data2 into :recv_buf[0]:ind[0], :recv_short_buf:ind[1] from test;
71 dump_binary(recv_buf[0].arr, recv_buf[0].len, ind[0]);
72 dump_binary(recv_short_buf.arr, recv_short_buf.len, ind[1]);
73
74 /* Test for cursor */
75 init();
76 exec sql truncate test;
77 exec sql insert into test values(:send_buf[0], :send_buf[1]);
78 exec sql declare cursor1 cursor for select data1 from test where data1 = :send_buf[0];
79 exec sql open cursor1;
80 exec sql fetch from cursor1 INTO :recv_buf[0];
81 exec sql close cursor1;
82 exec sql free cursor1 ;
83 dump_binary(recv_buf[0].arr, recv_buf[0].len, 0);
84
85 /* Test for variable length array */
86 init();
87 exec sql truncate test;
88 exec sql insert into test values(:send_buf[0], :send_buf[1]);
89 exec sql insert into test values(:send_buf[0], :send_buf[1]);
90 exec sql select data1 into :recv_vlen_buf from test;
91 dump_binary(recv_vlen_buf[0].arr, recv_vlen_buf[0].len, 0);
92 dump_binary(recv_vlen_buf[1].arr, recv_vlen_buf[1].len, 0);
93 free(recv_vlen_buf);
94
95 /* Test for dynamic sql statement with normal host variable, indicator */
96 init();
97 exec sql truncate test;
98 exec sql execute ins_stmt using :send_buf[0], :send_buf[1];
99 exec sql execute sel_stmt into :recv_buf[0]:ind[0], :recv_short_buf:ind[1];
100 dump_binary(recv_buf[0].arr, recv_buf[0].len, ind[0]);
101 dump_binary(recv_short_buf.arr, recv_short_buf.len, ind[1]);
102
103 /* Test for dynamic sql statement with sql descriptor */
104 init();
105 exec sql truncate test;
106 exec sql set descriptor idesc value 1 data = :send_buf[0];
107 exec sql set descriptor idesc value 2 data = :send_buf[1];
108 exec sql execute ins_stmt using sql descriptor idesc;
109 exec sql execute sel_stmt into sql descriptor odesc;
110 exec sql get descriptor odesc value 1 :recv_buf[0] = data, :ind[0] = indicator;
111 exec sql get descriptor odesc value 2 :recv_short_buf = data, :ind[1] = indicator;
112 dump_binary(recv_buf[0].arr, recv_buf[0].len, ind[0]);
113 dump_binary(recv_short_buf.arr, recv_short_buf.len, ind[1]);
114
115 exec sql drop table test;
116
117 /* Test for invalid bytea format */
118 exec sql select ''::text into :recv_buf[0];
119 exec sql select '\\a1234'::text into :recv_buf[0];
120
121 exec sql commit;
122 exec sql disconnect;
123
124 return 0;
125 }