Lines Matching refs:sql
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]);
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]);