35 #ifndef OPENMS_FORMAT_DB_DBCONNECTION_H
36 #define OPENMS_FORMAT_DB_DBCONNECTION_H
38 #include <OpenMS/config.h>
41 #include <QtSql/QSqlDatabase>
42 #include <QtSql/QSqlQuery>
114 void connect(
const String & db,
const String & user,
const String & password,
const String & host =
"localhost",
UInt port = 3306,
const String & QTDBDriver = DB_PLUGIN,
const String & connection_name =
"OpenMS_default_connection");
117 bool isConnected()
const;
138 QSqlQuery executeQuery(
const String & query,
bool first =
false);
169 double getDoubleValue(
const String & table,
const String & column,
const String &
id);
217 void render(QSqlQuery & result, std::ostream & out = std::cout,
const String & separator =
" | ",
const String & line_begin =
"",
const String & line_end =
"\n");
230 template <
class StringListType>
231 void executeQueries(
const StringListType & queries);
241 return QSqlDatabase::database(connection_name_,
false);
252 template <
class StringListType>
256 for (
typename StringListType::const_iterator it = queries.begin(); it != queries.end(); ++it)
QSqlQuery executeQuery(const String &query, bool first=false)
Executes a query and returns the result.
A more convenient string class.
Definition: String.h:56
QString connection_name_
Name (handle) of the connection.
Definition: DBConnection.h:236
void executeQueries(const StringListType &queries)
Executes all SQL queries from an container.
Definition: DBConnection.h:253
Exception in case of an invalid Query.
Definition: DBConnection.h:70
String & trim()
removes whitespaces (space, tab, line feed, carriage return) at the beginning and the end of the stri...
A class for connecting to a SQL database.
Definition: DBConnection.h:60
Exception base class.
Definition: Exception.h:90
QSqlDatabase getDB_() const
Retruns the current database connection defined by connection_name_.
Definition: DBConnection.h:239
int Int
Signed integer type.
Definition: Types.h:100
Exception in case of trying to execute a query without having established a database connection...
Definition: DBConnection.h:85