Debian Codegraph @

src/interfaces/ecpg/test/connect/test2.pgc

raw
1 /*
2 * this file tests multiple connections to databases and switches
3 * between them.
4 */
5
6 #include <stdlib.h>
7 #include <string.h>
8 #include <stdlib.h>
9 #include <stdio.h>
10
11 exec sql include ../regression;
12
13 int
14 main(void)
15 {
16 exec sql begin declare section;
17 char id[200];
18 char res[200];
19 exec sql end declare section;
20
21 ECPGdebug(1, stderr);
22
23 strcpy(id, "first");
24 exec sql connect to ecpg2_regression as :id;
25 exec sql connect to REGRESSDB1 as second;
26
27 /* this selects from "second" which was opened last */
28 exec sql select current_database() into :res;
29 exec sql at first select current_database() into :res;
30 exec sql at second select current_database() into :res;
31
32 exec sql set connection first;
33 exec sql select current_database() into :res;
34
35 /* this will disconnect from "first" */
36 exec sql disconnect;
37 exec sql select current_database() into :res;
38
39 /* error here since "first" is already disconnected */
40 exec sql disconnect :id;
41
42 /* disconnect from "second" */
43 exec sql disconnect;
44
45 return 0;
46 }