Skip to content

Open-source status page, incident response and uptime monitoring

1.5 KB
Raw Blame
import { relations, sql } from "drizzle-orm";
import { index, integer, sqliteTable, text } from "drizzle-orm/sqlite-core";

import { pageComponent } from "../page_components";
import { page } from "../pages";
import { workspace } from "../workspaces";

export const pageComponentGroup = sqliteTable(
  "page_component_groups",
  {
    id: integer("id").primaryKey(),
    workspaceId: integer("workspace_id")
      .references(() => workspace.id, { onDelete: "cascade" })
      .notNull(),
    pageId: integer("page_id")
      .references(() => page.id, { onDelete: "cascade" })
      .notNull(),
    name: text("name").notNull(),

    defaultOpen: integer("default_open", { mode: "boolean" })
      .default(false)
      .notNull(),

    createdAt: integer("created_at", { mode: "timestamp" }).default(
      sql`(strftime('%s', 'now'))`,
    ),
    updatedAt: integer("updated_at", { mode: "timestamp" }).default(
      sql`(strftime('%s', 'now'))`,
    ),
  },
  (t) => [
    index("page_component_groups_page_id_idx").on(t.pageId),
    index("page_component_groups_workspace_id_idx").on(t.workspaceId),
  ],
);

export const pageComponentGroupRelations = relations(
  pageComponentGroup,
  ({ one, many }) => ({
    workspace: one(workspace, {
      fields: [pageComponentGroup.workspaceId],
      references: [workspace.id],
    }),
    page: one(page, {
      fields: [pageComponentGroup.pageId],
      references: [page.id],
    }),
    pageComponents: many(pageComponent),
  }),
);