Zack Posts - Answer Overflow

Zack

Explore posts from servers

•Created by Zack on 1/12/2024 in #help

Is it possible to spread a relation object when using `with`?

I am using multiple table inheritance where I have a user table and two other separate tables for different user roles. When I do a query to find a user from the tables for the roles I would like to return the user tables columns spread on the object if that makes sense so if I do:

const userType1 = await db.query.userType1.findFirst({
      where: eq(userType1.id, id),
      with: {
        user: true,
      },
    });

const userType1 = await db.query.userType1.findFirst({
      where: eq(userType1.id, id),
      with: {
        user: true,
      },
    });

Right now userType1 has the type:

{
id: string,
...other userType1 info
user: {...}
}

{
id: string,
...other userType1 info
user: {...}
}

But I would like to have the user object spread inside the object instead. I can do this manually, but wanted to know if this was built in already or configurable.

1 replies

TTCTheo's Typesafe Cult

•Created by Zack on 12/29/2023 in #questions

Best alternative to next-auth for use with credentials

Since next-auth doesn't fully support credential based authentication and mainly is built for oauth I was curious what the "next best" auth framework was if I need to authenticate users with email/password as well as oauth?

9 replies

DTDrizzle Team

•Created by Zack on 12/28/2023 in #help

Recommended place to add prepared statements

Where is the recommended place to define prepared statements? Does it make the most sense to define them in the schema file or at the service layer? Just generally I guess where is the best place to declare prepared statements? I was also just curious on the general threshold of query complexity to make creating a prepared statement worthwhile. How complex does a repeated query have to be in order to see a performance benefit from a prepared statement?

2 replies

Gaming

Programming