LeechCraft  0.6.70-13729-g7046a9d2a7
Modular cross-platform feature rich live environment.
common.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 <tuple>
33 #include <QtTest>
34 #include <QSqlError>
35 #include <oral/oral.h>
36 
37 namespace lco = LC::Util::oral;
38 
39 #define ORAL_FACTORY_SQLITE 1
40 #define ORAL_FACTORY_POSTGRES 2
41 
42 #if ORAL_FACTORY == ORAL_FACTORY_SQLITE
43 
44 using OralFactory = lco::SQLiteImplFactory;
45 
46 #elif ORAL_FACTORY == ORAL_FACTORY_POSTGRES
47 
48 #include <oral/pgimpl.h>
49 
50 using OralFactory = lco::PostgreSQLImplFactory;
51 
52 #else
53 
54 #error "Unknown oral tests factory"
55 
56 #endif
57 
58 template<typename T, typename = decltype (T {}.AsTuple ())>
59 auto operator== (const T& left, const T& right)
60 {
61  return left.AsTuple () == right.AsTuple ();
62 }
63 
64 namespace LC::Util::oral
65 {
66  template<typename T, typename... Args>
67  char* toString (const PKey<T, Args...>& pkey)
68  {
69  return QTest::toString (pkey.Val_);
70  }
71 }
72 
73 #if QT_VERSION < QT_VERSION_CHECK(5,12,0)
74 template<typename... Args>
75 char* toString (const std::tuple<Args...>& tuple)
76 {
77  using QTest::toString;
78 
79  QByteArray ba { "std::tuple { "};
80 
81  std::apply ([&ba] (const auto&... args) { (ba.append (toString (args)).append (", "), ...); }, tuple);
82 
83  if (sizeof... (Args) >= 1)
84  ba.chop (2);
85  ba.append (" }");
86 
87  return qstrdup (ba.data ());
88 }
89 #endif
90 
91 #define TOSTRING(n) inline char* toString (const n& rec) { return toString (#n, rec); }
92 
93 template<typename T, typename TupleType = decltype (T {}.AsTuple ())>
94 char* toString (const char *name, const T& t)
95 {
96  using QTest::toString;
97 
98  QByteArray ba { name };
99  ba.append (" { ");
100 
101  std::apply ([&ba] (const auto&... args) { (ba.append (toString (args)).append (", "), ...); }, t.AsTuple ());
102 
103  if (std::tuple_size<TupleType>::value >= 1)
104  ba.chop (2);
105  ba.append (" }");
106 
107  return qstrdup (ba.data ());
108 }
109 
110 namespace LC::Util
111 {
112  QSqlDatabase MakeDatabase (const QString& name = ":memory:")
113  {
114 #if ORAL_FACTORY == ORAL_FACTORY_SQLITE
115  auto db = QSqlDatabase::addDatabase ("QSQLITE", Util::GenConnectionName ("TestConnection"));
116  db.setDatabaseName (name);
117  if (!db.open ())
118  throw std::runtime_error { "cannot create test database" };
119 
120  RunTextQuery (db, "PRAGMA foreign_keys = ON;");
121 
122  return db;
123 #elif ORAL_FACTORY == ORAL_FACTORY_POSTGRES
124  Q_UNUSED (name)
125 
126  auto db = QSqlDatabase::addDatabase ("QPSQL", Util::GenConnectionName ("TestConnection"));
127 
128  db.setHostName ("localhost");
129  db.setPort (5432);
130  db.setUserName (qgetenv ("TEST_POSTGRES_USERNAME"));
131 
132  if (!db.open ())
133  {
134  DBLock::DumpError (db.lastError ());
135  throw std::runtime_error { "cannot create test database" };
136  }
137 
138  return db;
139 #endif
140  }
141 
142  template<typename T>
143  auto PrepareRecords (QSqlDatabase db, int count = 3)
144  {
145  auto adapted = Util::oral::AdaptPtr<T, OralFactory> (db);
146  for (int i = 0; i < count; ++i)
147  adapted->Insert ({ i, QString::number (i) });
148  return adapted;
149  }
150 }
constexpr detail::AggregateType< detail::AggregateFunction::Count, Ptr > count
Definition: oral.h:969
QSqlDatabase MakeDatabase(const QString &name=":memory:")
Definition: common.h:112
detail::SQLite::ImplFactory SQLiteImplFactory
Definition: sqliteimpl.h:96
auto PrepareRecords(QSqlDatabase db, int count=3)
Definition: common.h:143
char * toString(const char *name, const T &t)
Definition: common.h:94
QSqlQuery RunTextQuery(const QSqlDatabase &db, const QString &text)
Runs the given query text on the given db.
Definition: util.cpp:40
detail::PostgreSQL::ImplFactory PostgreSQLImplFactory
Definition: pgimpl.h:124
QString GenConnectionName(const QString &base)
Generates an unique thread-safe connection name.
Definition: util.cpp:103