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
|
// Copyright (c) 2022 Klemens D. Morgenstern
//
// 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/field.hpp>
#include <boost/sqlite/connection.hpp>
#include "test.hpp"
using namespace boost;
BOOST_AUTO_TEST_CASE(field)
{
sqlite::connection conn(":memory:");
// language=sqlite
conn.execute(R"(
create table type_tester(
id integer primary key autoincrement,
num real,
nl null,
txt text,
blb blob);
insert into type_tester values(42, 1.2, null, 'text', x'04050607');
)");
auto res = conn.query("select * from type_tester");
auto r = res.current();
BOOST_CHECK(r[0].type() == sqlite::value_type::integer);
BOOST_CHECK(r[0].get_int() == 42);
BOOST_CHECK(r[1].type() == sqlite::value_type::floating);
BOOST_CHECK(r[1].get_double() == 1.2);
BOOST_CHECK(r[2].type() == sqlite::value_type::null);
BOOST_CHECK(r[3].type() == sqlite::value_type::text);
BOOST_CHECK(r[3].get_text() == "text");
BOOST_CHECK(r[4].type() == sqlite::value_type::blob);
sqlite::blob bl{4u};
char raw_data[4] = {4,5,6,7};
std::memcpy(bl.data(), raw_data, 4);
BOOST_CHECK(std::memcmp(bl.data(), r[4].get_blob().data(), 4u) == 0u);
}
|
