Debian Codegraph @

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

raw
1 #include <stdio.h>
2 #include <stdlib.h>
3
4 exec sql include ../regression;
5
6 EXEC SQL WHENEVER sqlerror sqlprint;
7 EXEC SQL WHENEVER sqlwarning sqlprint;
8 EXEC SQL WHENEVER not found sqlprint;
9
10 EXEC SQL TYPE customer IS
11 struct
12 {
13 varchar name[50];
14 int phone;
15 };
16
17 EXEC SQL TYPE cust_ind IS
18 struct ind
19 {
20 short name_ind;
21 short phone_ind;
22 };
23
24 int main()
25 {
26 EXEC SQL begin declare section;
27 customer *custs1 = (customer *) malloc(sizeof(customer) * 10);
28 cust_ind *inds = (cust_ind *) malloc(sizeof(cust_ind) * 10);
29 typedef struct
30 {
31 varchar name[50];
32 int phone;
33 } customer2;
34 customer2 *custs2 = (customer2 *) malloc(sizeof(customer2) * 10);
35
36 struct customer3
37 {
38 char name[50];
39 int phone;
40 } *custs3 = (struct customer3 *) malloc(sizeof(struct customer3) * 10);
41
42 struct customer4
43 {
44 varchar name[50];
45 int phone;
46 } *custs4 = (struct customer4 *) malloc(sizeof(struct customer4));
47
48 int r;
49 varchar onlyname[2][50];
50 EXEC SQL end declare section;
51
52 ECPGdebug(1, stderr);
53
54 EXEC SQL connect to REGRESSDB1;
55
56 EXEC SQL create table customers (c varchar(50), p int);
57 EXEC SQL insert into customers values ('John Doe', '12345');
58 EXEC SQL insert into customers values ('Jane Doe', '67890');
59
60 EXEC SQL select * INTO :custs1:inds from customers limit 2;
61 printf("custs1:\n");
62 for (r = 0; r < 2; r++)
63 {
64 printf( "name - %s\n", custs1[r].name.arr );
65 printf( "phone - %d\n", custs1[r].phone );
66 }
67
68 EXEC SQL select * INTO :custs2:inds from customers limit 2;
69 printf("\ncusts2:\n");
70 for (r = 0; r < 2; r++)
71 {
72 printf( "name - %s\n", custs2[r].name.arr );
73 printf( "phone - %d\n", custs2[r].phone );
74 }
75
76 EXEC SQL select * INTO :custs3:inds from customers limit 2;
77 printf("\ncusts3:\n");
78 for (r = 0; r < 2; r++)
79 {
80 printf( "name - %s\n", custs3[r].name );
81 printf( "phone - %d\n", custs3[r].phone );
82 }
83
84 EXEC SQL select * INTO :custs4:inds from customers limit 1;
85 printf("\ncusts4:\n");
86 printf( "name - %s\n", custs4->name.arr );
87 printf( "phone - %d\n", custs4->phone );
88
89 EXEC SQL select c INTO :onlyname from customers limit 2;
90 printf("\nname:\n");
91 for (r = 0; r < 2; r++)
92 {
93 printf( "name - %s\n", onlyname[r].arr );
94 }
95
96 EXEC SQL disconnect all;
97
98 /* All the memory will anyway be freed at the end */
99 return 0;
100 }