LeechCraft  0.6.70-13729-g7046a9d2a7
Modular cross-platform feature rich live environment.
sqliteimpl.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 <util/sll/visitor.h>
33 #include "oraltypes.h"
34 #include "oraldetailfwd.h"
35 #include "impldefs.h"
36 
38 {
39  using QSqlQuery_ptr = std::shared_ptr<QSqlQuery>;
40 
42  {
43  const QSqlDatabase DB_;
44 
45  std::array<QSqlQuery_ptr, InsertAction::StaticCount () + 1> Queries_;
46  const QString InsertSuffix_;
47  public:
48  InsertQueryBuilder (const QSqlDatabase& db, const CachedFieldsData& data)
49  : DB_ { db }
50  , InsertSuffix_ { " INTO " + data.Table_ +
51  " (" + data.Fields_.join (", ") + ") VALUES (" +
52  data.BoundFields_.join (", ") + ");" }
53  {
54  }
55 
57  {
58  auto& query = Queries_ [action.Selector_.index ()];
59  if (!query)
60  {
61  query = std::make_shared<QSqlQuery> (DB_);
62  query->prepare (GetInsertPrefix (action) + InsertSuffix_);
63  }
64  return query;
65  }
66  private:
67  QString GetInsertPrefix (InsertAction action)
68  {
69  return Visit (action.Selector_,
70  [] (InsertAction::DefaultTag) { return "INSERT"; },
71  [] (InsertAction::IgnoreTag) { return "INSERT OR IGNORE"; },
72  [] (InsertAction::Replace) { return "INSERT OR REPLACE"; });
73  }
74  };
75 
77  {
78  public:
79  struct TypeLits
80  {
81  inline static const QString IntAutoincrement { "INTEGER PRIMARY KEY AUTOINCREMENT" };
82  inline static const QString Binary { "BLOB" };
83  };
84 
85  inline static const QString LimitNone { "-1" };
86 
87  auto MakeInsertQueryBuilder (const QSqlDatabase& db, const CachedFieldsData& data) const
88  {
89  return std::make_unique<InsertQueryBuilder> (db, data);
90  }
91  };
92 }
93 
94 namespace LC::Util::oral
95 {
97 }
auto MakeInsertQueryBuilder(const QSqlDatabase &db, const CachedFieldsData &data) const
Definition: sqliteimpl.h:87
InsertQueryBuilder(const QSqlDatabase &db, const CachedFieldsData &data)
Definition: sqliteimpl.h:48
auto Visit(const Either< Left, Right > &either, Args &&... args)
Definition: either.h:224
ActionSelector_t Selector_
Definition: oraltypes.h:221
std::shared_ptr< QSqlQuery > QSqlQuery_ptr
Definition: sqliteimpl.h:39
QSqlQuery_ptr GetQuery(InsertAction action) override
Definition: sqliteimpl.h:56