[Solved]-Django: lock particular rows in table

21👍

Locking queries were added in 1.4.

with transaction.commit_manually():
  ActivePlayListEntry.objects.select_for_update().filter(...)
  aple = ActivePlayListEntry.objects.get(...)
  aple.state = ...
  transaction.commit()

But you should consider refactoring so that a separate table with a ForeignKey is used to indicate the “active” song.

Leave a comment