How to define different setter for update and insert?

[antage]

I want to increment table field (by UPDATE) or set to 1 (by INSERT if record doesn't exist).
How can I do that with upsert?

[seamusabshere]

upsert can't do that, yet... it's on the wishlist.

I imagine it might work something like:

selector = { id:15 }
setter = { count: Upsert.sql('count + 1') } # here's the important part
upsert.row(selector, setter)

would that work for you?

[antage]

I see it like this:

selector = { id: 15 }
update_setter = { count: Upsert.sql('count + 1') }
insert_setter = { count: 1 }
upsert.row_with_two_setter(update_setter, insert_setter, selector)

[jan]

Can anyone sketch a solution for this?

[ioquatix]

Is this possible yet?

[pnomolos]

@ioquatix It's not possible yet, this is still definitely on the wishlist.