Use supabase types | TypeScript Community | Page 1

wary hawk Jan 27, 2024, 2:43 PM

#

I have these types genereated by supabase and am trying to figure out how to use them https://gist.github.com/AndruMace/eb0f4f97af8706741cb2edf481e648bc .

I can import Database and Tables, but can't figure out how to type, e.g., something as a post object from my posts tables, or anything else.

Gist

supabase.types.ts

GitHub Gist: instantly share code, notes, and snippets.

glass canopy Jan 27, 2024, 2:44 PM

#

usig indexed access

#

!hb indexed access

upper craneBOT Jan 27, 2024, 2:44 PM

#

Handbook

Indexed Access Types

glass canopy Jan 27, 2024, 2:45 PM

#

tlrd. you can "take" a (sub-) attribute of a type

#

and use it to create a new type with that

#

type Comment = Database["public"]["Tables"]["comments"]["Row"];

#

you might want to automate the "extraction" of that information with an utility type

#

type DBRow<T extends keyof Database["public"]["Tables"]> = Database["public"]["Tables"][T]["Row"];

type Comment = DBRow<"comments">;
type Country = DBRow<"countries">;
type Image = DBRow<"images">;
// etc.

glass canopy Jan 27, 2024, 2:49 PM

#

glass canopy ```ts type DBRow<T extends keyof Database["public"]["Tables"]> = Database["publi...

wait, actually, that's what the Tables<> type down below is for I think

#

type Comment = Tables<"comments">;
type Country = Tables<"countries">;
type Image = Tables<"images">;

I think
tho Tables can take a 2nd type parameter, but not too sure what it's supposed to be exactly

#

@wary hawk

#

have you tried searching for documentation about that generator, and how to use it?

wary hawk Jan 27, 2024, 2:52 PM

#

glass canopy ```ts type Comment = Tables<"comments">; type Country = Tables<"countries">; typ...

Ah yep that works! I was trying to access them like ‘Tables.Images’ etc and when that didn’t work wasn’t sure what to do

#Use supabase types