Method validate

lib/models/user.ts:272–304

(
    user: User,
    verificationId: string,
    code: string,
    type: VerificationCode['verification']['type'],
  )

  }

  static async validate(
    user: User,
    verificationId: string,
    code: string,
    type: VerificationCode['verification']['type'],
  ) {
    const verificationCode = (await db.query<VerificationCode>(
      sql`SELECT * FROM "bewcloud_verification_codes"
        WHERE "user_id" = $1 AND
          "code" = $2 AND
          "verification" ->> 'type' = $3 AND
          "verification" ->> 'id' = $4 AND 
          "expires_at" > now()
        LIMIT 1`,
      [
        user.id,
        code,
        type,
        verificationId,
      ],
    ))[0];

    if (verificationCode) {
      await db.query(
        sql`DELETE FROM "bewcloud_verification_codes" WHERE "id" = $1`,
        [
          verificationCode.id,
        ],
      );
    } else {
      throw new Error('Not Found');
    }
  }
}