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);
190         $sql = "REPLACE INTO pages (page, lastmod) VALUES (?,?)";
191         $this->db->exec($sql, [$page, $lastmod]);
204         $sql = "UPDATE assignments SET pageassignees = '' WHERE page = ?";
205         $this->db->exec($sql, $page);
219         $sql = "REPLACE INTO assignments ('page', 'pageassignees') VALUES (?,?)";
220         $this->db->exec($sql, [$page, $assignees]);
245         $sql = "REPLACE INTO assignments ('page', 'autoassignees') VALUES (?,?)";
246         $this->db->exec($sql, [$page, $assignees]);
259         $sql = "SELECT pageassignees,autoassignees FROM assignments WHERE page = ?";
260         $record = $this->db->queryRecord($sql, $page);
279         $sql = "SELECT A.page, A.pageassignees, A.autoassignees, B.lastmod, C.user, C.ack FROM assignments A
287             $sql .= ' AND ack IS NULL';
290         return $this->db->queryAll($sql, $user, $user, implode('///', $groups));
306         $sql = "SELECT pageassignees || ',' || autoassignees AS 'assignments'
309         $assignments = $this->db->queryValue($sql, $page);
337         $sql = "SELECT pattern, assignees FROM assignments_patterns";
338         return $this->db->queryKeyValueList($sql);
354             $sql = "UPDATE assignments SET autoassignees = ''";
355             $this->db->exec($sql);
358             $sql = "DELETE FROM assignments_patterns";
359             $this->db->exec($sql);
364             $sql = "REPLACE INTO assignments_patterns (pattern, assignees) VALUES (?,?)";
369                 $this->db->exec($sql, [$pattern, $assignees]);
382             $sql = "INSERT INTO assignments (page, autoassignees) VALUES (?, ?)
388                 $this->db->exec($sql, [$page, $assignees, $assignees]);
405         $sql = "SELECT page FROM pages WHERE MATCHES_PAGE_PATTERN(?, page)";
406         $pages = $this->db->queryAll($sql, $pattern);
423         $sql = "SELECT ack
430         $acktime = $this->db->queryValue($sql, $page, $user);
445         $sql = "SELECT MAX(ack)
450         return $this->db->queryValue($sql, [$page, $user]);
462         $sql = "INSERT INTO acks (page, user, ack) VALUES (?,?, strftime('%s','now'))";
464         $this->db->exec($sql, $page, $user);
483         $sql = "SELECT A.page, A.pageassignees, A.autoassignees, B.lastmod, C.user, MAX(C.ack) AS ack
491         $sql .= $filterClause;
492         $sql .= "
495         return $this->db->queryAll($sql, [$user, $user, implode('///', $groups)]);
531         $sql = "SELECT A.page, A.lastmod, B.user, MAX(B.ack) AS ack
537         $sql .= " GROUP BY A.page, B.user ";
538         if ($max) $sql .= " LIMIT $max";
540         $acknowledgements = $this->db->queryAll($sql, $params);
590         $sql = '
598         return $this->db->queryAll($sql, $limit);