Lines Matching refs:sql

77         $sql = "INSERT OR IGNORE INTO pages (page, lastmod) VALUES (?,?)";
85                     $this->db->exec($sql, [$page, $lastmod]);
170         $sql = "DELETE FROM pages WHERE page = ?";
171         $this->db->exec($sql, $page);
192         $sql = "REPLACE INTO pages (page, lastmod) VALUES (?,?)";
193         $this->db->exec($sql, [$page, $lastmod]);
206         $sql = "UPDATE assignments SET pageassignees = '' WHERE page = ?";
207         $this->db->exec($sql, $page);
221         $sql = "REPLACE INTO assignments ('page', 'pageassignees') VALUES (?,?)";
222         $this->db->exec($sql, [$page, $assignees]);
247         $sql = "REPLACE INTO assignments ('page', 'autoassignees') VALUES (?,?)";
248         $this->db->exec($sql, [$page, $assignees]);
261         $sql = "SELECT pageassignees,autoassignees FROM assignments WHERE page = ?";
262         $record = $this->db->queryRecord($sql, $page);
281 …$sql = "SELECT A.page, A.pageassignees, A.autoassignees, B.lastmod, C.user, C.ack FROM assignments…
289             $sql .= ' AND ack IS NULL';
292         return $this->db->queryAll($sql, $user, $user, implode('///', $groups));
308         $sql = "SELECT pageassignees || ',' || autoassignees AS 'assignments'
311         $assignments = $this->db->queryValue($sql, $page);
339         $sql = "SELECT pattern, assignees FROM assignments_patterns";
340         return $this->db->queryKeyValueList($sql);
356             $sql = "UPDATE assignments SET autoassignees = ''";
357             $this->db->exec($sql);
360             $sql = "DELETE FROM assignments_patterns";
361             $this->db->exec($sql);
366             $sql = "REPLACE INTO assignments_patterns (pattern, assignees) VALUES (?,?)";
371                 $this->db->exec($sql, [$pattern, $assignees]);
384             $sql = "INSERT INTO assignments (page, autoassignees) VALUES (?, ?)
390                 $this->db->exec($sql, [$page, $assignees, $assignees]);
407         $sql = "SELECT page FROM pages WHERE MATCHES_PAGE_PATTERN(?, page)";
408         $pages = $this->db->queryAll($sql, $pattern);
425         $sql = "SELECT ack
432         $acktime = $this->db->queryValue($sql, $page, $user);
447         $sql = "SELECT MAX(ack)
452         return $this->db->queryValue($sql, [$page, $user]);
464         $sql = "INSERT INTO acks (page, user, ack) VALUES (?,?, strftime('%s','now'))";
466         $this->db->exec($sql, $page, $user);
485 …      $sql = "SELECT A.page, A.pageassignees, A.autoassignees, B.lastmod, C.user, MAX(C.ack) AS ack
493         $sql .= $filterClause;
494         $sql .= "
497         return $this->db->queryAll($sql, [$user, $user, implode('///', $groups)]);
533         $sql = "SELECT A.page, A.lastmod, B.user, MAX(B.ack) AS ack
539         $sql .= " GROUP BY A.page, B.user ";
540         if ($max) $sql .= " LIMIT $max";
542         $acknowledgements = $this->db->queryAll($sql, $params);
592         $sql = '
600         return $this->db->queryAll($sql, $limit);