petja Comments - Answer Overflow

petja

•Created by petja on 8/16/2024 in #help

Is there more elegant way to infer enums?

Made this utility type for myself: export type EnumValues<T extends PgEnum<any>> = T['enumValues'] extends Array<infer U> ? U : never;

2 replies

DTDrizzle Team

•Created by MAST on 6/14/2023 in #help

Has anyone done a custom `bytea` column type for postgres?

export const bytea = customType<{ data: Buffer }>({
  dataType() {
    return "bytea";
  },
  fromDriver(value) {
    if (typeof value === "object" && value instanceof Uint8Array) {
      return Buffer.from(value);
    }

    throw new Error("Expected Uint8Array");
  },
  toDriver(buffer) {
    return sql`decode(${buffer.toString("base64")}, 'base64')`;
  },
});

export const bytea = customType<{ data: Buffer }>({
  dataType() {
    return "bytea";
  },
  fromDriver(value) {
    if (typeof value === "object" && value instanceof Uint8Array) {
      return Buffer.from(value);
    }

    throw new Error("Expected Uint8Array");
  },
  toDriver(buffer) {
    return sql`decode(${buffer.toString("base64")}, 'base64')`;
  },
});