Lines Matching refs:sql

60         $sql = 'SELECT * FROM structpublish_assignments_patterns ORDER BY pattern';
61         $this->patterns = $this->sqlite->queryAll($sql);
75         $sql = 'REPLACE INTO structpublish_assignments_patterns (pattern, user, status) VALUES (?,?,?)';
76         $ok = (bool) $this->sqlite->query($sql, [$pattern, $user, $status]);
113         $sql = 'DELETE FROM structpublish_assignments_patterns WHERE pattern = ? AND user = ? AND status = ?';
114         $ok = (bool) $this->sqlite->query($sql, [$pattern, $user, $status]);
120         $sql = 'SELECT pid FROM structpublish_assignments WHERE user = ? AND status = ?';
121         $pagerows = $this->sqlite->queryAll($sql, [$user, $status]);
163         $sql = 'DELETE FROM structpublish_assignments_patterns';
164         $ok = (bool) $this->sqlite->query($sql);
167             $sql = 'DELETE FROM structpublish_assignments';
169             $sql = 'UPDATE structpublish_assignments SET assigned = 0';
171         $ok = $ok && (bool) $this->sqlite->query($sql);
189         $sql = 'REPLACE INTO structpublish_assignments (pid, user, status, assigned) VALUES (?, ?, ?, 1)';
190         return (bool) $this->sqlite->query($sql, [$page, $user, $status]);
202         $sql = 'UPDATE structpublish_assignments SET assigned = 0 WHERE pid = ? AND user = ? AND status = ?';
203         return (bool) $this->sqlite->query($sql, [$page, $user, $status]);
239             $sql = 'SELECT user, status FROM structpublish_assignments WHERE pid = ? AND assigned = 1';
240             $list = $this->sqlite->queryAll($sql, [$page]);
257         $sql = 'SELECT pid, user, status, assigned FROM structpublish_assignments WHERE 1=1';
262             $sql .= ' AND assigned = 1';
265         $sql .= ' ORDER BY pid, user, status';
267         $list = $this->sqlite->queryAll($sql, $opts);