Something went wrong. Try again.
Native PostgreSQL driver / client for Zig
Something went wrong. Try again.
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242const std = @import("std");
const Allocator = std.mem.Allocator;const Conn = @import("conn.zig").Conn;
pub const allocator = std.testing.allocator;
pub var arena = std.heap.ArenaAllocator.init(allocator);
pub fn reset() void { _ = arena.reset(.free_all);}
// std.testing.expectEqual won't coerce expected to actual, which is a problem// when expected is frequently a comptime.// https://github.com/ziglang/zig/issues/4437pub fn expectEqual(expected: anytype, actual: anytype) !void { try std.testing.expectEqual(@as(@TypeOf(actual), expected), actual);}pub fn expectDelta(expected: anytype, actual: anytype, delta: anytype) !void { expectEqual(true, expected - delta <= actual) catch |err| { std.debug.print("{d} !~ {d}", .{ expected, actual }); return err; }; expectEqual(true, expected + delta >= actual) catch |err| { std.debug.print("{d} !~ {d}", .{ expected, actual }); return err; };}pub const expectError = std.testing.expectError;pub const expectSlice = std.testing.expectEqualSlices;pub const expectString = std.testing.expectEqualStrings;pub fn expectStringSlice(expected: []const []const u8, actual: [][]const u8) !void { try expectEqual(expected.len, actual.len); for (expected, actual) |e, a| { try expectString(e, a); }}
pub fn getRandom() std.Random.DefaultPrng { var seed: u64 = undefined; std.posix.getrandom(std.mem.asBytes(&seed)) catch unreachable; return std.Random.DefaultPrng.init(seed);}
pub fn setup() !void { var c = connect(.{}); defer c.deinit(); _ = c.exec( \\ drop user if exists pgz_user_nopass; \\ drop user if exists pgz_user_clear; \\ drop user if exists pgz_user_scram_sha256; \\ drop user if exists pgz_user_ssl; \\ create user pgz_user_nopass; \\ create user pgz_user_clear with password 'pgz_user_clear_pw'; \\ create user pgz_user_scram_sha256 with password 'pgz_user_scram_sha256_pw'; \\ create user pgz_user_ssl with password 'pgz_user_ssl_pw'; , .{}) catch |err| try fail(c, err);
_ = c.exec( \\ drop table if exists simple_table; \\ create table simple_table (value text); , .{}) catch |err| try fail(c, err);
_ = c.exec( \\ drop type if exists custom_enum cascade; \\ create type custom_enum as enum ('val1', 'val2'); , .{}) catch |err| try fail(c, err);
_ = c.exec( \\ drop table if exists all_types; \\ create table all_types ( \\ id integer primary key, \\ col_int2 smallint, \\ col_int4 integer, \\ col_int8 bigint, \\ col_float4 float4, \\ col_float8 float8, \\ col_bool bool, \\ col_text text, \\ col_bytea bytea, \\ col_int2_arr smallint[], \\ col_int4_arr integer[], \\ col_int8_arr bigint[], \\ col_float4_arr float4[], \\ col_float8_arr float[], \\ col_bool_arr bool[], \\ col_text_arr text[], \\ col_bytea_arr bytea[], \\ col_enum custom_enum, \\ col_enum_arr custom_enum[], \\ col_uuid uuid, \\ col_uuid_arr uuid[], \\ col_numeric numeric, \\ col_numeric_arr numeric[], \\ col_timestamp timestamp, \\ col_timestamp_arr timestamp[], \\ col_json json, \\ col_json_arr json[], \\ col_jsonb jsonb, \\ col_jsonb_arr jsonb[], \\ col_char char, \\ col_char_arr char[], \\ col_charn char(3), \\ col_charn_arr char(2)[], \\ col_timestamptz timestamptz, \\ col_timestamptz_arr timestamptz[], \\ col_cidr cidr, \\ col_cidr_arr cidr[], \\ col_inet inet, \\ col_inet_arr inet[], \\ col_macaddr macaddr, \\ col_macaddr_arr macaddr[], \\ col_macaddr8 macaddr8, \\ col_macaddr8_arr macaddr8[] \\ ); , .{}) catch |err| try fail(c, err);}
// Dummy net.Stream, lets us setup data to be read and capture data that is written.pub const Stream = struct { closed: bool, _read_index: usize, socket: c_int = 0, _to_read: std.ArrayList(u8), _received: std.ArrayList(u8),
pub fn init() *Stream { const s = allocator.create(Stream) catch unreachable; s.* = .{ .closed = false, ._read_index = 0, ._to_read = std.ArrayList(u8).init(allocator), ._received = std.ArrayList(u8).init(allocator), }; return s; }
pub fn deinit(self: *Stream) void { self._to_read.deinit(); self._received.deinit(); allocator.destroy(self); }
pub fn reset(self: *Stream) void { self._read_index = 0; self._to_read.clearRetainingCapacity(); self._received.clearRetainingCapacity(); }
pub fn received(self: *Stream) []const u8 { return self._received.items; }
pub fn add(self: *Stream, value: []const u8) void { self._to_read.appendSlice(value) catch unreachable; }
pub fn read(self: *Stream, buf: []u8) !usize { std.debug.assert(!self.closed);
const read_index = self._read_index; const items = self._to_read.items;
if (read_index == items.len) { return 0; } if (buf.len == 0) { return 0; }
// let's fragment this message const left_to_read = items.len - read_index; const max_can_read = if (buf.len < left_to_read) buf.len else left_to_read;
const to_read = max_can_read; var data = items[read_index..(read_index + to_read)]; if (data.len > buf.len) { // we have more data than we have space in buf (our target) // we'll give it when it can take data = data[0..buf.len]; } self._read_index = read_index + data.len;
@memcpy(buf[0..data.len], data); return data.len; }
// store messages that are written to the stream pub fn writeAll(self: *Stream, data: []const u8) !void { self._received.appendSlice(data) catch unreachable; }
pub fn close(self: *Stream) void { self.closed = true; }};
pub fn connect(opts: anytype) Conn { const T = @TypeOf(opts);
var c = Conn.open(allocator, .{ .tls = if (@hasField(T, "tls")) opts.tls else .off, .host = if (@hasField(T, "host")) opts.host else "localhost", .read_buffer = if (@hasField(T, "read_buffer")) opts.read_buffer else 2000, }) catch unreachable;
c.auth(authOpts(opts)) catch |err| { if (c.err) |pg| { @panic(pg.message); } @panic(@errorName(err)); }; return c;}
pub fn authOpts(opts: anytype) Conn.AuthOpts { const T = @TypeOf(opts); return .{ .database = if (@hasField(T, "database")) opts.database else "postgres", .username = if (@hasField(T, "username")) opts.username else "postgres", .password = if (@hasField(T, "password")) opts.password else "postgres", };}
pub fn fail(c: Conn, err: anyerror) !void { if (c.err) |pg_err| { std.debug.print("PG ERROR: {s}\n", .{pg_err.message}); } return err;}
pub fn scalar(c: *Conn, sql: []const u8) i32 { var result = c.query(sql, .{}) catch unreachable; defer result.deinit();
const row = (result.next() catch unreachable).?; const value = row.get(i32, 0); result.drain() catch unreachable; return value;}