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} |
|
| @@ 1493-1508 (lines=16) @@ | ||
| 1490 | /** |
|
| 1491 | * {@inheritDoc} |
|
| 1492 | */ |
|
| 1493 | public function appendLockHint($fromClause, $lockMode) |
|
| 1494 | { |
|
| 1495 | switch (true) { |
|
| 1496 | case LockMode::NONE === $lockMode: |
|
| 1497 | return $fromClause . ' WITH (NOLOCK)'; |
|
| 1498 | ||
| 1499 | case LockMode::PESSIMISTIC_READ === $lockMode: |
|
| 1500 | return $fromClause . ' WITH (HOLDLOCK, ROWLOCK)'; |
|
| 1501 | ||
| 1502 | case LockMode::PESSIMISTIC_WRITE === $lockMode: |
|
| 1503 | return $fromClause . ' WITH (UPDLOCK, ROWLOCK)'; |
|
| 1504 | ||
| 1505 | default: |
|
| 1506 | return $fromClause; |
|
| 1507 | } |
|
| 1508 | } |
|
| 1509 | ||
| 1510 | /** |
|
| 1511 | * {@inheritDoc} |
|
