Add working tests

[NikhilCodes]

Currently, test cases are just plain dumb, they don't check if something fails or doesn't work as needed

[benjamin-arfa]

should we create a supabase testing project or what do you have in mind ? 👍

[NikhilCodes]

Not sure, maybe something like adding credentials for test project to github secrets and ci/cd it maybe.

[jerichosiahaya]

I think we need to revamp the whole code base first before actually make the unit test. I would be so hard to make the unit test without the decoupling some function inside the wrapper. If we already decoupled the functions, it would be so much easier to mock the interfaces. CMIIW