doctrine /
dbal
| @@ 64-79 (lines=16) @@ | ||
| 61 | /** |
|
| 62 | * {@inheritdoc} |
|
| 63 | */ |
|
| 64 | public function appendLockHint($fromClause, $lockMode) |
|
| 65 | { |
|
| 66 | switch (true) { |
|
| 67 | case $lockMode === LockMode::NONE: |
|
| 68 | return $fromClause . ' WITH (NOLOCK)'; |
|
| 69 | ||
| 70 | case $lockMode === LockMode::PESSIMISTIC_READ: |
|
| 71 | return $fromClause . ' WITH (UPDLOCK)'; |
|
| 72 | ||
| 73 | case $lockMode === LockMode::PESSIMISTIC_WRITE: |
|
| 74 | return $fromClause . ' WITH (XLOCK)'; |
|
| 75 | ||
| 76 | default: |
|
| 77 | return $fromClause; |
|
| 78 | } |
|
| 79 | } |
|
| 80 | ||
| 81 | /** |
|
| 82 | * {@inheritdoc} |
|
| @@ 1486-1501 (lines=16) @@ | ||
| 1483 | /** |
|
| 1484 | * {@inheritDoc} |
|
| 1485 | */ |
|
| 1486 | public function appendLockHint($fromClause, $lockMode) |
|
| 1487 | { |
|
| 1488 | switch (true) { |
|
| 1489 | case LockMode::NONE === $lockMode: |
|
| 1490 | return $fromClause . ' WITH (NOLOCK)'; |
|
| 1491 | ||
| 1492 | case LockMode::PESSIMISTIC_READ === $lockMode: |
|
| 1493 | return $fromClause . ' WITH (HOLDLOCK, ROWLOCK)'; |
|
| 1494 | ||
| 1495 | case LockMode::PESSIMISTIC_WRITE === $lockMode: |
|
| 1496 | return $fromClause . ' WITH (UPDLOCK, ROWLOCK)'; |
|
| 1497 | ||
| 1498 | default: |
|
| 1499 | return $fromClause; |
|
| 1500 | } |
|
| 1501 | } |
|
| 1502 | ||
| 1503 | /** |
|
| 1504 | * {@inheritDoc} |
|
