feat: add one time passcode columns to users table

coder · DanielleMaywood · Sep 25, 2024 · Sep 25, 2024 · Sep 25, 2024 · Sep 25, 2024
commit f15b16543f0bb7e0b1966d1faf3fc14bfa070aad
diff --git a/coderd/database/dump.sql b/coderd/database/dump.sql
diff --git a/coderd/database/migrations/000258_add_otp_reset_to_user.down.sql b/coderd/database/migrations/000258_add_otp_reset_to_user.down.sql
@@ -0,0 +1,3 @@
+ALTER TABLE users DROP COLUMN hashed_one_time_passcode;
+ALTER TABLE users DROP COLUMN one_time_passcode_expires_at;
+ALTER TABLE users DROP COLUMN must_reset_password;
diff --git a/coderd/database/migrations/000258_add_otp_reset_to_user.up.sql b/coderd/database/migrations/000258_add_otp_reset_to_user.up.sql
@@ -0,0 +1,8 @@
+ALTER TABLE users ADD COLUMN hashed_one_time_passcode bytea;
+COMMENT ON COLUMN users.hashed_one_time_passcode IS 'A hash of the one-time-passcode given to the user.';
+
+ALTER TABLE users ADD COLUMN one_time_passcode_expires_at timestamp with time zone;
+COMMENT ON COLUMN users.one_time_passcode_expires_at IS 'The time when the one-time-passcode expires.';
+
+ALTER TABLE users ADD COLUMN must_reset_password bool NOT NULL DEFAULT false;
+COMMENT ON COLUMN users.must_reset_password IS 'Determines if the user should be forced to change their password.';
diff --git a/coderd/database/modelqueries.go b/coderd/database/modelqueries.go
@@ -364,6 +364,9 @@ func (q *sqlQuerier) GetAuthorizedUsers(ctx context.Context, arg GetUsersParams,
 			&i.ThemePreference,
 			&i.Name,
 			&i.GithubComUserID,
+			&i.HashedOneTimePasscode,
+			&i.OneTimePasscodeExpiresAt,
+			&i.MustResetPassword,
 			&i.Count,
 		); err != nil {
 			return nil, err

diff --git a/coderd/database/models.go b/coderd/database/models.go
diff --git a/coderd/database/queries.sql.go b/coderd/database/queries.sql.go