@@ 133-137 (lines=5) @@ | ||
130 | ||
131 | $stmt = \OCP\DB::prepare($query); |
|
132 | $result = $stmt->execute($params); |
|
133 | if (\OCP\DB::isError($result)) { |
|
134 | \OCP\Util::writeLog('contacts', __METHOD__ . 'DB error: ' . \OC_DB::getErrorMessage($result), |
|
135 | \OCP\Util::ERROR); |
|
136 | return false; |
|
137 | } |
|
138 | while ($row = $result->fetchRow()) { |
|
139 | $id = $row['contactid']; |
|
140 | $addressbookKey = $row['addressbookid']; |
|
@@ 219-223 (lines=5) @@ | ||
216 | $query = 'SELECT COUNT(*) as `count` FROM `*PREFIX*contacts_cards` WHERE `id` = ? AND `addressbookid` = ?'; |
|
217 | $stmt = \OCP\DB::prepare($query); |
|
218 | $result = $stmt->execute(array($id, $this->id)); |
|
219 | if (\OCP\DB::isError($result)) { |
|
220 | \OCP\Util::writeLog('contacts', __METHOD__ . 'DB error: ' . \OC_DB::getErrorMessage($result), |
|
221 | \OCP\Util::ERROR); |
|
222 | return false; |
|
223 | } |
|
224 | if((int)$result['count'] === 0) { |
|
225 | \OCP\Util::writeLog('contacts', __METHOD__ |
|
226 | . 'Contact with id ' . $id . 'doesn\'t belong to addressbook with id ' . $this->id, |
@@ 101-105 (lines=5) @@ | ||
98 | $result = $this->getPreparedQuery('getaddressbooksforuser') |
|
99 | ->execute(array($this->userid)); |
|
100 | ||
101 | if (\OCP\DB::isError($result)) { |
|
102 | \OCP\Util::writeLog('contacts', __METHOD__. 'DB error: ' |
|
103 | . \OC_DB::getErrorMessage($result), \OCP\Util::ERROR); |
|
104 | return $this->addressBooks; |
|
105 | } |
|
106 | ||
107 | } catch(\Exception $e) { |
|
108 | \OCP\Util::writeLog('contacts', __METHOD__.' exception: ' |
|
@@ 153-157 (lines=5) @@ | ||
150 | try { |
|
151 | $result = $this->getPreparedQuery('getaddressbook')->execute(array($addressBookId, $owner)); |
|
152 | ||
153 | if (\OCP\DB::isError($result)) { |
|
154 | \OCP\Util::writeLog('contacts', __METHOD__. 'DB error: ' |
|
155 | . \OC_DB::getErrorMessage($result), \OCP\Util::ERROR); |
|
156 | return null; |
|
157 | } |
|
158 | ||
159 | $row = $result->fetchRow(); |
|
160 | ||
@@ 244-249 (lines=6) @@ | ||
241 | $stmt = \OCP\DB::prepare($query); |
|
242 | $result = $stmt->execute($updates); |
|
243 | ||
244 | if (\OCP\DB::isError($result)) { |
|
245 | \OCP\Util::writeLog('contacts', |
|
246 | __METHOD__. 'DB error: ' |
|
247 | . \OC_DB::getErrorMessage($result), \OCP\Util::ERROR); |
|
248 | return false; |
|
249 | } |
|
250 | ||
251 | } catch(\Exception $e) { |
|
252 | \OCP\Util::writeLog('contacts', |
|
@@ 289-292 (lines=4) @@ | ||
286 | try { |
|
287 | $result = $this->getPreparedQuery('createaddressbook')->execute($updates); |
|
288 | ||
289 | if (\OCP\DB::isError($result)) { |
|
290 | \OCP\Util::writeLog('contacts', __METHOD__. 'DB error: ' . \OC_DB::getErrorMessage($result), \OCP\Util::ERROR); |
|
291 | return false; |
|
292 | } |
|
293 | ||
294 | } catch(\Exception $e) { |
|
295 | \OCP\Util::writeLog('contacts', __METHOD__ . ', exception: ' . $e->getMessage(), \OCP\Util::ERROR); |
|
@@ 327-331 (lines=5) @@ | ||
324 | $result = $this->getPreparedQuery('getcontactids') |
|
325 | ->execute(array($addressBookId)); |
|
326 | ||
327 | if (\OCP\DB::isError($result)) { |
|
328 | \OCP\Util::writeLog('contacts', __METHOD__. 'DB error: ' |
|
329 | . \OC_DB::getErrorMessage($result), \OCP\Util::ERROR); |
|
330 | return false; |
|
331 | } |
|
332 | ||
333 | } catch(\Exception $e) { |
|
334 | \OCP\Util::writeLog('contacts', __METHOD__. |
|
@@ 426-429 (lines=4) @@ | ||
423 | ||
424 | $result = $this->getPreparedQuery('numcontacts')->execute(array($addressBookId)); |
|
425 | ||
426 | if (\OCP\DB::isError($result)) { |
|
427 | \OCP\Util::writeLog('contacts', __METHOD__. 'DB error: ' . \OC_DB::getErrorMessage($result), \OCP\Util::ERROR); |
|
428 | return null; |
|
429 | } |
|
430 | ||
431 | return (int)$result->fetchOne(); |
|
432 | } |
|
@@ 447-450 (lines=4) @@ | ||
444 | ||
445 | $result = $this->getPreparedQuery($queryIdentifier, $options)->execute(array($addressBookId)); |
|
446 | ||
447 | if (\OCP\DB::isError($result)) { |
|
448 | \OCP\Util::writeLog('contacts', __METHOD__. 'DB error: ' . \OC_DB::getErrorMessage($result), \OCP\Util::ERROR); |
|
449 | return $cards; |
|
450 | } |
|
451 | ||
452 | } catch(\Exception $e) { |
|
453 | \OCP\Util::writeLog('contacts', __METHOD__.', exception: '.$e->getMessage(), \OCP\Util::ERROR); |
|
@@ 527-530 (lines=4) @@ | ||
524 | //\OCP\Util::writeLog('contacts', __METHOD__.', identifier: '. $queryIdentifier . ', queries: ' . implode(',', $queries), \OCP\Util::DEBUG); |
|
525 | $result = $this->getPreparedQuery($queryIdentifier)->execute($queries); |
|
526 | ||
527 | if (\OCP\DB::isError($result)) { |
|
528 | \OCP\Util::writeLog('contacts', __METHOD__. 'DB error: ' . \OC_DB::getErrorMessage($result), \OCP\Util::ERROR); |
|
529 | return null; |
|
530 | } |
|
531 | ||
532 | } catch (\Exception $e) { |
|
533 | \OCP\Util::writeLog('contacts', __METHOD__.', exception: '.$e->getMessage(), \OCP\Util::ERROR); |
|
@@ 625-628 (lines=4) @@ | ||
622 | ) |
|
623 | ); |
|
624 | ||
625 | if (\OCP\DB::isError($result)) { |
|
626 | \OCP\Util::writeLog('contacts', __METHOD__. 'DB error: ' . \OC_DB::getErrorMessage($result), \OCP\Util::ERROR); |
|
627 | return false; |
|
628 | } |
|
629 | ||
630 | } catch(\Exception $e) { |
|
631 | \OCP\Util::writeLog('contacts', __METHOD__.', exception: '.$e->getMessage(), \OCP\Util::ERROR); |
|
@@ 711-714 (lines=4) @@ | ||
708 | ||
709 | $result = $this->getPreparedQuery('updatecontact')->execute($updates); |
|
710 | ||
711 | if (\OCP\DB::isError($result)) { |
|
712 | \OCP\Util::writeLog('contacts', __METHOD__. 'DB error: ' . \OC_DB::getErrorMessage($result), \OCP\Util::ERROR); |
|
713 | return false; |
|
714 | } |
|
715 | ||
716 | } catch(\Exception $e) { |
|
717 | \OCP\Util::writeLog('contacts', __METHOD__.', exception: ' |
|
@@ 793-797 (lines=5) @@ | ||
790 | $result = $this->getPreparedQuery('deletecontact') |
|
791 | ->execute(array($id, $addressBookId)); |
|
792 | ||
793 | if (\OCP\DB::isError($result)) { |
|
794 | \OCP\Util::writeLog('contacts', __METHOD__. 'DB error: ' |
|
795 | . \OC_DB::getErrorMessage($result), \OCP\Util::ERROR); |
|
796 | return false; |
|
797 | } |
|
798 | ||
799 | } catch(\Exception $e) { |
|
800 | \OCP\Util::writeLog('contacts', __METHOD__. |
|
@@ 839-842 (lines=4) @@ | ||
836 | $stmt = $this->getPreparedQuery('contactidfromuri'); |
|
837 | $result = $stmt->execute(array($addressBookId,$uri)); |
|
838 | ||
839 | if (\OCP\DB::isError($result)) { |
|
840 | \OCP\Util::writeLog('contacts', __METHOD__. 'DB error: ' . \OC_DB::getErrorMessage($result), \OCP\Util::ERROR); |
|
841 | return null; |
|
842 | } |
|
843 | ||
844 | $one = $result->fetchOne(); |
|
845 | ||
@@ 868-874 (lines=7) @@ | ||
865 | $stmt = $this->getPreparedQuery('addressbookuris'); |
|
866 | $result = $stmt->execute(array($this->userid)); |
|
867 | ||
868 | if (\OCP\DB::isError($result)) { |
|
869 | \OCP\Util::writeLog('contacts', |
|
870 | __METHOD__. 'DB error: ' . \OC_DB::getErrorMessage($result), |
|
871 | \OCP\Util::ERROR |
|
872 | ); |
|
873 | return $name; |
|
874 | } |
|
875 | ||
876 | } catch(\Exception $e) { |
|
877 | \OCP\Util::writeLog('contacts', __METHOD__ . ' exception: ' . $e->getMessage(), \OCP\Util::ERROR); |
@@ 293-297 (lines=5) @@ | ||
290 | $preferred, |
|
291 | ) |
|
292 | ); |
|
293 | if (\OCP\DB::isError($result)) { |
|
294 | \OCP\Util::writeLog('contacts', __METHOD__. 'DB error: ' |
|
295 | . \OC_DB::getErrorMessage($result), \OCP\Util::ERROR); |
|
296 | return false; |
|
297 | } |
|
298 | } catch(\Exception $e) { |
|
299 | \OCP\Util::writeLog('contacts', __METHOD__.', exception: '.$e->getMessage(), \OCP\Util::ERROR); |
|
300 | return false; |