Trying to implement openid

app/Controllers/cron.ts

+import AuthCodeVerifier from 'App/Models/AuthCodeVerifier'
+
+const sqlRequest = "created_at > current_date - interval '1' hour"
+
+/** Remove old code verifiers from the database `AuthCodeVerifier`
+ * Code verifiers must be stored between the moment:
+ *  - the user ask for a login to `auth.binets.fr`: codeVerifier is created
+ *  - the user as entered his login: codeVerifier is deleted
+ *
+ * => If the user never enter his login, codeVerifier is never deleted.
+ *  Therefor we need to execute this cron regularly
+ *
+ * Note: Using `node-schedule` might be great but doesn't scale when on multiprocess
+ * */
+export const cronRemoveOldCodeVerifiers = async ({ response }) => {
+  const willBeDeleted = await AuthCodeVerifier.query().whereRaw(sqlRequest)
+  await AuthCodeVerifier.query().delete().whereRaw(sqlRequest)
+
+  return response.ok({
+    message: 'Old code verifiers successfully deleted',
+    numberOfDeleted: willBeDeleted.length,
+  })
+}