diff options
Diffstat (limited to 'README.md')
| -rw-r--r-- | README.md | 18 |
1 files changed, 10 insertions, 8 deletions
| @@ -51,7 +51,7 @@ You must create and initialize an instance of `sqlite.Db`: | |||
| 51 | 51 | ||
| 52 | ```zig | 52 | ```zig |
| 53 | var db: sqlite.Db = undefined; | 53 | var db: sqlite.Db = undefined; |
| 54 | try db.init(allocator, .{ | 54 | try 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 | ); |
| 163 | if (row) |age| { | 163 | if (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 | ``` |
| 167 | Notice 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. | 167 | Notice 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 = | |||
| 193 | var stmt = try db.prepare(query); | 193 | var stmt = try db.prepare(query); |
| 194 | defer stmt.deinit(); | 194 | defer stmt.deinit(); |
| 195 | 195 | ||
| 196 | const rows = try stmt.all([]const u8, allocator, .{}, .{ | 196 | const names = try stmt.all([]const u8, allocator, .{}, .{ |
| 197 | .age1 = 20, | 197 | .age1 = 20, |
| 198 | .age2 = 40, | 198 | .age2 = 40, |
| 199 | }); | 199 | }); |
| 200 | for (rows) |row| { | 200 | for (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 = | |||
| 212 | var stmt = try db.prepare(query); | 212 | var stmt = try db.prepare(query); |
| 213 | defer stmt.deinit(); | 213 | defer stmt.deinit(); |
| 214 | 214 | ||
| 215 | const name = try stmt.oneAlloc([]const u8, allocator, .{}, .{ | 215 | const row = try stmt.oneAlloc([]const u8, allocator, .{}, .{ |
| 216 | .id = 200, | 216 | .id = 200, |
| 217 | }); | 217 | }); |
| 218 | std.log.debug("name: {}", .{name}); | 218 | if (row) |name| { |
| 219 | std.log.debug("name: {}", .{name}); | ||
| 220 | } | ||
| 219 | ``` | 221 | ``` |
| 220 | 222 | ||
| 221 | ## Iterating | 223 | ## Iterating |