From 97efd2a3740412ec78a018da4fe068c141c9d1ec Mon Sep 17 00:00:00 2001 From: Lizzy Hunt Date: Wed, 27 Mar 2024 15:10:39 -0600 Subject: clean up old sessions every 500 seconds --- database/users.go | 9 +++++++++ 1 file changed, 9 insertions(+) (limited to 'database/users.go') 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 +} -- cgit v1.2.3-70-g09d2