Issues with Middleware and Authentication in NextAuth.js with Drizzle and SQLite
Hi,
I'm working with NextAuth (Auth.js) and Drizzle for the first time. I've successfully implemented OAuth for Google and GitHub, and I added the DrizzleAdapter and schema by following the NextAuth documentation.
Now, I want to set up middleware to differentiate between protected and public routes based on whether the user is logged in. However, I'm running into a couple of issues:...
Typescript doesnt autocomplete columns on table
I have a monorepo with a db package, structure is as follows:
.
├── drizzle.config.ts
├── migrations
├── package.json...
why does `alias()` create a new table?
this is my user_followers table and i have created table alias for joins. but for some reason it is creating 2 tables called followers and following which is a copy of users table.
In the 3rd screenshot, that's how i am planning to use the alias
My question is why is a new table getting created? is this correct usage of
alias()?...
select
Hi, I'm trying to query all the products and their respective categories. I have a big problem, I've managed to filter as I expect, however the result has a strange format for me. If a product has 3 categories the result creates 3 identical objects with only 1 key difference and I want it to only create one object and not repeat for each category, I know that groupBy helps me, but it makes me lose information. Is there an easy way to approach this case? I've thought about doing the queries separ...
Invalid type inference when using helpers
im using helpers for primaryKey and current timestamp
column.helper.ts
```ts
import { integer, text } from "drizzle-orm/sqlite-core";
...
Is there any option to use Drizzle InferSelectModel value for annotating swagger response
As you can see in the screenshots, I'm trying to reuse the drizzle infer models for the swagger response
Since the infer model is based of type I was not able to annotate it for swagger. Is there any alternative or easiest way to achieve this?...
