Lines Matching refs:sqlite
56 protected function insertOrIgnore(helper_plugin_sqlite $sqlite, $table, $entry) { argument
61 return $sqlite->query($sql, array_values($entry));
90 $sqlite = $data['sqlite'];
91 $db = $sqlite->getAdapter()->getDb();
97 $sqlite->query('DELETE FROM ireadit WHERE timestamp IS NULL');
99 $res = $sqlite->query('SELECT page,meta FROM meta');
100 while ($row = $sqlite->res_fetch_assoc($res)) {
108 …$res2 = $sqlite->query('SELECT user FROM ireadit WHERE page=? AND rev=? AND user=?', $page, $last_…
109 $existsAlready = $sqlite->res2single($res2);
111 $sqlite->storeEntry('ireadit', [
126 $sqlite = $data['sqlite'];
127 $db = $sqlite->getAdapter()->getDb();
129 $res = $sqlite->query('SELECT page,meta FROM meta');
130 while ($row = $sqlite->res_fetch_assoc($res)) {
132 $sqlite->storeEntry('meta2', [
138 $sqlite->query('DROP TABLE meta');
139 $sqlite->query('ALTER TABLE meta2 RENAME TO meta');
147 $sqlite = $data['sqlite'];
148 $db = $sqlite->getAdapter()->getDb();
178 $sqlite->storeEntry('meta', [
193 $sqlite = $data['sqlite'];
194 $db = $sqlite->getAdapter()->getDb();
226 $sqlite->storeEntry('ireadit', [
260 $this->insertOrIgnore($sqlite,'ireadit', [