Line data    Source code

       1              : /*
       2              :  * this file just tests the several possibilities you have for a disconnect
       3              :  */
       4              : 
       5              : #include <stdlib.h>
       6              : #include <string.h>
       7              : #include <stdlib.h>
       8              : #include <stdio.h>
       9              : 
      10              : exec sql include ../regression;
      11              : 
      12              : int
      13            2 : main(void)
      14              : {
      15              : exec sql begin declare section;
      16              :     char id[200];
      17              :     char res[200];
      18              : exec sql end declare section;
      19              : 
      20            2 :     ECPGdebug(1, stderr);
      21              : 
      22            2 :     strcpy(id, "first");
      23            2 :     exec sql connect to ecpg2_regression as :id;
      24            2 :     exec sql connect to REGRESSDB1 as second;
      25              : 
      26              :     /* this selects from "second" which was opened last */
      27            2 :     exec sql select current_database() into :res;
      28              : 
      29              :     /* will close "second" */
      30            2 :     exec sql disconnect CURRENT;
      31            2 :     exec sql select current_database() into :res;
      32              : 
      33            2 :     exec sql connect to REGRESSDB1 as second;
      34              :     /* will close "second" */
      35            2 :     exec sql disconnect DEFAULT;
      36              : 
      37            2 :     exec sql connect to "ecpg2_regression" as second;
      38            2 :     exec sql disconnect ALL;
      39              : 
      40            2 :     exec sql disconnect CURRENT;
      41            2 :     exec sql disconnect DEFAULT;
      42            2 :     exec sql disconnect ALL;
      43              : 
      44              :     /*
      45              :      * exec sql disconnect;
      46              :      * exec sql disconnect name;
      47              :      *
      48              :      *     are used in other tests
      49              :      */
      50              : 
      51            2 :     return 0;
      52              : }