2 * Copyright (c) 2004-2005 The Regents of The University of Michigan
5 * Redistribution and use in source and binary forms, with or without
6 * modification, are permitted provided that the following conditions are
7 * met: redistributions of source code must retain the above copyright
8 * notice, this list of conditions and the following disclaimer;
9 * redistributions in binary form must reproduce the above copyright
10 * notice, this list of conditions and the following disclaimer in the
11 * documentation and/or other materials provided with the distribution;
12 * neither the name of the copyright holders nor the names of its
13 * contributors may be used to endorse or promote products derived from
14 * this software without specific prior written permission.
16 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
17 * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
18 * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR
19 * A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT
20 * OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
21 * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
22 * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
23 * DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY
24 * THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
25 * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
26 * OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
31 #include "base/mysql.hh"
32 #include "base/trace.hh"
39 charstar(const string
&string
)
41 return string
.empty() ? NULL
: string
.c_str();
45 operator<<(ostream
&stream
, const Error
&error
)
47 stream
<< error
.string();
52 * The connection class
54 Connection::Connection()
59 Connection::~Connection()
67 Connection::connect(const string
&xhost
, const string
&xuser
,
68 const string
&xpasswd
, const string
&xdatabase
)
71 return error
.set("Already Connected");
76 _database
= xdatabase
;
81 mysql_options(&mysql
, MYSQL_OPT_COMPRESS
, 0); // might want to be 1
82 mysql_options(&mysql
, MYSQL_READ_DEFAULT_GROUP
, "odbc");
83 if (!mysql_real_connect(&mysql
, charstar(_host
), charstar(_user
),
84 charstar(_passwd
), charstar(_database
),
86 return error
.set(mysql_error(&mysql
));
99 Connection::query(const string
&sql
)
101 DPRINTF(SQL
, "Sending SQL query to server:\n%s", sql
);
103 if (mysql_real_query(&mysql
, sql
.c_str(), sql
.size()))
104 error
.set(mysql_error(&mysql
));
110 /* namespace MySQL */ }