Debian Codegraph @

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

raw
1 /*
2 * this file tests all sorts of connecting to one single database.
3 */
4
5 #include <stdlib.h>
6 #include <string.h>
7 #include <stdlib.h>
8 #include <stdio.h>
9
10 /* do not include regression.h */
11
12 int
13 main(void)
14 {
15 exec sql begin declare section;
16 char db[200];
17 char id[200];
18 char *user="regress_ecpg_user1";
19 exec sql end declare section;
20
21 ECPGdebug(1, stderr);
22
23 exec sql connect to ecpg2_regression as main;
24 exec sql alter user regress_ecpg_user2 ENCRYPTED PASSWORD 'insecure';
25 exec sql alter user regress_ecpg_user1 ENCRYPTED PASSWORD 'connectpw';
26 exec sql commit;
27 exec sql disconnect; /* <-- "main" not specified */
28
29 strcpy(db, "ecpg2_regression");
30 strcpy(id, "main");
31 exec sql connect to :db as :id;
32 exec sql disconnect :id;
33
34 exec sql connect to ecpg2_regression as main;
35 exec sql disconnect main;
36
37 exec sql connect to "ecpg2_regression" as main;
38 exec sql disconnect main;
39
40 exec sql connect to 'ecpg2_regression' as main;
41 exec sql disconnect main;
42
43 /* exec sql connect to as main user regress_ecpg_user2/insecure;
44 exec sql disconnect main; */
45
46 exec sql connect to ecpg2_regression as main user regress_ecpg_user1/connectpw;
47 exec sql disconnect main;
48
49 exec sql connect to unix:postgresql://localhost/ecpg2_regression as main user regress_ecpg_user1/connectpw;
50 exec sql disconnect main;
51
52 exec sql connect to "unix:postgresql://localhost/ecpg2_regression" as main user regress_ecpg_user1/connectpw;
53 exec sql disconnect main;
54
55 exec sql connect to 'unix:postgresql://localhost/ecpg2_regression' as main user :user USING "connectpw";
56 exec sql disconnect main;
57
58 exec sql connect to unix:postgresql://localhost/ecpg2_regression?connect_timeout=180&client_encoding=sql_ascii as main user regress_ecpg_user1/connectpw;
59 exec sql disconnect main;
60
61 exec sql connect to "unix:postgresql://200.46.204.71/ecpg2_regression" as main user regress_ecpg_user1/connectpw;
62 exec sql disconnect main;
63
64 exec sql connect to "unix:postgresql://localhost/?gssencmode=disable" as main user regress_ecpg_user2 IDENTIFIED BY insecure;
65 exec sql disconnect main;
66
67 /* connect twice */
68 exec sql connect to ecpg2_regression as main;
69 exec sql connect to ecpg2_regression as main;
70 exec sql disconnect main;
71
72 /* not connected */
73 exec sql disconnect nonexistent;
74
75 return 0;
76 }