Drizzle Team•12mo ago

How to define type of table with all relations included?

Say I have a a table users and a user has many posts, so I define a relationship as shown in the docs If I want to define a type that is "user with posts" that would be the result of:

await db.query.user.findFirst({ with: { posts: true } });

await db.query.user.findFirst({ with: { posts: true } });

the type of this would be something like

type UserWithPosts = (typeof users._.inferSelect) & {posts: Array<typeof posts._.inferSelect>}

type UserWithPosts = (typeof users._.inferSelect) & {posts: Array<typeof posts._.inferSelect>}

Is there a cleaner way to define that where all the relations are just included and automatically inferred?

4 Replies

jakeleventhalOP•12mo ago

or if you had a one-to-one relationship (for instance the user has one "post"), then the type would be even more complicated:

type UserWithPosts = (typeof users._.inferSelect) & {post: typeof posts._.inferSelect | null}

type UserWithPosts = (typeof users._.inferSelect) & {post: typeof posts._.inferSelect | null}

Angelelz•12mo ago

Yes, this is a way you can currently define the types

Angelelz•12mo ago

I have an open PR for a couple helpers https://github.com/drizzle-team/drizzle-orm/pull/1670. Waiting for the approval of the team

GitHub

Build software better, together

GitHub is where people build software. More than 100 million people use GitHub to discover, fork, and contribute to over 420 million projects.

jakeleventhalOP•12mo ago

nice work, subscribed to the PR

Gaming

Programming

How to define type of table with all relations included?