Merge pull request #13 from vrischmann/bind-string-literal

Bind string literal

1 files changed, 27 insertions, 3 deletions

diff --git a/sqlite.zig b/sqlite.zig
index 2f7db93..3335309 100644
--- a/sqlite.zig
+++ b/sqlite.zig
@@ -722,9 +722,6 @@ pub fn Statement(comptime opts: StatementOptions, comptime query: ParsedQuery) t
             const column = i + 1;
 
             switch (FieldType) {
-                []const u8, []u8 => {
-                    _ = c.sqlite3_bind_text(self.stmt, column, field.ptr, @intCast(c_int, field.len), null);
-                },
                 Text => _ = c.sqlite3_bind_text(self.stmt, column, field.data.ptr, @intCast(c_int, field.data.len), null),
                 Blob => _ = c.sqlite3_bind_blob(self.stmt, column, field.data.ptr, @intCast(c_int, field.data.len), null),
                 else => switch (field_type_info) {
@@ -732,6 +729,13 @@ pub fn Statement(comptime opts: StatementOptions, comptime query: ParsedQuery) t
                     .Float, .ComptimeFloat => _ = c.sqlite3_bind_double(self.stmt, column, field),
                     .Bool => _ = c.sqlite3_bind_int64(self.stmt, column, @boolToInt(field)),
                     .Pointer => |ptr| switch (ptr.size) {
+                        .One => self.bindField(ptr.child, field_name, i, field.*),
+                        .Slice => switch (ptr.child) {
+                            u8 => {
+                                _ = c.sqlite3_bind_text(self.stmt, column, field.ptr, @intCast(c_int, field.len), null);
+                            },
+                            else => @compileError("cannot bind field " ++ field_name ++ " of type " ++ @typeName(FieldType)),
+                        },
                         else => @compileError("cannot bind field " ++ field_name ++ " of type " ++ @typeName(FieldType)),
                     },
                     .Array => |arr| {
@@ -1289,6 +1293,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());