Line data    Source code

       1             : /* FreeTDS - Library of routines accessing Sybase and Microsoft databases
       2             :  * Copyright (C) 1998, 1999, 2000, 2001, 2002, 2003, 2004  Brian Bruns
       3             :  *
       4             :  * This library is free software; you can redistribute it and/or
       5             :  * modify it under the terms of the GNU Library General Public
       6             :  * License as published by the Free Software Foundation; either
       7             :  * version 2 of the License, or (at your option) any later version.
       8             :  *
       9             :  * This library is distributed in the hope that it will be useful,
      10             :  * but WITHOUT ANY WARRANTY; without even the implied warranty of
      11             :  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
      12             :  * Library General Public License for more details.
      13             :  *
      14             :  * You should have received a copy of the GNU Library General Public
      15             :  * License along with this library; if not, write to the
      16             :  * Free Software Foundation, Inc., 59 Temple Place - Suite 330,
      17             :  * Boston, MA 02111-1307, USA.
      18             :  */
      19             : #include "common.h"
      20             : 
      21             : int
      22           8 : main(void)
      23             : {
      24             :         TDSLOGIN *login;
      25             :         TDSSOCKET *tds;
      26           8 :         int verbose = 0;
      27             :         int rc;
      28             : 
      29           8 :         printf("%s: Testing DB change -- 'use tempdb'\n", __FILE__);
      30           8 :         rc = try_tds_login(&login, &tds, __FILE__, verbose);
      31           8 :         if (rc != TDS_SUCCESS) {
      32           0 :                 fprintf(stderr, "try_tds_login() failed\n");
      33           0 :                 return 1;
      34             :         }
      35             : 
      36           8 :         rc = tds_submit_query(tds, "use tempdb");
      37           8 :         if (rc != TDS_SUCCESS) {
      38           0 :                 fprintf(stderr, "tds_submit_query() failed\n");
      39           0 :                 return 1;
      40             :         }
      41             : 
      42             :         /* warning: this mucks with some internals to get the env chg message */
      43           8 :         if (tds_process_simple_query(tds) != TDS_SUCCESS) {
      44           0 :                 fprintf(stderr, "query results failed\n");
      45           0 :                 return 1;
      46             :         }
      47             : 
      48           8 :         if (!tds || !tds->conn->env.database) {
      49           0 :                 fprintf(stderr, "No database ??\n");
      50           0 :                 return 1;
      51             :         }
      52             : 
      53             :         /* Test currently disabled during TDSENV changes */
      54             :         if (verbose) {
      55             :                 printf("database changed to %s\n", tds->conn->env.database);
      56             :         }
      57           8 :         if (strcmp(tds->conn->env.database, "tempdb")) {
      58           0 :                 fprintf(stderr, "Wrong database, %s != tempdb\n", tds->conn->env.database);
      59           0 :                 return 1;
      60             :         }
      61             : 
      62           8 :         try_tds_logout(login, tds, verbose);
      63           8 :         return 0;
      64             : }