summaryrefslogtreecommitdiff
path: root/README.md
diff options
context:
space:
mode:
Diffstat (limited to 'README.md')
-rw-r--r--README.md18
1 files changed, 10 insertions, 8 deletions
diff --git a/README.md b/README.md
index 7f12093..ac31b25 100644
--- a/README.md
+++ b/README.md
@@ -51,7 +51,7 @@ You must create and initialize an instance of `sqlite.Db`:
51 51
52```zig 52```zig
53var db: sqlite.Db = undefined; 53var db: sqlite.Db = undefined;
54try db.init(allocator, .{ 54try db.init(.{
55 .mode = sqlite.Db.Mode{ .File = "/home/vincent/mydata.db" }, 55 .mode = sqlite.Db.Mode{ .File = "/home/vincent/mydata.db" },
56 .open_flags = .{ 56 .open_flags = .{
57 .write = true, 57 .write = true,
@@ -160,8 +160,8 @@ const row = try stmt.one(
160 .{}, 160 .{},
161 .{ .id = 20 }, 161 .{ .id = 20 },
162); 162);
163if (row) |age| { 163if (row) |row| {
164 std.log.debug("age: {}", .{age}); 164 std.log.debug("name: {}, age: {}", .{std.mem.spanZ(&row.name), row.age});
165} 165}
166``` 166```
167Notice that to read text we need to use a 0-terminated array; if the `name` column is bigger than 127 bytes the call to `one` will fail. 167Notice that to read text we need to use a 0-terminated array; if the `name` column is bigger than 127 bytes the call to `one` will fail.
@@ -193,12 +193,12 @@ const query =
193var stmt = try db.prepare(query); 193var stmt = try db.prepare(query);
194defer stmt.deinit(); 194defer stmt.deinit();
195 195
196const rows = try stmt.all([]const u8, allocator, .{}, .{ 196const names = try stmt.all([]const u8, allocator, .{}, .{
197 .age1 = 20, 197 .age1 = 20,
198 .age2 = 40, 198 .age2 = 40,
199}); 199});
200for (rows) |row| { 200for (names) |name| {
201 std.log.debug("id: {} ; name: {}; age: {}; salary: {}", .{ row.id, row.name, row.age, row.salary }); 201 std.log.debug("name: {}", .{ row.name });
202} 202}
203``` 203```
204 204
@@ -212,10 +212,12 @@ const query =
212var stmt = try db.prepare(query); 212var stmt = try db.prepare(query);
213defer stmt.deinit(); 213defer stmt.deinit();
214 214
215const name = try stmt.oneAlloc([]const u8, allocator, .{}, .{ 215const row = try stmt.oneAlloc([]const u8, allocator, .{}, .{
216 .id = 200, 216 .id = 200,
217}); 217});
218std.log.debug("name: {}", .{name}); 218if (row) |name| {
219 std.log.debug("name: {}", .{name});
220}
219``` 221```
220 222
221## Iterating 223## Iterating