Age Owner TLA Line data Source code
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
6069 meskes 13 CBC 1 : main(void)
14 : {
15 : exec sql begin declare section;
16 : char db[200];
17 : char id[200];
2457 tgl 18 1 : char *user="regress_ecpg_user1";
19 : exec sql end declare section;
20 :
6069 meskes 21 1 : ECPGdebug(1, stderr);
22 :
2457 tgl 23 1 : exec sql connect to ecpg2_regression as main;
24 1 : exec sql alter user regress_ecpg_user2 ENCRYPTED PASSWORD 'insecure';
25 1 : exec sql alter user regress_ecpg_user1 ENCRYPTED PASSWORD 'connectpw';
3216 noah 26 1 : exec sql commit;
6069 meskes 27 1 : exec sql disconnect; /* <-- "main" not specified */
28 :
2457 tgl 29 1 : strcpy(db, "ecpg2_regression");
6069 meskes 30 1 : strcpy(id, "main");
31 1 : exec sql connect to :db as :id;
32 1 : exec sql disconnect :id;
33 :
2457 tgl 34 1 : exec sql connect to ecpg2_regression as main;
6069 meskes 35 1 : exec sql disconnect main;
36 :
2457 tgl 37 1 : exec sql connect to "ecpg2_regression" as main;
6069 meskes 38 1 : exec sql disconnect main;
39 :
2457 tgl 40 1 : exec sql connect to 'ecpg2_regression' as main;
6069 meskes 41 1 : exec sql disconnect main;
42 :
43 : /* exec sql connect to as main user regress_ecpg_user2/insecure;
44 : exec sql disconnect main; */
45 :
2457 tgl 46 1 : exec sql connect to ecpg2_regression as main user regress_ecpg_user1/connectpw;
6069 meskes 47 1 : exec sql disconnect main;
48 :
2457 tgl 49 1 : exec sql connect to unix:postgresql://localhost/ecpg2_regression as main user regress_ecpg_user1/connectpw;
6069 meskes 50 1 : exec sql disconnect main;
51 :
2457 tgl 52 1 : exec sql connect to "unix:postgresql://localhost/ecpg2_regression" as main user regress_ecpg_user1/connectpw;
6069 meskes 53 1 : exec sql disconnect main;
54 :
2457 tgl 55 1 : exec sql connect to 'unix:postgresql://localhost/ecpg2_regression' as main user :user USING "connectpw";
6069 meskes 56 1 : exec sql disconnect main;
57 :
31 jdavis 58 GNC 1 : exec sql connect to unix:postgresql://localhost/ecpg2_regression?connect_timeout=180&client_encoding=sql_ascii as main user regress_ecpg_user1/connectpw;
4069 meskes 59 CBC 1 : exec sql disconnect main;
60 :
2457 tgl 61 1 : exec sql connect to "unix:postgresql://200.46.204.71/ecpg2_regression" as main user regress_ecpg_user1/connectpw;
6069 meskes 62 1 : exec sql disconnect main;
63 :
668 tgl 64 1 : exec sql connect to "unix:postgresql://localhost/?gssencmode=disable" as main user regress_ecpg_user2 IDENTIFIED BY insecure;
6067 meskes 65 1 : exec sql disconnect main;
66 :
67 : /* connect twice */
2457 tgl 68 1 : exec sql connect to ecpg2_regression as main;
69 1 : exec sql connect to ecpg2_regression as main;
6069 meskes 70 1 : exec sql disconnect main;
71 :
72 : /* not connected */
1401 noah 73 1 : exec sql disconnect nonexistent;
74 :
2061 peter_e 75 1 : return 0;
76 : }
|
