Open-source status page, incident response and uptime monitoring
TypeScript alertingincident-managementmcpmcp-servermonitoringmonitoring-as-codeobservabilityon-callopen-sourcesrestatus-pagestatuspagesynthetic-monitoringterraformtinybirdtursouptimeuptime-checkeruptime-monitor
import { relations, sql } from "drizzle-orm";
import {
index,
integer,
primaryKey,
sqliteTable,
text,
} from "drizzle-orm/sqlite-core";
import { monitor, monitorStatus as monitorStatusEnum } from "../monitors";
export const monitorStatusTable = sqliteTable(
"monitor_status",
{
monitorId: integer("monitor_id")
.references(() => monitor.id, { onDelete: "cascade" })
.notNull(),
region: text("region").default("").notNull(),
status: text("status", { enum: monitorStatusEnum })
.default("active")
.notNull(),
cronTimestamp: integer("cron_timestamp").notNull().default(0),
createdAt: integer("created_at", { mode: "timestamp" }).default(
sql`(strftime('%s', 'now'))`,
),
updatedAt: integer("updated_at", { mode: "timestamp" }).default(
sql`(strftime('%s', 'now'))`,
),
},
(table) => {
return {
primaryKey: primaryKey({ columns: [table.monitorId, table.region] }),
monitorStatusIdx: index("monitor_status_idx").on(
table.monitorId,
table.region,
),
};
},
);
export const monitorStatusRelations = relations(
monitorStatusTable,
({ one }) => ({
monitor: one(monitor, {
fields: [monitorStatusTable.monitorId],
references: [monitor.id],
}),
}),
);