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