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
6951 meskes@postgresql.or 13 CBC 1 : main(void)
14 : {
15 : exec sql begin declare section;
16 : char db[200];
17 : char id[200];
3339 tgl@sss.pgh.pa.us 18 1 : char *user="regress_ecpg_user1";
19 : exec sql end declare section;
20 :
6951 meskes@postgresql.or 21 1 : ECPGdebug(1, stderr);
22 :
3339 tgl@sss.pgh.pa.us 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';
4098 noah@leadboat.com 26 1 : exec sql commit;
6951 meskes@postgresql.or 27 1 : exec sql disconnect; /* <-- "main" not specified */
28 :
3339 tgl@sss.pgh.pa.us 29 1 : strcpy(db, "ecpg2_regression");
6951 meskes@postgresql.or 30 1 : strcpy(id, "main");
31 1 : exec sql connect to :db as :id;
32 1 : exec sql disconnect :id;
33 :
3339 tgl@sss.pgh.pa.us 34 1 : exec sql connect to ecpg2_regression as main;
6951 meskes@postgresql.or 35 1 : exec sql disconnect main;
36 :
3339 tgl@sss.pgh.pa.us 37 1 : exec sql connect to "ecpg2_regression" as main;
6951 meskes@postgresql.or 38 1 : exec sql disconnect main;
39 :
3339 tgl@sss.pgh.pa.us 40 1 : exec sql connect to 'ecpg2_regression' as main;
6951 meskes@postgresql.or 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 :
3339 tgl@sss.pgh.pa.us 46 1 : exec sql connect to ecpg2_regression as main user regress_ecpg_user1/connectpw;
6951 meskes@postgresql.or 47 1 : exec sql disconnect main;
48 :
3339 tgl@sss.pgh.pa.us 49 1 : exec sql connect to unix:postgresql://localhost/ecpg2_regression as main user regress_ecpg_user1/connectpw;
6951 meskes@postgresql.or 50 1 : exec sql disconnect main;
51 :
3339 tgl@sss.pgh.pa.us 52 1 : exec sql connect to "unix:postgresql://localhost/ecpg2_regression" as main user regress_ecpg_user1/connectpw;
6951 meskes@postgresql.or 53 1 : exec sql disconnect main;
54 :
3339 tgl@sss.pgh.pa.us 55 1 : exec sql connect to 'unix:postgresql://localhost/ecpg2_regression' as main user :user USING "connectpw";
6951 meskes@postgresql.or 56 1 : exec sql disconnect main;
57 :
913 jdavis@postgresql.or 58 1 : exec sql connect to unix:postgresql://localhost/ecpg2_regression?connect_timeout=180&client_encoding=sql_ascii as main user regress_ecpg_user1/connectpw;
4951 meskes@postgresql.or 59 1 : exec sql disconnect main;
60 :
3339 tgl@sss.pgh.pa.us 61 1 : exec sql connect to "unix:postgresql://200.46.204.71/ecpg2_regression" as main user regress_ecpg_user1/connectpw;
6951 meskes@postgresql.or 62 1 : exec sql disconnect main;
63 :
1550 tgl@sss.pgh.pa.us 64 1 : exec sql connect to "unix:postgresql://localhost/?gssencmode=disable" as main user regress_ecpg_user2 IDENTIFIED BY insecure;
6949 meskes@postgresql.or 65 1 : exec sql disconnect main;
66 :
67 : /* connect twice */
3339 tgl@sss.pgh.pa.us 68 1 : exec sql connect to ecpg2_regression as main;
69 1 : exec sql connect to ecpg2_regression as main;
6951 meskes@postgresql.or 70 1 : exec sql disconnect main;
71 :
72 : /* not connected */
2283 noah@leadboat.com 73 1 : exec sql disconnect nonexistent;
74 :
2943 peter_e@gmx.net 75 1 : return 0;
76 : }
|
