From efcea3a80da7c4479d5fe168435ecc9fd06bdc72 Mon Sep 17 00:00:00 2001
From: John Turner <jturner.usa@gmail.com>
Date: Sun, 14 Sep 2025 00:16:10 -0400
Subject: Squashed 'subprojects/boost-sqlite/' content from commit 3378e35

git-subtree-dir: subprojects/boost-sqlite
git-subtree-split: 3378e353705271e569cf4ba15c467b840a39798c
---
 test/field.cpp | 46 ++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 46 insertions(+)
 create mode 100644 test/field.cpp

(limited to 'test/field.cpp')

diff --git a/test/field.cpp b/test/field.cpp
new file mode 100644
index 0000000..a3fae32
--- /dev/null
+++ b/test/field.cpp
@@ -0,0 +1,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);
+}
\ No newline at end of file
-- 
cgit v1.2.3