Add support for `SELECT ... FOR UPDATE WAIT n`

[marcosmoyano]

Code of Conduct

• I agree to follow Django's Code of Conduct

Feature Description

MariaDB supports SELECT ... FOR UPDATE WAIT n since version 10.3.0. I'd like to be able to use that feature through the Django ORM.
Ref: https://mariadb.com/kb/en/wait-and-nowait/

Problem

Right now I don't have a clean mechanism to set a timeout on a locking statement. I'd like to be able to set a guardrail in a form of a timeout for long running transactions.

Request or proposal

proposal

Additional Details

No response

Implementation Suggestions

I'd extend the select_for_update signature to allow an extra argument, something like select_for_update(wait=n)

[github-actions]

Thank you marcosmoyano for sharing your idea! We have a lot of them so please be patient. You can see the current queue here.

Community instructions

For commenters, please use the emoji reactions on the issue to express support, and/or concern easily. Please use the comments to ask questions or contribute knowledge about the idea. It is unhelpful to post comments of "I'd love this" or "What's the state of this?"

Reaction Guide

• 👍 This is something I would use
• 👎 This is something that would cause problems for me or Django
• 😕 I’m indifferent to this
• 🎉 This is an easy win

[tim-schilling]

Hi @marcosmoyano, I think this is already supported. Please see select_for_update.

However, MariaDB only supports the nowait argument, MariaDB 10.6+ also supports the skip_locked argument, and MySQL supports the nowait, skip_locked, and of arguments. The no_key argument is only supported on PostgreSQL.

Edit:
Ah, you want to control the wait timeout. Got it! Sorry