nextcloud /
circles
| @@ 127-141 (lines=15) @@ | ||
| 124 | * |
|
| 125 | * @return IQueryBuilder |
|
| 126 | */ |
|
| 127 | protected function getGroupsUpdateSql($circleId, $groupId) { |
|
| 128 | $qb = $this->dbConnection->getQueryBuilder(); |
|
| 129 | $expr = $qb->expr(); |
|
| 130 | ||
| 131 | /** @noinspection PhpMethodParametersCountMismatchInspection */ |
|
| 132 | $qb->update(self::TABLE_GROUPS) |
|
| 133 | ->where( |
|
| 134 | $expr->andX( |
|
| 135 | $expr->eq('circle_id', $qb->createNamedParameter($circleId)), |
|
| 136 | $expr->eq('group_id', $qb->createNamedParameter($groupId)) |
|
| 137 | ) |
|
| 138 | ); |
|
| 139 | ||
| 140 | return $qb; |
|
| 141 | } |
|
| 142 | ||
| 143 | /** |
|
| 144 | * Base of the Sql Updte request for Members |
|
| @@ 151-165 (lines=15) @@ | ||
| 148 | * |
|
| 149 | * @return IQueryBuilder |
|
| 150 | */ |
|
| 151 | protected function getMembersUpdateSql($circleId, $userId) { |
|
| 152 | $qb = $this->dbConnection->getQueryBuilder(); |
|
| 153 | $expr = $qb->expr(); |
|
| 154 | ||
| 155 | /** @noinspection PhpMethodParametersCountMismatchInspection */ |
|
| 156 | $qb->update(self::TABLE_MEMBERS) |
|
| 157 | ->where( |
|
| 158 | $expr->andX( |
|
| 159 | $expr->eq('circle_id', $qb->createNamedParameter($circleId)), |
|
| 160 | $expr->eq('user_id', $qb->createNamedParameter($userId)) |
|
| 161 | ) |
|
| 162 | ); |
|
| 163 | ||
| 164 | return $qb; |
|
| 165 | } |
|
| 166 | ||
| 167 | ||
| 168 | /** |
|
