Upsert feature in convex?
HI - is there any plans to introduce a .upsert function in convex?
Currently this is how I'm approaching it:
export const upsertTask = mutation({
args: {
text: v.string(),
},
handler: async (ctx, args) => {
const existingItem = await ctx.db
.query("tasks")
.filter((q) => q.eq(q.field("task_name"), args.text))
.first();
if (existingItem !== null) {
await ctx.db.patch(existingItem._id, {
task_name: args.text,
});
} else {
await ctx.db.insert("tasks", {
task_name: args.text,
isCompleted: false,
});
}
},
});
Which achieves the purporse, but was thinking if there was a better/shorter approach to this?
Thank you
Currently this is how I'm approaching it:
export const upsertTask = mutation({
args: {
text: v.string(),
},
handler: async (ctx, args) => {
const existingItem = await ctx.db
.query("tasks")
.filter((q) => q.eq(q.field("task_name"), args.text))
.first();
if (existingItem !== null) {
await ctx.db.patch(existingItem._id, {
task_name: args.text,
});
} else {
await ctx.db.insert("tasks", {
task_name: args.text,
isCompleted: false,
});
}
},
});
Which achieves the purporse, but was thinking if there was a better/shorter approach to this?
Thank you
Join the Convex Discord! Explore Convex, the backend platform that keeps your app in sync.
15,590Members
Resources
Recent Announcements
Similar Threads
Was this page helpful?
