diff options
| author | Lizzy Hunt <lizzy.hunt@usu.edu> | 2024-03-27 15:10:39 -0600 |
|---|---|---|
| committer | Lizzy Hunt <lizzy.hunt@usu.edu> | 2024-03-27 15:10:39 -0600 |
| commit | 97efd2a3740412ec78a018da4fe068c141c9d1ec (patch) | |
| tree | 73904689d6c69898bd834533d33b65106b14ce3e /database/users.go | |
| parent | 0dc2679005e70c50024bc49e750f3998a0c4c24b (diff) | |
| download | hatecomputers.club-97efd2a3740412ec78a018da4fe068c141c9d1ec.tar.gz hatecomputers.club-97efd2a3740412ec78a018da4fe068c141c9d1ec.zip | |
clean up old sessions every 500 seconds
Diffstat (limited to 'database/users.go')
| -rw-r--r-- | database/users.go | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/database/users.go b/database/users.go index 1ba4ebb..d2b4f20 100644 --- a/database/users.go +++ b/database/users.go @@ -110,3 +110,12 @@ func RefreshSession(dbConn *sql.DB, sessionId string) (*UserSession, error) { return session, nil } + +func DeleteExpiredSessions(dbConn *sql.DB) error { + _, err := dbConn.Exec(`DELETE FROM user_sessions WHERE expire_at < ?;`, time.Now()) + if err != nil { + log.Println(err) + return err + } + return nil +} |