Mozzy Posts - Answer Overflow

Mozzy

Explore posts from servers

DIAdiscord.js - Imagine an app CDCloudflare Developers RRailway DTDrizzle Team

•Created by Mozzy on 10/8/2024 in #help

Changing the Postgres serial/autoincrement behavior

In short, I don't want the serial to fill the empty gaps. I want it to always default to max(id) + 1 unless I specify the id myself. How can I achieve this with minimum jank? I've heard of generated columns, but couldn't get it all working together. I believe MySQL works like this, so I might have to switch to that.

2 replies

DTDrizzle Team

•Created by Mozzy on 10/3/2024 in #help

`Error: no such column: unboxes.rarity` with `findMany()`

Hello. I am getting the error Error: no such column: unboxes.rarity despite not using unboxes.rarity The error comes fron the where in the query below. Is this a bug? Code:

export const getFilteredUnboxes = async (onlyCoverts?: boolean) =>
  db.query.unboxes.findMany({
    with: {
      item: true,
      case: true,
    },
    where: onlyCoverts
      ? inArray(items.rarity, ["Covert", "Extraordinary"])
      : undefined,
  });

export const getFilteredUnboxes = async (onlyCoverts?: boolean) =>
  db.query.unboxes.findMany({
    with: {
      item: true,
      case: true,
    },
    where: onlyCoverts
      ? inArray(items.rarity, ["Covert", "Extraordinary"])
      : undefined,
  });

My items schema:

export const items = sqliteTable(
  "items",
  {
    id: text("id").primaryKey().notNull(),
    name: text("name").notNull(),
    description: text("description"),
    image: text("image").notNull(),
    rarity: text("rarity").notNull(),
    phase: text("phase"),
  },
  table => {
    return {
      idxRarity: index("idx_rarity").on(table.rarity),
    };
  },
);

export const items = sqliteTable(
  "items",
  {
    id: text("id").primaryKey().notNull(),
    name: text("name").notNull(),
    description: text("description"),
    image: text("image").notNull(),
    rarity: text("rarity").notNull(),
    phase: text("phase"),
  },
  table => {
    return {
      idxRarity: index("idx_rarity").on(table.rarity),
    };
  },
);

32 replies

Gaming

Programming