Lines Matching refs:sqlite

36         if ($event->data['sqlite']->getAdapter()->getDbname() !== 'ireadit') {
56     protected function insertOrIgnore(helper_plugin_sqlite $sqlite, $table, $entry) {
61         return $sqlite->query($sql, array_values($entry));
89         /** @var helper_plugin_sqlite $sqlite */
90         $sqlite = $data['sqlite'];
96         $sqlite->query('DELETE FROM ireadit WHERE timestamp IS NULL');
98         $res = $sqlite->query('SELECT page,meta FROM meta');
99         while ($row = $sqlite->res_fetch_assoc($res)) {
107                 $res2 = $sqlite->query('SELECT user FROM ireadit WHERE page=? AND rev=? AND user=?', $page, $last_change_date, $user);
108                 $existsAlready = $sqlite->res2single($res2);
110                     $sqlite->storeEntry('ireadit', [
124         /** @var helper_plugin_sqlite $sqlite */
125         $sqlite = $data['sqlite'];
127         $res = $sqlite->query('SELECT page,meta FROM meta');
128         while ($row = $sqlite->res_fetch_assoc($res)) {
130             $sqlite->storeEntry('meta2', [
136         $sqlite->query('DROP TABLE meta');
137         $sqlite->query('ALTER TABLE meta2 RENAME TO meta');
144         /** @var helper_plugin_sqlite $sqlite */
145         $sqlite = $data['sqlite'];
146         $db = $sqlite->getAdapter()->getPdo();
176             $sqlite->storeEntry('meta', [
190         /** @var helper_plugin_sqlite $sqlite */
191         $sqlite = $data['sqlite'];
192         $db = $sqlite->getAdapter()->getPdo();
224                     $sqlite->storeEntry('ireadit', [
258                     $this->insertOrIgnore($sqlite,'ireadit', [