14using LC::operator
""_ct;
21 constexpr static auto ClassName =
"AutogenPKeyRecord"_ct;
40 constexpr static auto ClassName =
"NoPKeyRecord"_ct;
44 return std::tie (ID_,
Value_);
54struct NonInPlaceConstructibleRecord
59 NonInPlaceConstructibleRecord () =
default;
61 NonInPlaceConstructibleRecord (
int id,
const QString& value,
double someExtraArgument)
65 Q_UNUSED (someExtraArgument)
68 constexpr static auto ClassName =
"NonInPlaceConstructibleRecord"_ct;
72 return std::tie (ID_,
Value_);
80TOSTRING (NonInPlaceConstructibleRecord)
82struct ComplexConstraintsRecord
89 constexpr static auto ClassName =
"ComplexConstraintsRecord"_ct;
93 return std::tie (ID_,
Value_, Age_, Weight_);
110template<
typename... Args>
113 return std::apply ([&] (
auto&&... args) {
return ((dbg.nospace () << args <<
' '), ...); },
tup);
120 namespace sph = oral::sph;
122 void OralTest::testAutoPKeyRecordInsertSelect ()
126 const auto& list = adapted->Select ();
130 void OralTest::testAutoPKeyRecordInsertRvalueReturnsPKey ()
135 for (
int i = 0; i < 3; ++i)
136 ids << adapted->Insert ({ 0, QString::number (i) });
141 void OralTest::testAutoPKeyRecordInsertConstLvalueReturnsPKey ()
146 for (
int i = 0; i < 3; ++i)
147 records.push_back ({ 0, QString::number (i) });
150 for (
const auto& record : records)
151 ids << adapted->Insert (record);
156 void OralTest::testAutoPKeyRecordInsertSetsPKey ()
161 for (
int i = 0; i < 3; ++i)
162 records.push_back ({ 0, QString::number (i) });
164 for (
auto& record : records)
165 adapted->Insert (record);
170 void OralTest::testNoPKeyRecordInsertSelect ()
173 const auto& list = adapted->Select ();
177 void OralTest::testNonInPlaceConstructibleRecordInsertSelect ()
180 for (
int i = 0; i < 3; ++i)
181 adapted->Insert ({ i, QString::number (i), 0 });
183 const auto& list = adapted->Select ();
189 template<
typename Ex,
typename F>
190 void ShallThrow (F&& f)
202 QCOMPARE (failed,
true);
206 void OralTest::testComplexConstraintsRecordInsertSelectDefault ()
210 adapted->Insert ({ 0,
"first", 1, 2 });
211 ShallThrow<oral::QueryException> ([&] { adapted->Insert ({ 0,
"second", 1, 2 }); });
212 ShallThrow<oral::QueryException> ([&] { adapted->Insert ({ 0,
"first", 1, 3 }); });
213 adapted->Insert ({ 0,
"second", 1, 3 });
214 ShallThrow<oral::QueryException> ([&] { adapted->Insert ({ 0,
"first", 1, 3 }); });
216 const auto& list = adapted->Select ();
220 void OralTest::testComplexConstraintsRecordInsertSelectIgnore ()
224 adapted->Insert ({ 0,
"first", 1, 2 }, lco::InsertAction::Ignore);
225 adapted->Insert ({ 0,
"second", 1, 2 }, lco::InsertAction::Ignore);
226 adapted->Insert ({ 0,
"first", 1, 3 }, lco::InsertAction::Ignore);
227 adapted->Insert ({ 0,
"second", 1, 3 }, lco::InsertAction::Ignore);
228 adapted->Insert ({ 0,
"first", 1, 3 }, lco::InsertAction::Ignore);
230 const auto& list = adapted->Select ();
234 void OralTest::testComplexConstraintsRecordInsertSelectReplace ()
238 const auto idValueFields = lco::InsertAction::Replace::Fields<
239 &ComplexConstraintsRecord::ID_,
240 &ComplexConstraintsRecord::Value_
242 const auto weightAgeFields = lco::InsertAction::Replace::Fields<
243 &ComplexConstraintsRecord::Weight_,
244 &ComplexConstraintsRecord::Age_
246 adapted->Insert ({ 0,
"first", 1, 2 }, idValueFields);
247 adapted->Insert ({ 0,
"second", 1, 2 }, weightAgeFields);
248 adapted->Insert ({ 0,
"first", 1, 3 }, idValueFields);
249 adapted->Insert ({ 0,
"third", 1, 3 }, weightAgeFields);
250 adapted->Insert ({ 0,
"first", 1, 3 }, weightAgeFields);
252 const auto& list = adapted->Select ();
constexpr auto FieldNames
constexpr detail::ExprTree< detail::ExprType::LeafStaticPlaceholder, detail::MemberPtrs< Ptr > > f
ObjectInfo_ptr< T > AdaptPtr(const QSqlDatabase &db)
auto PrepareRecords(QSqlDatabase db, int count=3)
QSqlDatabase MakeDatabase(const QString &name=":memory:")
#define ORAL_ADAPT_STRUCT(sname,...)
const std::tuple< Args... > & tup
QDataStream & operator<<(QDataStream &out, const LC::Util::RegExp &rx)
static constexpr auto ClassName