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 10 : TEST_MAIN()
22 : {
23 : TDSLOGIN *login;
24 : TDSSOCKET *tds;
25 10 : int verbose = 0;
26 : int rc;
27 :
28 10 : printf("%s: Testing DB change -- 'use tempdb'\n", __FILE__);
29 10 : rc = try_tds_login(&login, &tds, __FILE__, verbose);
30 10 : if (rc != TDS_SUCCESS) {
31 0 : fprintf(stderr, "try_tds_login() failed\n");
32 0 : return 1;
33 : }
34 :
35 10 : rc = tds_submit_query(tds, "use tempdb");
36 10 : if (rc != TDS_SUCCESS) {
37 0 : fprintf(stderr, "tds_submit_query() failed\n");
38 0 : return 1;
39 : }
40 :
41 : /* warning: this mucks with some internals to get the env chg message */
42 10 : if (tds_process_simple_query(tds) != TDS_SUCCESS) {
43 0 : fprintf(stderr, "query results failed\n");
44 0 : return 1;
45 : }
46 :
47 10 : if (!tds || !tds->conn->env.database) {
48 0 : fprintf(stderr, "No database ??\n");
49 0 : return 1;
50 : }
51 :
52 : /* Test currently disabled during TDSENV changes */
53 : if (verbose) {
54 : printf("database changed to %s\n", tds->conn->env.database);
55 : }
56 10 : if (strcmp(tds->conn->env.database, "tempdb")) {
57 0 : fprintf(stderr, "Wrong database, %s != tempdb\n", tds->conn->env.database);
58 0 : return 1;
59 : }
60 :
61 10 : try_tds_logout(login, tds, verbose);
62 10 : return 0;
63 : }
|