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 pw[200];
      18              : exec sql end declare section;
      19              : 
      20            0 :         ECPGdebug(1, stderr);
      21              : 
      22            0 :         exec sql connect to ecpg2_regression as main;
      23            0 :         exec sql alter user regress_ecpg_user1 ENCRYPTED PASSWORD 'connectpw';
      24            0 :         exec sql disconnect;  /* <-- "main" not specified */
      25              : 
      26            0 :         exec sql connect to ecpg2_regression@localhost as main;
      27            0 :         exec sql disconnect main;
      28              : 
      29            0 :         exec sql connect to @localhost as main user regress_ecpg_user2;
      30            0 :         exec sql disconnect main;
      31              : 
      32              :         /* exec sql connect to :@TEMP_PORT@ as main user regress_ecpg_user2;
      33              :         exec sql disconnect main; */
      34              : 
      35            0 :         exec sql connect to tcp:postgresql://localhost/ecpg2_regression user regress_ecpg_user1 identified by connectpw;
      36            0 :         exec sql disconnect;
      37              : 
      38            0 :         exec sql connect to tcp:postgresql://localhost/ user regress_ecpg_user2;
      39            0 :         exec sql disconnect;
      40              : 
      41            0 :         strcpy(pw, "connectpw");
      42            0 :         strcpy(db, "tcp:postgresql://localhost/ecpg2_regression");
      43            0 :         exec sql connect to :db user regress_ecpg_user1 using :pw;
      44            0 :         exec sql disconnect;
      45              : 
      46            0 :         exec sql connect to unix:postgresql://localhost/ecpg2_regression user regress_ecpg_user1 using "connectpw";
      47            0 :         exec sql disconnect;
      48              : 
      49            0 :         exec sql connect to unix:postgresql://localhost/ecpg2_regression?connect_timeout=180 user regress_ecpg_user1;
      50            0 :         exec sql disconnect;
      51              : 
      52              :         /* wrong db */
      53            0 :         exec sql connect to tcp:postgresql://localhost/nonexistent user regress_ecpg_user1 identified by connectpw;
      54            0 :         exec sql disconnect;
      55              : 
      56              :         /* wrong port */
      57            0 :         exec sql connect to tcp:postgresql://127.0.0.1:20/ecpg2_regression user regress_ecpg_user1 identified by connectpw;
      58              :         /* no disconnect necessary */
      59              : 
      60              :         /* wrong password */
      61            0 :         exec sql connect to unix:postgresql://localhost/ecpg2_regression user regress_ecpg_user1 identified by "wrongpw";
      62              :         /* no disconnect necessary */
      63              : 
      64            0 :         return 0;
      65            0 : }