feat: soft delete sessions when logout

[rsbh]

This PR will change the behavior of the sessions table row delete method in the logout API call. Currently, the row has been deleted from the table in the logout call. This PR will make it a soft delete. There is already a cron job that deletes all expired sessions so that the soft-deleted session will be cleaned by the same cron.

We need the session data for the analytics, like to get the user who logged in last week or month.

[vercel[bot]]

The latest updates on your projects. Learn more about Vercel for Git ↗︎

Name	Status	Preview	Comments	Updated (UTC)
frontier	✅ Ready (Inspect)	Visit Preview	💬 Add feedback	Jul 2, 2024 5:44pm

[coveralls]

Pull Request Test Coverage Report for Build 9765614175

Details

• 0 of 7 (0.0%) changed or added relevant lines in 1 file are covered.
• No unchanged relevant lines lost coverage.
• Overall coverage remained the same at 9.521%

---

Changes Missing Coverage	Covered Lines	Changed/Added Lines	%
internal/store/postgres/session_repository.go	0	7	0.0%
<!--	Total:	0	7	0.0%	-->

Totals
Change from base Build 9723206722:	0.0%
Covered Lines:	10245
Relevant Lines:	107605

---

💛 - Coveralls