ayyjohn
ayyjohn
PostsComments
TTCTheo's Typesafe Cult
Created by DangerZone on 6/27/2024 in #questions
Creaete T3 No Req or Res in TRPC context
oh, man. thanks for answering this. i was stuck here for waaay too long before noticing i should be using auth the docs I was looking at all said to use getAuth and I didn't notice they were for pageRouter
9 replies
DTDrizzle Team
Created by ayyjohn on 12/30/2024 in #help
how to nest select statement to achieve aliased result
figured that out by changing the column name to stageName and getting the same error as that ticket
23 replies
DTDrizzle Team
Created by ayyjohn on 12/30/2024 in #help
how to nest select statement to achieve aliased result
ok, yeah looks like it's the same issue as https://github.com/drizzle-team/drizzle-orm/issues/2050
23 replies
DTDrizzle Team
Created by ayyjohn on 12/30/2024 in #help
how to nest select statement to achieve aliased result
though notably that doesn't happen if i add name: performances.name to the performances object
23 replies
DTDrizzle Team
Created by ayyjohn on 12/30/2024 in #help
how to nest select statement to achieve aliased result
No description
23 replies
DTDrizzle Team
Created by ayyjohn on 12/30/2024 in #help
how to nest select statement to achieve aliased result
so changing it to 
.select({
  ...getTableColumns(reviews),
  performance: {
    time: performances.time,
    artistName: artists.name
    venueName: venues.name
  },
  reviewer: {
    firstName: users.firstName,
    lastName: users.lastName,
  },
  commentsCount: ctx.db
    .$count(reviewComments, eq(reviewComments.reviewId, reviews.id))
    .as('commentsCount'),
  })
})
.select({
  ...getTableColumns(reviews),
  performance: {
    time: performances.time,
    artistName: artists.name
    venueName: venues.name
  },
  reviewer: {
    firstName: users.firstName,
    lastName: users.lastName,
  },
  commentsCount: ctx.db
    .$count(reviewComments, eq(reviewComments.reviewId, reviews.id))
    .as('commentsCount'),
  })
})
works i still feel like I should be able to do the original syntax, but at least I know why it's complaining now so I can see if I can either fix that by fixing my relations or work around it
23 replies
DTDrizzle Team
Created by ayyjohn on 12/30/2024 in #help
how to nest select statement to achieve aliased result
ahhhhh, yeah I think i figured it out: it doesn't like me naming that field artist because my relations say that performance.artist has a specific type
23 replies
DTDrizzle Team
Created by ayyjohn on 12/30/2024 in #help
how to nest select statement to achieve aliased result
i still feel like I have a syntax error... hold on
23 replies
DTDrizzle Team
Created by ayyjohn on 12/30/2024 in #help
how to nest select statement to achieve aliased result
looks like i'm on the current highest version of drizzle-orm sob
23 replies
DTDrizzle Team
Created by ayyjohn on 12/30/2024 in #help
how to nest select statement to achieve aliased result
cause unfortunately, even though it's working, my types think everything's broken 😦
23 replies
DTDrizzle Team
Created by ayyjohn on 12/30/2024 in #help
how to nest select statement to achieve aliased result
i'll try upgrading/reinstalling drizzle to see if I can get it to go away, and if not, submit an issue I think
23 replies
DTDrizzle Team
Created by ayyjohn on 12/30/2024 in #help
how to nest select statement to achieve aliased result
sigh okay lmao it works even with the errors
23 replies
DTDrizzle Team
Created by ayyjohn on 12/30/2024 in #help
how to nest select statement to achieve aliased result
getTableColumns is from drizzle-orm but I can try updating my drizzle version. I haven't tried actually running it 😅 let me do that
23 replies
DTDrizzle Team
Created by ayyjohn on 12/30/2024 in #help
how to nest select statement to achieve aliased result
No description
23 replies
DTDrizzle Team
Created by ayyjohn on 12/30/2024 in #help
how to nest select statement to achieve aliased result
taking a look 🙂 thank you!
23 replies