add the virtual table implementation

1 files changed, 25 insertions, 0 deletions

diff --git a/sqlite.zig b/sqlite.zig
index 09e13ba..1fe8aea 100644
--- a/sqlite.zig
+++ b/sqlite.zig
@@ -20,8 +20,13 @@ const getLastDetailedErrorFromDb = errors.getLastDetailedErrorFromDb;
 const getDetailedErrorFromResultCode = errors.getDetailedErrorFromResultCode;
 
 const getTestDb = @import("test.zig").getTestDb;
+pub const vtab = @import("vtab.zig");
 const helpers = @import("helpers.zig");
 
+test {
+    _ = @import("vtab.zig");
+}
+
 const logger = std.log.scoped(.sqlite);
 
 /// Text is used to represent a SQLite TEXT value when binding a parameter or reading a column.
@@ -787,6 +792,26 @@ pub const Db = struct {
             try stmt.exec(new_options, .{});
         }
     }
+
+    pub fn createVirtualTable(
+        self: *Self,
+        comptime name: [:0]const u8,
+        module_context: *vtab.ModuleContext,
+        comptime Table: type,
+    ) !void {
+        const VirtualTableType = vtab.VirtualTable(name, Table);
+
+        const result = c.sqlite3_create_module_v2(
+            self.db,
+            name,
+            &VirtualTableType.module,
+            module_context,
+            null,
+        );
+        if (result != c.SQLITE_OK) {
+            return errors.errorFromResultCode(result);
+        }
+    }
 };
 
 /// FunctionContext is the context passed as first parameter in the `step` and `finalize` functions used with `createAggregateFunction`.