ranged weapons db connection

1 files changed, 20 insertions, 0 deletions

diff --git a/backend/src/Database/RangedWeaponsAccessLayer.zig b/backend/src/Database/RangedWeaponsAccessLayer.zig
new file mode 100644
index 0000000..a99d1c1
--- /dev/null
+++ b/backend/src/Database/RangedWeaponsAccessLayer.zig
@@ -0,0 +1,20 @@
+// You are not supposed to include this file. To access this you should use
+// Connection.RangedWeapons. 
+
+const conn = @import("Connection.zig");
+const std = @import("std");
+const pg = @import("pg");
+const model = @import("../Models/RangedWeapon.zig");
+
+pub fn GetAll(alloc: std.mem.Allocator) !std.ArrayList(model.RangedWeaponType) {
+    const query = "SELECT * FROM RangedWeapons";
+    var result = try conn.pool.query(query, .{});
+    defer _ = result.deinit();
+
+    var outp: std.ArrayList(model.RangedWeaponType) = .empty;
+    while (try result.next()) |row| {
+        const newRW = try model.RangedWeaponType.Map(&row);
+        try outp.append(alloc, newRW);
+    }
+    return outp;
+}