3 replies

how to delete the references in other tables to a deleted item?

If i delete a quoteItemquoteItem, how can i delete also the other tables that are referencing this item ?

export const delete_ = mutation({
  args: {
    id: v.id('quoteItems'),
  },
  handler: async ({ db }, { id }) => {
    // Validate arguments here. Throw error if invalid. Example `typeof city !== "string" ||`
    if (typeof id !== 'string') {
      throw new Error('Invalid argument')
    }
    // TODO how to clean other tables that reference this item?
    return await db.delete(id)
  },
})

export const delete_ = mutation({
  args: {
    id: v.id('quoteItems'),
  },
  handler: async ({ db }, { id }) => {
    // Validate arguments here. Throw error if invalid. Example `typeof city !== "string" ||`
    if (typeof id !== 'string') {
      throw new Error('Invalid argument')
    }
    // TODO how to clean other tables that reference this item?
    return await db.delete(id)
  },
})

Convex Community•3y ago•

3 replies

Gorka Cesium

how to delete the references in other tables to a deleted item?

If i delete a quoteItemquoteItem, how can i delete also the other tables that are referencing this item ?

export const delete_ = mutation({
  args: {
    id: v.id('quoteItems'),
  },
  handler: async ({ db }, { id }) => {
    // Validate arguments here. Throw error if invalid. Example `typeof city !== "string" ||`
    if (typeof id !== 'string') {
      throw new Error('Invalid argument')
    }
    // TODO how to clean other tables that reference this item?
    return await db.delete(id)
  },
})

export const delete_ = mutation({
  args: {
    id: v.id('quoteItems'),
  },
  handler: async ({ db }, { id }) => {
    // Validate arguments here. Throw error if invalid. Example `typeof city !== "string" ||`
    if (typeof id !== 'string') {
      throw new Error('Invalid argument')
    }
    // TODO how to clean other tables that reference this item?
    return await db.delete(id)
  },
})

Continue the conversation

Join the Discord to ask follow-up questions and connect with the community

Convex Community

Join the Convex Discord! Explore Convex, the backend platform that keeps your app in sync.

15,960 Members

Join

how to delete the references in other tables to a deleted item?

how to delete the references in other tables to a deleted item?

Continue the conversation

Convex Community

Continue the conversation

Convex Community

Similar Threads