17     protected $db;  variable in helper_plugin_acknowledge
29         if ($this->db === null) {
31                 $this->db = new SQLiteDB('acknowledgement', __DIR__ . '/db');
34 …          $this->db->getPdo()->sqliteCreateFunction('AUTH_ISMEMBER', [$this, 'auth_isMember'], -1);
35 … $this->db->getPdo()->sqliteCreateFunction('MATCHES_PAGE_PATTERN', [$this, 'matchPagePattern'], 2);
52         return $this->db;
79         $this->db->getPdo()->beginTransaction();
85                     $this->db->exec($sql, [$page, $lastmod]);
87                     $this->db->getPdo()->rollBack();
92         $this->db->getPdo()->commit();
171         $this->db->exec($sql, $page);
193         $this->db->exec($sql, [$page, $lastmod]);
207         $this->db->exec($sql, $page);
222         $this->db->exec($sql, [$page, $assignees]);
248         $this->db->exec($sql, [$page, $assignees]);
262         $record = $this->db->queryRecord($sql, $page);
292         return $this->db->queryAll($sql, $user, $user, implode('///', $groups));
311         $assignments = $this->db->queryValue($sql, $page);
340         return $this->db->queryKeyValueList($sql);
352         $this->db->getPdo()->beginTransaction();
357             $this->db->exec($sql);
361             $this->db->exec($sql);
371                 $this->db->exec($sql, [$pattern, $assignees]);
390                 $this->db->exec($sql, [$page, $assignees, $assignees]);
393             $this->db->getPdo()->rollBack();
396         $this->db->getPdo()->commit();
408         $pages = $this->db->queryAll($sql, $pattern);
432         $acktime = $this->db->queryValue($sql, $page, $user);
452         return $this->db->queryValue($sql, [$page, $user]);
466         $this->db->exec($sql, $page, $user);
497         return $this->db->queryAll($sql, [$user, $user, implode('///', $groups)]);
532         $ulist = implode(',', array_map([$this->db->getPdo(), 'quote'], $users));
542         $acknowledgements = $this->db->queryAll($sql, $params);
600         return $this->db->queryAll($sql, $limit);