1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
|
//
// Copyright (c) 2024 Klemens Morgenstern (klemens.morgenstern@gmx.net)
//
// Distributed under the Boost Software License, Version 1.0. (See accompanying
// file LICENSE_1_0.txt or copy at http://www.boost.org/LICENSE_1_0.txt)
//
#include <boost/sqlite/transaction.hpp>
#include "test.hpp"
using namespace boost;
BOOST_AUTO_TEST_CASE(transaction)
{
sqlite::connection conn{":memory:"};
conn.execute("create table test(nr integer);");
auto check_size = [&]{
std::size_t n = 0ull;
for (auto l : conn.query("select * from test"))
{
boost::ignore_unused(l);
n++;
}
return n;
};
{
sqlite::transaction t{conn};
BOOST_CHECK_THROW(sqlite::transaction{conn}, system::system_error);
conn.execute("insert into test values(1), (2)");
BOOST_CHECK(check_size() == 2);
{
sqlite::savepoint sq{conn, "s1"};
conn.execute("insert into test values(3)");
BOOST_CHECK(check_size() == 3);
}
BOOST_CHECK(check_size() == 2);
{
sqlite::savepoint sq{conn, "s1"};
conn.execute("insert into test values(4)");
BOOST_CHECK(check_size() == 3);
sq.commit();
}
BOOST_CHECK(check_size() == 3);
{
sqlite::savepoint sq{conn, "s1"};
conn.execute("insert into test values(5)");
BOOST_CHECK(check_size() == 4);
{
sqlite::savepoint sq2{conn, "s2"};
conn.execute("insert into test values (6), (7)");
BOOST_CHECK(check_size() == 6);
sq2.commit();
}
BOOST_CHECK_EQUAL(check_size(), 6u);
}
BOOST_CHECK_EQUAL(check_size(), 3u);
}
BOOST_CHECK(conn.query("select * from test").done());
{
system::error_code ec;
sqlite::error_info ei;
conn.execute("BEGIN", ec, ei);
BOOST_CHECK(!ec);
conn.execute("BEGIN", ec, ei);
BOOST_CHECK(ec);
BOOST_CHECK_THROW(sqlite::transaction{conn}, system::system_error);
sqlite::transaction t{conn, sqlite::transaction::adopt_transaction};
conn.execute("insert into test values (42), (3);");
t.commit();
}
BOOST_CHECK_EQUAL(check_size(), 2u);
}
|
