fasm Comments - Answer Overflow

type NewPosition = {
    id: number,
    position: number
}
export const updateLinkPositions = async (newPositions: NewPosition[]) => {
    const promises = newPositions.map(({ id, position }) => {
        return db.update(linksTable).set({ position }).where(eq(linksTable.id, id))
    })
    return Promise.all(promises)
}

type NewPosition = {
    id: number,
    position: number
}
export const updateLinkPositions = async (newPositions: NewPosition[]) => {
    const promises = newPositions.map(({ id, position }) => {
        return db.update(linksTable).set({ position }).where(eq(linksTable.id, id))
    })
    return Promise.all(promises)
}

28 replies

DTDrizzle Team

•Created by fasm on 5/31/2023 in #help

update multiple rows

thanks for getting back to me. I want do this by row ID as an identifier, not sure how to use the where statement like that.

28 replies

Gaming

Programming