DT
Drizzle Teamethan<3

Issue with JSON + TypScript

Here's my code: 
.findFirst({ where: eq(globalBans.offender.id, userID) });
.findFirst({ where: eq(globalBans.offender.id, userID) });
Here's my schema: 
interface GlobalBanUser {
  id: string;
  username: string;
  avatar: string;
};

export const globalBans = pgTable("global_bans", {
  offender: json("offender").notNull().$type<GlobalBanUser>(),
  reason: text("reason").notNull(),
  evidence: json("evidence").notNull().$type<string[]>(),
  moderator: json("moderator").notNull().$type<GlobalBanUser>(),
  notes: text("notes").notNull(),
  date: timestamp("date", { mode: "date" }).defaultNow()
});
interface GlobalBanUser {
  id: string;
  username: string;
  avatar: string;
};

export const globalBans = pgTable("global_bans", {
  offender: json("offender").notNull().$type<GlobalBanUser>(),
  reason: text("reason").notNull(),
  evidence: json("evidence").notNull().$type<string[]>(),
  moderator: json("moderator").notNull().$type<GlobalBanUser>(),
  notes: text("notes").notNull(),
  date: timestamp("date", { mode: "date" }).defaultNow()
});
Here's my error: 
Property 'id' does not exist on type 'PgColumn<{ name: "offender"; tableName: "global_bans"; dataType: "json"; columnType: "PgJson"; data: GlobalBanUser; driverParam: unknown; notNull: true; hasDefault: false; enumValues: undefined; baseColumn: never; }, {}, {}>'.
Property 'id' does not exist on type 'PgColumn<{ name: "offender"; tableName: "global_bans"; dataType: "json"; columnType: "PgJson"; data: GlobalBanUser; driverParam: unknown; notNull: true; hasDefault: false; enumValues: undefined; baseColumn: never; }, {}, {}>'.
B
Ben-ificient•17d ago
You didn't explicitly define your id column so it wonn't exist in your interface
Want results from more Discord servers?
Add your server
More Posts
how to get auto increment to work sqlitehave attached the relevant snippets for dissection. cannot get the auto-increment function to work. using unions with "with" clauseI am trying to do something like the following, but cant figure out how to do this with drizzle syntts: Object literal may only specify known properties except the property is known``` No overload matches this call. Overload 2 of 2, '(values: { role: string | SQL<unknown> | Placerror: no schema has been selected to create in while running push commandtrying to setup drizzle with local postgres database, DB_CONN_STRING is 'postgres://postgres:passwor