From 594ee1353ebb6ec46d8a2652270b5f1f8c9f4410 Mon Sep 17 00:00:00 2001
From: Vincent Rischmann
Date: Fri, 1 Jan 2021 22:54:09 +0100
Subject: add a test that binds a string literal

---
 sqlite.zig | 20 ++++++++++++++++++++
 1 file changed, 20 insertions(+)

diff --git a/sqlite.zig b/sqlite.zig
index 2f7db93..1489a0f 100644
--- a/sqlite.zig
+++ b/sqlite.zig
@@ -1289,6 +1289,26 @@ test "sqlite: insert bool and bind bool" {
     testing.expect(b.?);
 }
 
+test "sqlite: bind string literal" {
+    var db: Db = undefined;
+    try db.init(initOptions());
+    try addTestData(&db);
+
+    try db.exec("INSERT INTO article(id, data) VALUES(?, ?)", .{
+        @as(usize, 10),
+        "foobar",
+    });
+
+    const query = "SELECT id FROM article WHERE data = ?";
+
+    var stmt = try db.prepare(query);
+    defer stmt.deinit();
+
+    const b = try stmt.one(usize, .{}, .{"foobar"});
+    testing.expect(b != null);
+    testing.expectEqual(@as(usize, 10), b.?);
+}
+
 test "sqlite: statement reset" {
     var db: Db = undefined;
     try db.init(initOptions());
-- 
cgit v1.2.3