Skip to content

Open-source status page, incident response and uptime monitoring

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

import { monitorMethods } from "../monitors/constants";
import { workspace } from "../workspaces";

export const check = sqliteTable(
  "check",
  {
    id: integer("id").primaryKey({ autoIncrement: true }),
    regions: text("regions").default("").notNull(),
    url: text("url", { length: 4096 }).notNull(),
    headers: text("headers").default(""),
    body: text("body").default(""),
    method: text("method", { enum: monitorMethods }).default("GET"),

    countRequests: integer("count_requests").default(1),

    workspaceId: integer("workspace_id").references(() => workspace.id),

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