9     protected $db;  variable in helper_plugin_approve_db
15         $this->db = new SQLiteDB('approve', DOKU_PLUGIN . 'approve/db/');
25         return $this->db->getDbFile();
34             $this->db->getPdo()->beginTransaction();
42             $this->db->getPdo()->commit();
49         return $this->db->queryAll($sql);
55         return $this->db->queryRecord($sql, $page_id);
61         return $this->db->queryValue($sql, $key);
66         $this->db->saveRecord('config', ['key' => $key, 'value' => $value]);
77         $this->db->query($sql, $hidden, $page_id);
82         $this->db->getPdo()->beginTransaction();
85         $this->db->query('DELETE FROM page');
92         $this->db->getPdo()->commit();
121         $assignments = $this->db->queryAll('SELECT id, namespace, approver FROM maintainer');
199         $pages = $this->db->queryAll($sql, $namespace.'*', $filter);
224         $revisions = $this->db->queryAll($sql, $page_id);
235         $page = $this->db->queryRecord($sql, $page_id, $rev);
266         $this->db->exec('UPDATE revision SET page=? WHERE page=?', $new_page_id, $old_page_id);
273             return $this->db->queryValue($sql, $page_id);
276             return $this->db->queryValue($sql, $page_id);
279         return $this->db->queryValue($sql, $page_id);
290         $this->db->exec($sql, date('c'), $INFO['client'], $page_id, $page_id);
300         $this->db->exec($sql, date('c'), $INFO['client'], $page_id);
306         $this->db->exec('DELETE FROM page WHERE page=?', $page_id);
307 …$this->db->exec('DELETE FROM revision WHERE page=? AND approved IS NULL AND ready_for_approval IS …
309         $this->db->exec('UPDATE revision SET current=0 WHERE page=? AND current=1', $page_id);
314         $this->db->getPdo()->beginTransaction();
316         $this->db->getPdo()->commit();
322 …$this->db->exec('DELETE FROM revision WHERE page=? AND approved IS NULL AND ready_for_approval IS …
333             $this->db->saveRecord('page', $data);  // insert or replace
339         $exists = $this->db->queryValue($sql, $page_id, $last_change_date);
342             $this->db->exec('UPDATE revision SET current=0 WHERE page=? AND current=1', $page_id);
344             $this->db->saveRecord('revision', [
355         $this->db->getPdo()->beginTransaction();
357         $this->db->getPdo()->commit();
362         $this->db->getPdo()->beginTransaction();
363         $this->db->exec('DELETE FROM maintainer WHERE id=?', $maintainer_id);
364         $this->db->getPdo()->commit();
369         $this->db->getPdo()->beginTransaction();
370         $this->db->saveRecord('maintainer', [
374         $this->db->getPdo()->commit();
380         return $this->db->queryAll($sql);