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