diff options
Diffstat (limited to 'src/libs/sqlite/sqlstatementbuilder.h')
-rw-r--r-- | src/libs/sqlite/sqlstatementbuilder.h | 86 |
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 |