Skip to content

Commit 5dceee8

Browse files
ammarioammario
committed
Add database
1 parent b64f624 commit 5dceee8

File tree

7 files changed

+70
-9
lines changed

7 files changed

+70
-9
lines changed

‎coderd/database/dump.sql

Lines changed: 2 additions & 1 deletion
Some generated files are not rendered by default. Learn more about customizing how changed files appear on GitHub.

‎coderd/database/migrations/000053_last_seen_at.down.sql

Lines changed: 3 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,3 @@
1+
ALTER TABLE ONLY users
2+
DROP COLUMN last_seen_at;
3+

‎coderd/database/migrations/000053_last_seen_at.up.sql

Lines changed: 2 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,2 @@
1+
ALTER TABLE ONLY users
2+
ADD COLUMN last_seen_at timestamp NOT NULL DEFAULT '0001-01-01 00:00:00+00:00';

‎coderd/database/models.go

Lines changed: 1 addition & 0 deletions
Some generated files are not rendered by default. Learn more about customizing how changed files appear on GitHub.

‎coderd/database/querier.go

Lines changed: 1 addition & 0 deletions
Some generated files are not rendered by default. Learn more about customizing how changed files appear on GitHub.

‎coderd/database/queries.sql.go

Lines changed: 52 additions & 8 deletions
Some generated files are not rendered by default. Learn more about customizing how changed files appear on GitHub.

‎coderd/database/queries/users.sql

Lines changed: 9 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -157,6 +157,15 @@ SET
157157
WHERE
158158
id = $1 RETURNING *;
159159

160+
-- name: UpdateUserLastSeenAt :one
161+
UPDATE
162+
users
163+
SET
164+
last_seen_at = $2,
165+
updated_at = $3
166+
WHERE
167+
id = $1 RETURNING *;
168+
160169

161170
-- name: GetAuthorizationUserRoles :one
162171
-- This function returns roles for authorization purposes. Implied member roles

0 commit comments

Comments
 (0)