1 reply

db.query not updating

Hey all! I recently refactored my schema to take advantage of the

findMany

findMany

and

findFirst

findFirst

functions. These are my

collectionsTable

collectionsTable

relations:

export const collectionsRelations = relations(collectionsTable, ({ one }) => ({
    author: one(usersTable, {
        fields: [collectionsTable.authorID],
        references: [usersTable.id],
    }),
}))

export const collectionsRelations = relations(collectionsTable, ({ one }) => ({
    author: one(usersTable, {
        fields: [collectionsTable.authorID],
        references: [usersTable.id],
    }),
}))

and a collection references those tables like so in the table setup:

    authorID: varchar({ length: 255 })
        .notNull()
        .references(() => usersTable.id),

    authorID: varchar({ length: 255 })
        .notNull()
        .references(() => usersTable.id),

and my query looks like this:

const collectionsQuery = await db.query.collectionsTable.findMany({
        where: userID
            ? or(
                    eq(collectionsTable.publicationStatus, PubStatus.PUBLIC), // Public collections
                    and(
                        eq(collectionsTable.authorID, userID), // User-created collections
                        eq(collectionsTable.publicationStatus, PubStatus.DRAFT)
                    ),
                    and(
                        eq(teamUsersTable.userID, userID), // Team-only collections
                        eq(collectionsTable.publicationStatus, PubStatus.TEAM_ONLY)
                    )
              )
            : eq(collectionsTable.publicationStatus, PubStatus.PUBLIC), // Only public collections
        
    })

const collectionsQuery = await db.query.collectionsTable.findMany({
        where: userID
            ? or(
                    eq(collectionsTable.publicationStatus, PubStatus.PUBLIC), // Public collections
                    and(
                        eq(collectionsTable.authorID, userID), // User-created collections
                        eq(collectionsTable.publicationStatus, PubStatus.DRAFT)
                    ),
                    and(
                        eq(teamUsersTable.userID, userID), // Team-only collections
                        eq(collectionsTable.publicationStatus, PubStatus.TEAM_ONLY)
                    )
              )
            : eq(collectionsTable.publicationStatus, PubStatus.PUBLIC), // Only public collections
        
    })

But I keep getting the error:

Unknown column 'collectionsTable.userID' in 'where clause'

Unknown column 'collectionsTable.userID' in 'where clause'

even though I'm only looking for

collectionsTable.authorID

collectionsTable.authorID

. Does drizzle have a cache I need to refresh? I was using

collectionsTable.userID

collectionsTable.userID

before but renamed the column. I've ran

drizzle-kit push

drizzle-kit push

and there is nothing to change. Thanks in advance for any help as this query was working as a select with join tables before. Wondering if I should just revert...

Drizzle Team•13mo ago•

1 reply

jbrundagejr

db.query not updating

Hey all! I recently refactored my schema to take advantage of the

findMany

findMany

and

findFirst

findFirst

functions. These are my

collectionsTable

collectionsTable

relations:

export const collectionsRelations = relations(collectionsTable, ({ one }) => ({
    author: one(usersTable, {
        fields: [collectionsTable.authorID],
        references: [usersTable.id],
    }),
}))

export const collectionsRelations = relations(collectionsTable, ({ one }) => ({
    author: one(usersTable, {
        fields: [collectionsTable.authorID],
        references: [usersTable.id],
    }),
}))

and a collection references those tables like so in the table setup:

    authorID: varchar({ length: 255 })
        .notNull()
        .references(() => usersTable.id),

    authorID: varchar({ length: 255 })
        .notNull()
        .references(() => usersTable.id),

and my query looks like this:

const collectionsQuery = await db.query.collectionsTable.findMany({
        where: userID
            ? or(
                    eq(collectionsTable.publicationStatus, PubStatus.PUBLIC), // Public collections
                    and(
                        eq(collectionsTable.authorID, userID), // User-created collections
                        eq(collectionsTable.publicationStatus, PubStatus.DRAFT)
                    ),
                    and(
                        eq(teamUsersTable.userID, userID), // Team-only collections
                        eq(collectionsTable.publicationStatus, PubStatus.TEAM_ONLY)
                    )
              )
            : eq(collectionsTable.publicationStatus, PubStatus.PUBLIC), // Only public collections
        
    })

const collectionsQuery = await db.query.collectionsTable.findMany({
        where: userID
            ? or(
                    eq(collectionsTable.publicationStatus, PubStatus.PUBLIC), // Public collections
                    and(
                        eq(collectionsTable.authorID, userID), // User-created collections
                        eq(collectionsTable.publicationStatus, PubStatus.DRAFT)
                    ),
                    and(
                        eq(teamUsersTable.userID, userID), // Team-only collections
                        eq(collectionsTable.publicationStatus, PubStatus.TEAM_ONLY)
                    )
              )
            : eq(collectionsTable.publicationStatus, PubStatus.PUBLIC), // Only public collections
        
    })

But I keep getting the error:

Unknown column 'collectionsTable.userID' in 'where clause'

Unknown column 'collectionsTable.userID' in 'where clause'

even though I'm only looking for

collectionsTable.authorID

collectionsTable.authorID

. Does drizzle have a cache I need to refresh? I was using

collectionsTable.userID

collectionsTable.userID

before but renamed the column. I've ran

drizzle-kit push

drizzle-kit push

and there is nothing to change. Thanks in advance for any help as this query was working as a select with join tables before. Wondering if I should just revert...

db.query not updating

db.query not updating

Similar Threads

Similar Threads

Similar Threads