Lines Matching refs:sql

77             $sql = "REPLACE INTO opts (val,opt) VALUES ($version,'dbversion_structpublish')";
78             $ok = $ok && $sqlite->query($sql);
95         $sql = 'SELECT opt, val FROM opts WHERE opt=? OR opt=?';
96         $vals = $sqlite->queryAll($sql, ['dbversion', 'dbversion_structpublish']);
131             $sql = io_readFile(DOKU_PLUGIN . 'structpublish/db/update0001.sql', false);
132             $sqlArr = Tools::SQLstring2array($sql);
133             foreach ($sqlArr as $sql) {
134                 $ok = $ok && $sqlite->query($sql);
150         $sql = "SELECT rid, pid, latest, col1, max(col4) FROM $this->table GROUP BY pid, col1";
151         $latest = $sqlite->queryAll($sql);
154         $sql = "UPDATE $this->table SET latest = 0 WHERE rid NOT IN (" . implode(', ', $rids) . ')';
156         return (bool) $sqlite->query($sql);
168         $sql = "WITH cte AS (
180         $latest = $sqlite->queryAll($sql);
183         $sql = "UPDATE $this->table SET latest = 0 WHERE rid NOT IN (" . implode(', ', $rids) . ')';
185         return (bool) $sqlite->query($sql);