aboutsummaryrefslogtreecommitdiffstats
path: root/src/libs/sqlite/sqlstatementbuilder.h
diff options
context:
space:
mode:
Diffstat (limited to 'src/libs/sqlite/sqlstatementbuilder.h')
-rw-r--r--src/libs/sqlite/sqlstatementbuilder.h86
1 files changed, 86 insertions, 0 deletions
diff --git a/src/libs/sqlite/sqlstatementbuilder.h b/src/libs/sqlite/sqlstatementbuilder.h
new file mode 100644
index 0000000000..5fcd3d51f0
--- /dev/null
+++ b/src/libs/sqlite/sqlstatementbuilder.h
@@ -0,0 +1,86 @@
+/****************************************************************************
+**
+** Copyright (C) 2015 The Qt Company Ltd.
+** Contact: http://www.qt.io/licensing
+**
+** This file is part of Qt Creator.
+**
+** Commercial License Usage
+** Licensees holding valid commercial Qt licenses may use this file in
+** accordance with the commercial license agreement provided with the
+** Software or, alternatively, in accordance with the terms contained in
+** a written agreement between you and Digia. For licensing terms and
+** conditions see http://www.qt.io/licensing. For further information
+** use the contact form at http://www.qt.io/contact-us.
+**
+** GNU Lesser General Public License Usage
+** Alternatively, this file may be used under the terms of the GNU Lesser
+** General Public License version 2.1 or version 3 as published by the Free
+** Software Foundation and appearing in the file LICENSE.LGPLv21 and
+** LICENSE.LGPLv3 included in the packaging of this file. Please review the
+** following information to ensure the GNU Lesser General Public License
+** requirements will be met: https://www.gnu.org/licenses/lgpl.html and
+** http://www.gnu.org/licenses/old-licenses/lgpl-2.1.html.
+**
+** In addition, as a special exception, Digia gives you certain additional
+** rights. These rights are described in the Digia Qt LGPL Exception
+** version 1.1, included in the file LGPL_EXCEPTION.txt in this package.
+**
+****************************************************************************/
+
+#ifndef SQLSTATEMENTBUILDER_H
+#define SQLSTATEMENTBUILDER_H
+
+#include <vector>
+#include <utility>
+
+#include "utf8string.h"
+
+class SQLITE_EXPORT SqlStatementBuilder
+{
+ using BindingPair = std::pair<Utf8String, Utf8String>;
+public:
+ SqlStatementBuilder(const Utf8String &sqlTemplate);
+
+ void bindEmptyText(const Utf8String &name);
+ void bind(const Utf8String &name, const Utf8String &text);
+ void bind(const Utf8String &name, const Utf8StringVector &textVector);
+ void bind(const Utf8String &name, int value);
+ void bind(const Utf8String &name, const QVector<int> &integerVector);
+ void bindWithInsertTemplateParameters(const Utf8String &name, const Utf8StringVector &columns);
+ void bindWithUpdateTemplateParameters(const Utf8String &name, const Utf8StringVector &columns);
+ void bindWithUpdateTemplateNames(const Utf8String &name, const Utf8StringVector &columns);
+ void clear();
+
+ Utf8String sqlStatement() const;
+
+ bool isBuild() const;
+
+ static Utf8String columnTypeToString(ColumnType columnType);
+
+protected:
+ static const Utf8String insertTemplateParameters(const Utf8StringVector &columns);
+ static const Utf8String updateTemplateParameters(const Utf8StringVector &columns);
+ static const Utf8String updateTemplateNames(const Utf8StringVector &columns);
+
+ void sortBindings() const;
+ void generateSqlStatement() const;
+
+ void changeBinding(const Utf8String &name, const Utf8String &text);
+
+ void clearSqlStatement();
+ void checkIfPlaceHolderExists(const Utf8String &name) const;
+ void checkIfNoPlaceHoldersAynmoreExists() const;
+ void checkBindingTextIsNotEmpty(const Utf8String &text) const;
+ void checkBindingTextVectorIsNotEmpty(const Utf8StringVector &textVector) const;
+ void checkBindingIntegerVectorIsNotEmpty(const QVector<int> &integerVector) const;
+
+ Q_NORETURN static void throwException(const char *whatHasHappened, const char *errorMessage);
+
+private:
+ Utf8String sqlTemplate;
+ mutable Utf8String sqlStatement_;
+ mutable std::vector<BindingPair> bindings;
+};
+
+#endif // SQLSTATEMENTBUILDER_H