Important! add a test db for supabase

[devsheva]

Actually the production DB is used in tests, but this is causing some problems on setup of fixtures and teardowns, so a way to use a test storage must be found.

A solution can be create a different schema (test) that replicates the production schema

Linked issue: #4

[devsheva]

Problem

Cannot find a way to generate type definitions also for test schema from Supabase dashboard.
Ref. Discussion: https://github.com/orgs/supabase/discussions/28448

[devsheva]

Temporary workaround

utils.ts

createClient<Database>(
  config.SUPABASE_URL,
  config.SUPABASE_KEY,
  {
    db: {
      schema: config.SUPABASE_SCHEMA as any, // FIXME: remove any when found a way to type custom schemas (#20)
    },
  },
)