Lines Matching refs:db
9 protected $db;
17 $this->db = new SQLiteDB('sqlite', DOKU_PLUGIN . 'sqlite/db/');
30 'sqlitedb' => $this->db,
37 $sql = 'INSERT INTO queries (db, name, sql) VALUES (?, ?, ?)';
38 $this->db->exec($sql, [$this->upstream, $name, $query]);
51 $sql = 'SELECT sql FROM queries WHERE db = ? AND name = ?';
52 return $this->db->queryValue($sql, [$this->upstream, $name]);
63 'sqlitedb' => $this->db,
69 $sql = 'DELETE FROM queries WHERE db = ? AND name = ?';
70 $this->db->exec($sql, [$this->upstream, $name]);
82 $sql = 'SELECT name, sql FROM queries WHERE db = ?';
83 return $this->db->queryAll($sql, [$this->upstream]);