Lines Matching refs:sql

62         $sql = 'SELECT * FROM schema_assignments_patterns ORDER BY pattern';
63         $this->patterns = $this->sqlite->queryAll($sql);
76         $sql = 'REPLACE INTO schema_assignments_patterns (pattern, tbl) VALUES (?,?)';
77         $ok = (bool)$this->sqlite->query($sql, [$pattern, $table]);
97         $sql = 'DELETE FROM schema_assignments_patterns WHERE pattern = ? AND tbl = ?';
98         $ok = (bool)$this->sqlite->query($sql, [$pattern, $table]);
104         $sql = 'SELECT pid FROM schema_assignments WHERE tbl = ?';
105         $pagerows = $this->sqlite->queryAll($sql, [$table]);
130         $sql = 'SELECT tbl FROM schema_assignments WHERE pid = ?';
131         $tablerows = $this->sqlite->queryAll($sql, [$pid]);
153         $sql = 'DELETE FROM schema_assignments_patterns';
154         $ok = (bool)$this->sqlite->query($sql);
157             $sql = 'DELETE FROM schema_assignments';
159             $sql = 'UPDATE schema_assignments SET assigned = 0';
161         $ok = $ok && (bool)$this->sqlite->query($sql);
178         $sql = 'REPLACE INTO schema_assignments (pid, tbl, assigned) VALUES (?, ?, 1)';
179         return (bool)$this->sqlite->query($sql, [$page, $table]);
191         $sql = 'REPLACE INTO schema_assignments (pid, tbl, assigned) VALUES (?, ?, 0)';
192         return (bool)$this->sqlite->query($sql, [$page, $table]);
227             $sql = 'SELECT tbl FROM schema_assignments WHERE pid = ? AND assigned = 1';
228             $list = $this->sqlite->queryAll($sql, [$page]);
246         $sql = 'SELECT pid, tbl, assigned FROM schema_assignments WHERE 1=1';
250             $sql .= ' AND tbl = ?';
254             $sql .= ' AND assigned = 1';
257         $sql .= ' ORDER BY pid, tbl';
259         $list = $this->sqlite->queryAll($sql, $opts);
323         $sql = "SELECT DISTINCT tbl FROM schemas WHERE ts <= ? ORDER BY ts DESC";
324         $tables = $this->sqlite->queryAll($sql, [$ts]);
330             $sql = "SELECT pid FROM data_$table WHERE pid = ? AND rev <= ? LIMIT 1";
331             $found = $this->sqlite->queryAll($sql, [$page, $ts]);
347         $sql = 'SELECT pid FROM schema_assignments WHERE tbl != ? OR assigned != 1';
348         $pagerows = $this->sqlite->queryAll($sql, [$table]);