Hegar
Hegar
PostsComments
DTDrizzle Team
Created by Hegar on 9/5/2023 in #help
How does Drizzle Kit keep track of the migrations on PostgreSQL?
My bad, I didn't run the migration correctly
5 replies
DTDrizzle Team
Created by Hegar on 9/5/2023 in #help
How does Drizzle Kit keep track of the migrations on PostgreSQL?
Sorry, I don't find this table, how should look for this table?
5 replies
DTDrizzle Team
Created by Hegar on 9/5/2023 in #help
How does Drizzle Kit keep track of the migrations on PostgreSQL?
Great! Thanks
5 replies
DTDrizzle Team
Created by Jonte on 7/2/2023 in #help
Expand query from ID using .select()
you have two options: 1. SQL like syntax 
let gotComments = await db
    .select({
        userName: user.firstName
     })
    .from(comments)
    .where(eq(comments.post, post))
    .innerJoin(user, eq(user.id, comments.authorId))
    .orderBy(sql`${comments.id} desc`)
    .limit(100)
let gotComments = await db
    .select({
        userName: user.firstName
     })
    .from(comments)
    .where(eq(comments.post, post))
    .innerJoin(user, eq(user.id, comments.authorId))
    .orderBy(sql`${comments.id} desc`)
    .limit(100)
2. Query builder API 
const result = await db.query.comments.findMany({
    with: {
        author: true            
    },
});
const result = await db.query.comments.findMany({
    with: {
        author: true            
    },
});
3 replies
DTDrizzle Team
Created by Hegar on 7/2/2023 in #help
Typescript path alias not working properly
This also applies for the drizzle.config.ts
13 replies