From e21c194861198f298af34ac07032c04979ac5c1e Mon Sep 17 00:00:00 2001 From: physcik Date: Tue, 14 Apr 2026 17:04:21 +0500 Subject: get ranged weapons by id --- backend/src/Database/RangedWeaponsAccessLayer.zig | 15 +++++++++++---- 1 file changed, 11 insertions(+), 4 deletions(-) (limited to 'backend/src/Database/RangedWeaponsAccessLayer.zig') diff --git a/backend/src/Database/RangedWeaponsAccessLayer.zig b/backend/src/Database/RangedWeaponsAccessLayer.zig index ed35064..ca41197 100644 --- a/backend/src/Database/RangedWeaponsAccessLayer.zig +++ b/backend/src/Database/RangedWeaponsAccessLayer.zig @@ -13,12 +13,19 @@ pub fn GetAll(alloc: std.mem.Allocator) !std.ArrayList(model.RangedWeaponType) { var outp: std.ArrayList(model.RangedWeaponType) = .empty; while (try result.next()) |row| { - const newRW = try model.RangedWeaponType.Map(&row); + const newRW = try model.RangedWeaponType.MapWithAlloc(alloc, &row); try outp.append(alloc, newRW); } return outp; } -// pub fn GetByDisplayName(alloc: std.mem.Allocator, displayName: []const u8) !model.RangedWeaponType { - // const query = "SELECT * FROM RangedWeapons WHERE Id = "; -// } +pub fn GetByDisplayName(allocator: std.mem.Allocator, displayName: []const u8) !model.RangedWeaponType { + const query = "SELECT * FROM RangedWeapons WHERE Id = $1"; + var row = try conn.pool.row(query, .{displayName}) orelse { + return conn.ResultErrors.NotFound; + }; + + const outp = try model.RangedWeaponType.MapWithAlloc(allocator, &row.row); + try row.deinit(); + return outp; +} -- cgit v1.3