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
|
#include "catch.hpp"
#include "duckdb/main/appender.hpp"
#include "test_helpers.hpp"
#include <vector>
using namespace duckdb;
using namespace std;
TEST_CASE("Test the way appenders interact with transactions", "[appender]") {
duckdb::unique_ptr<QueryResult> result;
DuckDB db(nullptr);
Connection con(db);
REQUIRE_NO_FAIL(con.Query("CREATE TABLE integers(i INTEGER PRIMARY KEY)"));
// begin a transaction manually
REQUIRE_NO_FAIL(con.Query("BEGIN TRANSACTION"));
// append a value to the table
Appender appender(con, "integers");
appender.BeginRow();
appender.Append<int32_t>(1);
appender.EndRow();
appender.Close();
// we can select the value now
result = con.Query("SELECT * FROM integers");
REQUIRE(CHECK_COLUMN(result, 0, {1}));
// rolling back cancels the transaction
REQUIRE_NO_FAIL(con.Query("ROLLBACK"));
// now the values are gone
result = con.Query("SELECT * FROM integers");
REQUIRE(CHECK_COLUMN(result, 0, {}));
}
|
