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} |
|
| @@ 1485-1500 (lines=16) @@ | ||
| 1482 | /** |
|
| 1483 | * {@inheritDoc} |
|
| 1484 | */ |
|
| 1485 | public function appendLockHint($fromClause, $lockMode) |
|
| 1486 | { |
|
| 1487 | switch (true) { |
|
| 1488 | case LockMode::NONE === $lockMode: |
|
| 1489 | return $fromClause . ' WITH (NOLOCK)'; |
|
| 1490 | ||
| 1491 | case LockMode::PESSIMISTIC_READ === $lockMode: |
|
| 1492 | return $fromClause . ' WITH (HOLDLOCK, ROWLOCK)'; |
|
| 1493 | ||
| 1494 | case LockMode::PESSIMISTIC_WRITE === $lockMode: |
|
| 1495 | return $fromClause . ' WITH (UPDLOCK, ROWLOCK)'; |
|
| 1496 | ||
| 1497 | default: |
|
| 1498 | return $fromClause; |
|
| 1499 | } |
|
| 1500 | } |
|
| 1501 | ||
| 1502 | /** |
|
| 1503 | * {@inheritDoc} |
|
