New feature: skipLocked() on the Query Builder/Eloquent ORM ( SKIP LOCKED )

[kevineduardo]

As far as I know, I need to do lock('FOR UPDATE SKIP LOCKED') to work with skip locked, but would be much easier to just have a method like "skipLocked()".

[MohammadZarifiyan]

This code has been already used in Laravel queue system. I think Laravel team should add this as a feature to Query Builder.

public function lockForUpdateAndSkipLocked()
{
    $connection = $this->getConnection();
    $databaseEngine = $connection->getPdo()->getAttribute(PDO::ATTR_DRIVER_NAME);
    $databaseVersion = $connection->getConfig('version') ?? $connection->getPdo()->getAttribute(PDO::ATTR_SERVER_VERSION);

    if (Str::of($databaseVersion)->contains('MariaDB')) {
        $databaseEngine = 'mariadb';
        $databaseVersion = Str::before(Str::after($databaseVersion, '5.5.5-'), '-');
    } elseif (Str::of($databaseVersion)->contains(['vitess', 'PlanetScale'])) {
        $databaseEngine = 'vitess';
        $databaseVersion = Str::before($databaseVersion, '-');
    }

    if (($databaseEngine === 'mysql' && version_compare($databaseVersion, '8.0.1', '>=')) ||
        ($databaseEngine === 'mariadb' && version_compare($databaseVersion, '10.6.0', '>=')) ||
        ($databaseEngine === 'pgsql' && version_compare($databaseVersion, '9.5', '>='))) {
        return $this->lock('FOR UPDATE SKIP LOCKED');
    }

    if ($databaseEngine === 'sqlsrv') {
        return $this->lock('with(rowlock,updlock,readpast)');
    }

    throw new Exception('lockForUpdateAndSkipLocked is not supported with this database connection.');
}