From efcea3a80da7c4479d5fe168435ecc9fd06bdc72 Mon Sep 17 00:00:00 2001 From: John Turner 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/extension/CMakeLists.txt | 19 +++++++++++++++++++ test/extension/simple_scalar.cpp | 27 +++++++++++++++++++++++++++ test/extension/simple_scalar.sql | 4 ++++ 3 files changed, 50 insertions(+) create mode 100644 test/extension/CMakeLists.txt create mode 100644 test/extension/simple_scalar.cpp create mode 100644 test/extension/simple_scalar.sql (limited to 'test/extension') diff --git a/test/extension/CMakeLists.txt b/test/extension/CMakeLists.txt new file mode 100644 index 0000000..a52a92c --- /dev/null +++ b/test/extension/CMakeLists.txt @@ -0,0 +1,19 @@ + +file(GLOB_RECURSE ALL_SQLITE_FILES RELATIVE ${CMAKE_CURRENT_SOURCE_DIR} ${CMAKE_CURRENT_SOURCE_DIR}/*.sql) +file(GLOB_RECURSE ALL_CPP_FILES RELATIVE ${CMAKE_CURRENT_SOURCE_DIR} ${CMAKE_CURRENT_SOURCE_DIR}/*.cpp) + +foreach(module ${ALL_CPP_FILES}) + get_filename_component(stem ${module} NAME_WE) + add_library(boost_sqlite_test_extension_${stem} SHARED ${module}) + target_link_libraries(boost_sqlite_test_extension_${stem} PUBLIC Boost::sqlite_ext) + target_include_directories(boost_sqlite_test_extension_${stem} PUBLIC ../../include) + set_property(TARGET boost_sqlite_test_extension_${stem} PROPERTY PREFIX "") + set_target_properties(boost_sqlite_test_extension_${stem} PROPERTIES OUTPUT_NAME ${stem}) +endforeach() + +foreach(script ${ALL_SQLITE_FILES}) + get_filename_component(stem ${script} NAME_WE) + add_test(NAME boost_sqlite_test_extension_${stem} COMMAND + sqlite3 :memory: ".read ${CMAKE_CURRENT_SOURCE_DIR}/${script}" + WORKING_DIRECTORY ${CMAKE_CURRENT_BINARY_DIR}) +endforeach() diff --git a/test/extension/simple_scalar.cpp b/test/extension/simple_scalar.cpp new file mode 100644 index 0000000..4a05afe --- /dev/null +++ b/test/extension/simple_scalar.cpp @@ -0,0 +1,27 @@ +// +// Copyright (c) 2022 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 +#include + +BOOST_SQLITE_EXTENSION(simplescalar, conn) +{ + create_scalar_function( + conn, "assert", + [](boost::sqlite::context<>, boost::span sp) + { + if (sp.front().get_int() == 0) + throw std::logic_error("test failed"); + }); + + create_scalar_function( + conn, "my_add", + [](boost::sqlite::context<>, boost::span sp)-> sqlite3_int64 + { + return sp[0].get_int() + sp[1].get_int(); + }); +} diff --git a/test/extension/simple_scalar.sql b/test/extension/simple_scalar.sql new file mode 100644 index 0000000..00064ef --- /dev/null +++ b/test/extension/simple_scalar.sql @@ -0,0 +1,4 @@ +SELECT load_extension('./simple_scalar'); + +select assert(5 = (select my_add(2, 3))); +select assert(7 = (select my_add(4, 3))); -- cgit v1.2.3