XF 2.1 Atomically update entity

K

Kirby

Well-known member
We've got an entity which does have a column that stores JSON - this column needs to be updated atomically (eg, Read-Modify-Write).

Does anyone have an idea on how to (elegantly) achieve this without
  • Resorting to raw queries (SELECT FOR UPDATE)
  • Using manual locking (yuck!)
  • Using an intermediate table for serialization
  • Relying on DB layer JSON support
?
 
You must log in or register to reply here.

Similar threads

PaulB
Fixed xf_session_activity: MySQL query error [1205]: Lock wait timeout exceeded; try restarting transaction
Replies
13
Views
2K
PaulB
PaulB
X
Fixed Entity::delete() does not check $db->delete() return results
Replies
1
Views
2K
XF Bug Bot
XF Bug Bot
Kevin
Not a bug Finder not returning results when Entity Relations specifies a Conditions using explicit column IDs to join on
Replies
2
Views
694
Kevin
Kevin
Top Bottom