nextcloud /
circles
| @@ 179-187 (lines=9) @@ | ||
| 176 | * |
|
| 177 | * @return IQueryBuilder |
|
| 178 | */ |
|
| 179 | protected function getGroupsDeleteSql($groupId) { |
|
| 180 | $qb = $this->dbConnection->getQueryBuilder(); |
|
| 181 | $expr = $qb->expr(); |
|
| 182 | ||
| 183 | $qb->delete(CoreRequestBuilder::TABLE_GROUPS) |
|
| 184 | ->where($expr->eq('group_id', $qb->createNamedParameter($groupId))); |
|
| 185 | ||
| 186 | return $qb; |
|
| 187 | } |
|
| 188 | ||
| 189 | /** |
|
| 190 | * Base of the Sql Delete request for Members |
|
| @@ 545-553 (lines=9) @@ | ||
| 542 | * |
|
| 543 | * @return \OCP\DB\QueryBuilder\IQueryBuilder |
|
| 544 | */ |
|
| 545 | protected function getBaseDeleteSql() { |
|
| 546 | $qb = $this->dbConnection->getQueryBuilder(); |
|
| 547 | $expr = $qb->expr(); |
|
| 548 | ||
| 549 | $qb->delete('share') |
|
| 550 | ->where($expr->eq('share_type', $qb->createNamedParameter(Share::SHARE_TYPE_CIRCLE))); |
|
| 551 | ||
| 552 | return $qb; |
|
| 553 | } |
|
| 554 | ||
| 555 | ||
| 556 | /** |
|
| @@ 561-569 (lines=9) @@ | ||
| 558 | * |
|
| 559 | * @return \OCP\DB\QueryBuilder\IQueryBuilder |
|
| 560 | */ |
|
| 561 | protected function getBaseUpdateSql() { |
|
| 562 | $qb = $this->dbConnection->getQueryBuilder(); |
|
| 563 | $expr = $qb->expr(); |
|
| 564 | ||
| 565 | $qb->update('share') |
|
| 566 | ->where($expr->eq('share_type', $qb->createNamedParameter(Share::SHARE_TYPE_CIRCLE))); |
|
| 567 | ||
| 568 | return $qb; |
|
| 569 | } |
|
| 570 | } |
|
| 571 | ||
| @@ 364-373 (lines=10) @@ | ||
| 361 | * |
|
| 362 | * @return IQueryBuilder |
|
| 363 | */ |
|
| 364 | protected function getCirclesUpdateSql($uniqueId) { |
|
| 365 | $qb = $this->dbConnection->getQueryBuilder(); |
|
| 366 | $qb->update(self::TABLE_CIRCLES) |
|
| 367 | ->where( |
|
| 368 | $qb->expr() |
|
| 369 | ->eq('unique_id', $qb->createNamedParameter($uniqueId)) |
|
| 370 | ); |
|
| 371 | ||
| 372 | return $qb; |
|
| 373 | } |
|
| 374 | ||
| 375 | ||
| 376 | /** |
|
| @@ 383-395 (lines=13) @@ | ||
| 380 | * |
|
| 381 | * @return IQueryBuilder |
|
| 382 | */ |
|
| 383 | protected function getCirclesDeleteSql($circleUniqueId) { |
|
| 384 | $qb = $this->dbConnection->getQueryBuilder(); |
|
| 385 | $qb->delete(self::TABLE_CIRCLES) |
|
| 386 | ->where( |
|
| 387 | $qb->expr() |
|
| 388 | ->eq( |
|
| 389 | $qb->createFunction( |
|
| 390 | 'SUBSTR(`unique_id`, 1, ' . Circle::SHORT_UNIQUE_ID_LENGTH . ')' |
|
| 391 | ), |
|
| 392 | $qb->createNamedParameter($circleUniqueId) |
|
| 393 | ) |
|
| 394 | ); |
|
| 395 | ||
| 396 | return $qb; |
|
| 397 | } |
|
| 398 | ||
| @@ 105-114 (lines=10) @@ | ||
| 102 | * |
|
| 103 | * @return IQueryBuilder |
|
| 104 | */ |
|
| 105 | protected function getSharesUpdateSql($uniqueId) { |
|
| 106 | $qb = $this->dbConnection->getQueryBuilder(); |
|
| 107 | $qb->update(self::TABLE_SHARES) |
|
| 108 | ->where( |
|
| 109 | $qb->expr() |
|
| 110 | ->eq('unique_id', $qb->createNamedParameter((string)$uniqueId)) |
|
| 111 | ); |
|
| 112 | ||
| 113 | return $qb; |
|
| 114 | } |
|
| 115 | ||
| 116 | ||
| 117 | /** |
|
