1 reply

sqlitetable circular reference

I'm trying to create a self referencing table using sqlite, here is what I'm doing

export const forms = sqliteTable("forms", {
  id: int("id").primaryKey(),
  name: text("name").notNull(),
  description: text("description"),
  categoryId: int("category_id").references(() => categories.id),
  slug: text("slug").notNull(),
  version: text("version").notNull().default("1.0"),
  active: integer("active", { mode: "boolean" }).notNull().default(true),
  parentFormId: int("parent_form_id").references(() => forms.id),
  createdAt: integer("created_at", { mode: "timestamp" })
    .notNull()
    .default(sql`CURRENT_TIMESTAMP`),
});

export const forms = sqliteTable("forms", {
  id: int("id").primaryKey(),
  name: text("name").notNull(),
  description: text("description"),
  categoryId: int("category_id").references(() => categories.id),
  slug: text("slug").notNull(),
  version: text("version").notNull().default("1.0"),
  active: integer("active", { mode: "boolean" }).notNull().default(true),
  parentFormId: int("parent_form_id").references(() => forms.id),
  createdAt: integer("created_at", { mode: "timestamp" })
    .notNull()
    .default(sql`CURRENT_TIMESTAMP`),
});

but I'm getting this type error
Function implicitly has return type 'any' because it does not have a return type annotation and is referenced directly or indirectly in one of its return expressions.ts(7024)

Is there any way to structure this to to remove the TS warning?

Drizzle Team•15mo ago•

1 reply

rogueturnip

sqlitetable circular reference

I'm trying to create a self referencing table using sqlite, here is what I'm doing

export const forms = sqliteTable("forms", {
  id: int("id").primaryKey(),
  name: text("name").notNull(),
  description: text("description"),
  categoryId: int("category_id").references(() => categories.id),
  slug: text("slug").notNull(),
  version: text("version").notNull().default("1.0"),
  active: integer("active", { mode: "boolean" }).notNull().default(true),
  parentFormId: int("parent_form_id").references(() => forms.id),
  createdAt: integer("created_at", { mode: "timestamp" })
    .notNull()
    .default(sql`CURRENT_TIMESTAMP`),
});

export const forms = sqliteTable("forms", {
  id: int("id").primaryKey(),
  name: text("name").notNull(),
  description: text("description"),
  categoryId: int("category_id").references(() => categories.id),
  slug: text("slug").notNull(),
  version: text("version").notNull().default("1.0"),
  active: integer("active", { mode: "boolean" }).notNull().default(true),
  parentFormId: int("parent_form_id").references(() => forms.id),
  createdAt: integer("created_at", { mode: "timestamp" })
    .notNull()
    .default(sql`CURRENT_TIMESTAMP`),
});

sqlitetable circular reference

Similar Threads

sqlitetable circular reference

Similar Threads

Similar Threads

Similar Threads