add metadata logic to db

defelmnq · defelmnq · commit 893c54c776d9 · 2025-01-27T11:16:44.000Z
diff --git a/coderd/database/migrations/000288_agent_resource_monitors.down.sql b/coderd/database/migrations/000288_agent_resource_monitors.down.sql
@@ -0,0 +1,3 @@
+DROP TABLE IF EXISTS agent_resources_monitoring;
+
+DROP TYPE IF EXISTS resource_monitoring_type;
diff --git a/coderd/database/migrations/000288_agent_resource_monitors.up.sql b/coderd/database/migrations/000288_agent_resource_monitors.up.sql
@@ -0,0 +1,11 @@
+CREATE TYPE workspace_agent_monitored_resource_type AS ENUM ('memory', 'volume');
+
+
+CREATE TABLE workspace_agent_resource_monitors (
+	agent_id uuid NOT NULL,
+	rtype workspace_agent_monitored_resource_type NOT NULL,
+	enabled boolean NOT NULL,
+	threshold integer NOT NULL,
+	metadata jsonb DEFAULT'{}'::jsonb NOT NULL,
+	created_at timestamp with time zone NOT NULL
+);
diff --git a/coderd/database/queries/workspaceagentresourcemonitors.sql b/coderd/database/queries/workspaceagentresourcemonitors.sql
@@ -0,0 +1,20 @@
+-- name: FetchAgentResourceMonitorsByAgentID :one
+SELECT
+	*
+FROM
+	workspace_agent_resource_monitors
+WHERE
+	agent_id = $1;
+
+-- name: InsertWorkspaceAgentResourceMonitor :one
+INSERT INTO
+	workspace_agent_resource_monitors (
+		agent_id,
+		rtype,
+		enabled,
+		threshold,
+		metadata,
+		created_at
+	)
+VALUES
+	($1, $2, $3, $4, $5, $6) RETURNING *;

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,3 @@`
	`1`	`+DROP TABLE IF EXISTS agent_resources_monitoring;`
	`2`	`+`
	`3`	`+DROP TYPE IF EXISTS resource_monitoring_type;`