Add database

coder · ammario · Sep 26, 2022 · Sep 23, 2022 · Sep 24, 2022 · Sep 24, 2022
commit 841a99c8334ca1655737c14ade3ac7670e5daf6e
diff --git a/coderd/database/dump.sql b/coderd/database/dump.sql
diff --git a/coderd/database/migrations/000053_last_seen_at.down.sql b/coderd/database/migrations/000053_last_seen_at.down.sql
@@ -0,0 +1,3 @@
+ALTER TABLE ONLY users
+	DROP COLUMN last_seen_at;
+
diff --git a/coderd/database/migrations/000053_last_seen_at.up.sql b/coderd/database/migrations/000053_last_seen_at.up.sql
@@ -0,0 +1,2 @@
+ALTER TABLE ONLY users
+	ADD COLUMN last_seen_at timestamp NOT NULL DEFAULT '0001-01-01 00:00:00+00:00';
diff --git a/coderd/database/models.go b/coderd/database/models.go
diff --git a/coderd/database/querier.go b/coderd/database/querier.go
diff --git a/coderd/database/queries.sql.go b/coderd/database/queries.sql.go
diff --git a/coderd/database/queries/users.sql b/coderd/database/queries/users.sql
@@ -157,6 +157,15 @@ SET
 WHERE
 	id = $1 RETURNING *;
 
+-- name: UpdateUserLastSeenAt :one
+UPDATE
+	users
+SET
+	last_seen_at = $2,
+	updated_at = $3
+WHERE
+	id = $1 RETURNING *;
+
 
 -- name: GetAuthorizationUserRoles :one
 -- This function returns roles for authorization purposes. Implied member roles
Original file line number	Diff line number	Diff line change
		@@ -0,0 +1,2 @@
		ALTER TABLE ONLY users
		ADD COLUMN last_seen_at timestamp NOT NULL DEFAULT '0001-01-01 00:00:00+00:00';