LeechCraft  0.6.70-10870-g558588d6ec
Modular cross-platform feature rich live environment.
util.h
Go to the documentation of this file.
1 /**********************************************************************
2  * LeechCraft - modular cross-platform feature rich internet client.
3  * Copyright (C) 2006-2014 Georg Rudoy
4  *
5  * Boost Software License - Version 1.0 - August 17th, 2003
6  *
7  * Permission is hereby granted, free of charge, to any person or organization
8  * obtaining a copy of the software and accompanying documentation covered by
9  * this license (the "Software") to use, reproduce, display, distribute,
10  * execute, and transmit the Software, and to prepare derivative works of the
11  * Software, and to permit third-parties to whom the Software is furnished to
12  * do so, all subject to the following:
13  *
14  * The copyright notices in the Software and this entire statement, including
15  * the above license grant, this restriction and the following disclaimer,
16  * must be included in all copies of the Software, in whole or in part, and
17  * all derivative works of the Software, unless such copies or derivative
18  * works are solely in the form of machine-executable object code generated by
19  * a source language processor.
20  *
21  * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
22  * IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
23  * FITNESS FOR A PARTICULAR PURPOSE, TITLE AND NON-INFRINGEMENT. IN NO EVENT
24  * SHALL THE COPYRIGHT HOLDERS OR ANYONE DISTRIBUTING THE SOFTWARE BE LIABLE
25  * FOR ANY DAMAGES OR OTHER LIABILITY, WHETHER IN CONTRACT, TORT OR OTHERWISE,
26  * ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER
27  * DEALINGS IN THE SOFTWARE.
28  **********************************************************************/
29 
30 #pragma once
31 
32 #include <QVariant>
33 #include <QSqlQuery>
34 #include <QtDebug>
35 #include "dbconfig.h"
36 
37 class QSqlDatabase;
38 class QString;
39 
40 namespace LeechCraft
41 {
42 namespace Util
43 {
59  UTIL_DB_API QSqlQuery RunTextQuery (const QSqlDatabase& db, const QString& text);
60 
81  UTIL_DB_API QString LoadQuery (const QString& plugin, const QString& filename);
82 
104  UTIL_DB_API void RunQuery (const QSqlDatabase& db, const QString& plugin, const QString& filename);
105 
117  template<typename T = int>
118  T GetLastId (const QSqlQuery& query)
119  {
120  const auto& lastVar = query.lastInsertId ();
121  if (lastVar.isNull ())
122  throw std::runtime_error { "No last ID has been reported." };
123 
124  if (!lastVar.canConvert<T> ())
125  {
126  qWarning () << Q_FUNC_INFO
127  << "cannot convert"
128  << lastVar;
129  throw std::runtime_error { "Cannot convert last ID." };
130  }
131 
132  return lastVar.value<T> ();
133  }
134 
146  UTIL_DB_API QString GenConnectionName (const QString& base);
147 }
148 }
T GetLastId(const QSqlQuery &query)
Gets the last insert ID for the given query.
Definition: util.h:118
#define UTIL_DB_API
Definition: dbconfig.h:37
QString GenConnectionName(const QString &base)
Generates an unique thread-safe connection name.
Definition: util.cpp:106
void RunQuery(const QSqlDatabase &db, const QString &pluginName, const QString &filename)
Loads the query from the given resource file and runs it.
Definition: util.cpp:69
QString LoadQuery(const QString &pluginName, const QString &filename)
Loads the query text from the given resource file.
Definition: util.cpp:55
QSqlQuery RunTextQuery(const QSqlDatabase &db, const QString &text)
Runs the given query text on the given db.
Definition: util.cpp:40