Home
last modified time | relevance | path

Searched refs:sqlite (Results 76 – 100 of 181) sorted by last modified time

12345678

/plugin/data/
H A Daction.php57 $sqlite = $this->dthlp->getDB();
58 if (!$sqlite) return;
62 $pid = (int) $sqlite->queryValue('SELECT pid FROM pages WHERE page = ?', $id);
65 $sqlite->exec('DELETE FROM data WHERE pid = ?', $pid);
66 $sqlite->exec('DELETE FROM pages WHERE pid = ?', $pid);
H A Drequirements.txt2 https://github.com/cosmocode/sqlite.git lib/plugins/sqlite
/plugin/data/admin/
H A Dclean.php12 * Let admin remove non-existing pages from sqlite db
69 $sqlite = $this->dthlp->getDB();
70 if (!$sqlite) return;
72 $rows = $sqlite->queryAll('SELECT pid, page FROM pages');
77 $sqlite->exec('DELETE FROM data WHERE pid = ?', $row['pid']);
78 $sqlite->exec('DELETE FROM pages WHERE pid = ?', $row['pid']);
H A Daliases.php73 $sqlite = $this->dthlp->getDB();
74 if (!$sqlite) return;
76 $sqlite->getPdo()->beginTransaction();
78 $sqlite->exec('DELETE FROM aliases');
91 $sqlite->saveRecord('aliases', $row);
93 $sqlite->getPdo()->commit();
97 $sqlite->getPdo()->rollBack();
106 $sqlite = $this->dthlp->getDB();
107 if (!$sqlite) return;
112 $rows = $sqlite
[all...]
/plugin/data/syntax/
H A Dcloud.php85 $sqlite = $this->dthlp->getDB();
86 if (!$sqlite) return false;
107 $from .= ' AND ' . $tables[$col] . ".key = " . $sqlite->getPdo()->quote($col);
119 WHERE data.key = " . $sqlite->getPdo()->quote($ckey) . "
155 $sqlite = $this->dthlp->getDB();
156 if (!$sqlite) return false;
168 $rows = $sqlite->queryAll($data['sql']);
H A Dentry.php230 $sqlite = $this->dthlp->getDB();
231 if (!$sqlite) return false;
239 $sqlite->getPdo()->beginTransaction();
270 $sqlite->query("DELETE FROM DATA WHERE pid = ?", $pid);
292 $sqlite->getPdo()->commit();
294 $sqlite->getPdo()->rollBack();
320 $sqlite = $this->dthlp->getDB();
321 if (!$sqlite) return false;
323 return call_user_func_array(array(&$sqlite, 'query'), $args);
H A Drelated.php41 $sqlite = $this->dthlp->getDB();
42 if (!$sqlite) return false;
47 $rows = $sqlite->queryAll($data['sql']);
80 $sqlite = $this->dthlp->getDB();
81 if (!$sqlite) return false;
92 $rows = $sqlite->queryAll($sql, $col, $id);
97 $in = implode(',', array_map([$sqlite->getPdo(), 'quote'], $values));
98 $cond[] = " ( T1.key = " . $sqlite->getPdo()->quote($col) .
119 $from .= ' AND ' . $tables[$col] . ".key = " . $sqlite->getPdo()->quote($col);
151 $from .= ' AND ' . $tables[$col] . ".key = " . $sqlite
[all...]
H A Dtable.php253 $sqlite = $this->dthlp->getDB();
254 if (!$sqlite) return false;
268 $rows = $sqlite->queryAll($data['sql']);
586 $sqlite = $this->dthlp->getDB();
587 if (!$sqlite) return false;
606 $from .= ' AND ' . $tables[$key] . ".key = " . $sqlite->getPdo()->quote($key);
643 $from .= ' AND ' . $tables[$col] . ".key = " . $sqlite->getPdo()->quote($col);
680 $from2 .= ' AND ' . $table . ".key = " . $sqlite->getPdo()->quote($col);
685 ' DATARESOLVE(' . $table . '.value,' . $sqlite->getPdo()->quote($filter['colname']) . ') ' .
/plugin/randomtables/helper/
H A Dhelper.php12 /** @var helper_plugin_sqlite $sqlite */
13 $sqlite = plugin_load('helper', 'sqlite');
15 if(!$sqlite){
16 msg('This plugin requires the sqlite plugin. Please install it', -1);
20 if(!$sqlite->init('randomtables', DOKU_PLUGIN . 'randomtables/db/')){
24 return $sqlite;
/plugin/sql2wiki/
H A DREADME3 Save results of sqlite queries into page syntax.
H A Dplugin.info.txt6 desc Save results of sqlite queries into page syntax.
/plugin/sql2wiki/action/
H A Dsqlite.php3 use dokuwiki\plugin\sqlite\QuerySaver;
4 use dokuwiki\plugin\sqlite\SQLiteDB;
/plugin/approve/
H A Dadmin.php36 $sqlite = $db_helper->getDB();
48 $sqlite->query('DELETE FROM maintainer WHERE id=?', $assignment['id']);
49 $helper->updatePagesAssignments($sqlite);
59 $sqlite->storeEntry('maintainer', $data);
61 $helper->updatePagesAssignments($sqlite);
80 $sqlite = $db_helper->getDB();
86 $res = $sqlite->query('SELECT * FROM maintainer ORDER BY namespace');
87 $assignments = $sqlite->res2arr($res);
H A Dhelper.php8 * @param helper_plugin_sqlite $sqlite
11 public function no_apr_namespace(helper_plugin_sqlite $sqlite) { argument
14 $res = $sqlite->query('SELECT value FROM config WHERE key=?', $key);
15 $no_apr_namespaces_db = $sqlite->res2single($res);
19 $sqlite->query('UPDATE config SET value=? WHERE key=?', $no_apr_namespaces_conf, $key);
21 $res = $sqlite->query('SELECT page, hidden FROM page');
22 $pages = $sqlite->res2arr($res);
26 $in_hidden_namespace = $this->in_hidden_namespace($sqlite, $id, $no_apr_namespaces_conf);
30 $sqlite->query('UPDATE page SET hidden=? WHERE page=?', $new_hidden, $id);
39 * @param helper_plugin_sqlite $sqlite
44 use_approve_here(helper_plugin_sqlite $sqlite, $id, & $approver = null) global() argument
63 find_last_approved(helper_plugin_sqlite $sqlite, $id) global() argument
75 get_hidden_namespaces_list(helper_plugin_sqlite $sqlite, $no_apr_namespaces = null) global() argument
95 in_hidden_namespace(helper_plugin_sqlite $sqlite, $id, $no_apr_namespaces = null) global() argument
110 weighted_assignments(helper_plugin_sqlite $sqlite) global() argument
139 isPageAssigned(helper_plugin_sqlite $sqlite, $id, & $pageApprover = null, $weighted_assignments = null) global() argument
173 updatePagesAssignments(helper_plugin_sqlite $sqlite) global() argument
[all...]
/plugin/approve/helper/
H A Ddb.php18 protected $sqlite; variable in helper_plugin_approve_db
35 /** @var helper_plugin_sqlite $sqlite */
36 $this->sqlite = plugin_load('helper', 'sqlite');
37 if (!$this->sqlite) {
39 throw new \Exception('Couldn\'t load sqlite.');
44 if ($this->sqlite->getAdapter()->getName() != DOKU_EXT_PDO) {
46 throw new \Exception('Couldn\'t load PDO sqlite.');
48 $this->sqlite = null;
51 $this->sqlite
[all...]
/plugin/approve/syntax/
H A Dtable.php
/plugin/approve/action/
H A Dmigration.php34 if ($event->data['sqlite']->getAdapter()->getDbname() !== 'approve') {
54 protected function insertOrIgnore(helper_plugin_sqlite $sqlite, $table, $entry) { argument
59 return $sqlite->query($sql, array_values($entry));
64 /** @var helper_plugin_sqlite $sqlite */
65 $sqlite = $data['sqlite'];
66 $db = $sqlite->getAdapter()->getDb();
77 $sqlite->storeEntry('maintainer',[
84 $sqlite->storeEntry('maintainer',[
92 $sqlite
[all...]
H A Dnotification.php37 $sqlite = $db_helper->getDB();
38 $event->data['dependencies'][] = $sqlite->getAdapter()->getDbFile();
H A Dprettyprint.php17 $sqlite = $db_helper->getDB();
28 if (!$helper->use_approve_here($sqlite, $INFO['id'], $approver)) return;
45 $res = $sqlite->query('SELECT ready_for_approval, ready_for_approval_by,
50 $approve = $sqlite->res_fetch_assoc($res);
H A Dapprove.php28 $sqlite = $db_helper->getDB();
36 if (!$helper->use_approve_here($sqlite, $INFO['id'])) return;
58 $sqlite = $db_helper->getDB();
66 if (!$helper->use_approve_here($sqlite, $INFO['id'])) return;
68 $last_approved_rev = $helper->find_last_approved($sqlite, $INFO['id']);
83 $sqlite = $db_helper->getDB();
93 if (!$helper->use_approve_here($sqlite, $INFO['id'], $approver)) return;
96 $res = $sqlite->query('SELECT MAX(version)+1 FROM revision
98 $next_version = $sqlite->res2single($res);
103 $sqlite
[all...]
H A Dcache.php44 $sqlite = $db_helper->getDB();
45 $cache->depends['files'][] = $sqlite->getAdapter()->getDbFile();
H A Dmove.php30 $sqlite = $db_helper->getDB();
40 $sqlite->query('UPDATE revision SET page=? WHERE page=?', $new, $old);
H A Drevisions.php21 $sqlite = $db_helper->getDB();
29 if (!$helper->use_approve_here($sqlite, $INFO['id'])) return;
31 $res = $sqlite->query('SELECT rev, approved, ready_for_approval
34 $approve_revisions = $sqlite->res2arr($res);
/plugin/notification/helper/
H A Dcron.php11 protected $sqlite; variable in helper_plugin_notification_cron
17 $this->sqlite = $db_helper->getDB();
25 $res = $this->sqlite->query('SELECT user from cron_check');
26 $ourUsers = $this->sqlite->res2arr($res);
39 $this->sqlite->storeEntry('cron_check',
H A Ddb.php18 protected $sqlite; variable in helper_plugin_notification_db
36 $this->sqlite = plugin_load('helper', 'sqlite');
37 if (!$this->sqlite) {
48 $this->sqlite = null;
51 $this->sqlite->getAdapter()->setUseNativeAlter(true);
58 $this->sqlite = null;
70 …if ($this->sqlite && $conf['metadir'] != substr($this->sqlite->getAdapter()->getDbFile(), 0, $len)…
73 if (!$this->sqlite) {
77 return $this->sqlite;
87 if (!$this->sqlite) {
[all …]

12345678