Debian Codegraph @

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

raw
1 /*
2 * this file just tests the several possibilities you have for a disconnect
3 */
4
5 #include <stdlib.h>
6 #include <string.h>
7 #include <stdlib.h>
8 #include <stdio.h>
9
10 exec sql include ../regression;
11
12 int
13 main(void)
14 {
15 exec sql begin declare section;
16 char id[200];
17 char res[200];
18 exec sql end declare section;
19
20 ECPGdebug(1, stderr);
21
22 strcpy(id, "first");
23 exec sql connect to ecpg2_regression as :id;
24 exec sql connect to REGRESSDB1 as second;
25
26 /* this selects from "second" which was opened last */
27 exec sql select current_database() into :res;
28
29 /* will close "second" */
30 exec sql disconnect CURRENT;
31 exec sql select current_database() into :res;
32
33 exec sql connect to REGRESSDB1 as second;
34 /* will close "second" */
35 exec sql disconnect DEFAULT;
36
37 exec sql connect to "ecpg2_regression" as second;
38 exec sql disconnect ALL;
39
40 exec sql disconnect CURRENT;
41 exec sql disconnect DEFAULT;
42 exec sql disconnect ALL;
43
44 /*
45 * exec sql disconnect;
46 * exec sql disconnect name;
47 *
48 * are used in other tests
49 */
50
51 return 0;
52 }