blob: 528fb39c61e232e00a7917e5f565252bc3f7e579 (
plain)
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
|
= Extension Modules
This library can also be used to https://www.sqlite.org/loadext.html::[run-time loadable extensions]
that can be used by other applications, e.g. the `sqlite3` CLI.
In order to write this, you'll need to include `boost/sqlite/extension.hpp`,
and write a named module like so:
[source,cpp]
----
BOOST_SQLITE_EXTENSION(testlibrary, conn)
{
// create a function that can be used in the plugin
create_scalar_function(
conn, "assert",
[](boost::sqlite::context<>, boost::span<boost::sqlite::value, 1u> sp)
{
if (sp.front().get_int() == 0)
throw std::logic_error("assertion failed");
});
}
----
[source,sqlite]
----
SELECT load_extension('./test_library');
select assert((3 * 4) = 12);
----
In order to build this, you'll to link against `Boost::sqlite_ext`
instead of `Boost::sqlite`.
Including the `extension.hpp` header will also define
`BOOST_SQLITE_COMPILE_EXTENSION`, which will include `sqlite3ext.h`
instead of `sqlite3.h` and create an inline namespace `ext` inside
`boost::sqlite`.
This prevents linker issues, but will not allow you to mix extension
and non-extension code in one translation unit.
|
