Home
last modified time | relevance | path

Searched refs:sqlite (Results 26 – 50 of 181) sorted by relevance

12345678

/plugin/data-au/admin/
H A Daliases.php65 $sqlite = $this->dthlp->_getDB();
66 if(!$sqlite) return;
68 $sqlite->query("BEGIN TRANSACTION");
69 if (!$sqlite->query("DELETE FROM aliases")) {
70 $sqlite->query('ROLLBACK TRANSACTION');
86 $sqlite->query('ROLLBACK TRANSACTION');
90 $sqlite->query("COMMIT TRANSACTION");
97 $sqlite = $this->dthlp->_getDB();
98 if(!$sqlite) return;
103 $res = $sqlite->query($sql);
[all …]
H A Dclean.php65 $sqlite = $this->dthlp->_getDB();
66 if(!$sqlite) return;
68 $res = $sqlite->query("SELECT pid, page FROM pages");
69 $rows = $sqlite->res2arr($res);
74 $sqlite->query('DELETE FROM dataau WHERE pid = ?',$row['pid']);
75 $sqlite->query('DELETE FROM pages WHERE pid = ?',$row['pid']);
/plugin/data/admin/
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...]
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']);
/plugin/struct/meta/
H A DSchema.php5 use dokuwiki\plugin\sqlite\SQLiteDB;
24 protected $sqlite; variable in dokuwiki\\plugin\\struct\\meta\\Schema
64 $this->sqlite = $helper->getDB();
87 $schema = $this->sqlite->queryAll($sql, $opt);
108 $rows = $this->sqlite->queryAll($sql, [$this->id]);
194 $this->sqlite->query('BEGIN TRANSACTION');
197 $this->sqlite->query($sql . 'data_' . $this->table);
198 $this->sqlite->query($sql . 'multi_' . $this->table);
201 $this->sqlite->query($sql);
204 $this->sqlite
[all...]
H A DAssignments.php19 protected $sqlite;
51 $this->sqlite = $helper->getDB();
63 $this->patterns = $this->sqlite->queryAll($sql);
77 $ok = (bool)$this->sqlite->query($sql, [$pattern, $table]);
98 $ok = (bool)$this->sqlite->query($sql, [$pattern, $table]);
105 $pagerows = $this->sqlite->queryAll($sql, [$table]);
131 $tablerows = $this->sqlite->queryAll($sql, [$pid]);
154 $ok = (bool)$this->sqlite->query($sql);
161 $ok = $ok && (bool)$this->sqlite->query($sql);
179 return (bool)$this->sqlite
17 protected $sqlite; global() variable in dokuwiki\\plugin\\struct\\meta\\Assignments
[all...]
H A DSchemaBuilder.php5 use dokuwiki\plugin\sqlite\SQLiteDB;
48 protected $sqlite;
69 $this->sqlite = $this->helper->getDB();
84 $this->sqlite->query('BEGIN TRANSACTION');
99 $this->sqlite->query('ROLLBACK TRANSACTION');
102 $this->sqlite->query('COMMIT TRANSACTION');
158 $this->sqlite->query($sql, [$this->table, $this->time, $this->user, $config]);
159 $this->newschemaid = $this->sqlite->queryValue('SELECT last_insert_rowid()');
188 $ok = $this->sqlite->saveRecord('types', $newEntry);
190 $newTid = $this->sqlite
47 protected $sqlite; global() variable in dokuwiki\\plugin\\struct\\meta\\SchemaBuilder
[all...]
/plugin/data-au/syntax/
H A Drelated.php36 $sqlite = $this->dthlp->_getDB();
37 if(!$sqlite) return false;
42 $res = $sqlite->query($dataau['sql']);
43 if(!$sqlite->res2count($res)) return true; // no rows matched
44 $rows = $sqlite->res2arr($res);
75 $sqlite = $this->dthlp->_getDB();
76 if(!$sqlite) return false;
88 $res = $sqlite->query($sql, $col, $id);
89 while($value = $sqlite->res_fetch_assoc($res)) {
95 $cond[] = " ( T1.key = " . $sqlite->quote_string($col) .
[all …]
/plugin/data/syntax/
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...]
/plugin/webdavclient/
H A Dhelper.php161 if(!$sqlite)
179 if(!$sqlite)
197 if(!$sqlite)
214 if(!$sqlite)
252 if(!$sqlite)
368 if(!$sqlite)
420 if(!$sqlite)
458 if(!$sqlite)
477 if(!$sqlite)
494 if(!$sqlite)
[all …]
/plugin/bez/mdl/
H A DSubscriptionFactory.php12 $r = $this->model->sqlite->query($q, $token);
13 return $this->model->sqlite->res2single($r);
24 $this->model->sqlite->query($q, $user_id);
31 $this->model->sqlite->query($q, $this->model->user_nick);
41 $this->model->sqlite->query($q, $this->model->user_nick);
50 $r = $this->model->sqlite->query($q, $this->model->user_nick);
51 $mute = $this->model->sqlite->res2single($r);
66 $r = $this->model->sqlite->query($q, $user);
67 $token = $this->model->sqlite->res2single($r);
70 $this->model->sqlite
[all...]
H A DThreadFactory.php14 $r = $this->model->sqlite->query('SELECT create_date FROM thread ORDER BY id LIMIT 1');
15 $date = $this->model->sqlite->res2single($r);
42 $r = $this->model->sqlite->query($sql, $from, $to);
53 $r = $this->model->sqlite->query($sql);
66 $r = $this->model->sqlite->query($sql, $from, $to);
71 $r = $this->model->sqlite->query($sql);
90 $r = $this->model->sqlite->query($sql, $from, $to, $from, $to);
97 $r = $this->model->sqlite->query($sql);
128 $r = $this->model->sqlite->query($sql, $from, $to);
147 $r = $this->model->sqlite
[all...]
/plugin/do/
H A Ddomd5changed.php10 $sqlite = sqlite_open('../../../data/meta/do.sqlite'); variable
12 sqlite_exec($sqlite, 'BEGIN TRANSACTION');
13 $res = sqlite_query($sqlite, $query);
20 …sqlite_exec($sqlite, 'UPDATE tasks SET text = \'' . sqlite_escape_string($row['tasks.text']) . '\'…
23 …sqlite_exec($sqlite, 'UPDATE task_status SET md5 = \'' . $md5 . '\' WHERE md5 = \'' . $row['tasks.…
26 sqlite_exec($sqlite, 'COMMIT');
28 sqlite_close($sqlite);
/plugin/fksnewsfeed/inc/ORM/
H A DModelStream.php23 …$res = $this->sqlite->query('SELECT * FROM priority o JOIN news n ON o.news_id=n.news_id WHERE str…
25 $ars = $this->sqlite->res2arr($res);
27 $service = new ServiceNews($this->sqlite);
29 $priority = ModelPriority::createFromArray($this->sqlite, $ar);
57 $res = $this->sqlite->query('SELECT * FROM dependence WHERE parent=?', $this->streamId);
58 $service = new ServiceStream($this->sqlite);
59 foreach ($this->sqlite->res2arr($res) as $row) {
70 $res = $this->sqlite->query('SELECT * FROM dependence WHERE child=?', $this->streamId);
71 $service = new ServiceStream($this->sqlite);
72 foreach ($this->sqlite->res2arr($res) as $row) {
/plugin/struct/helper/
H A Dimexport.php11 use dokuwiki\plugin\sqlite\SQLiteDB;
19 private $sqlite;
39 $this->sqlite = $helper->getDB(false);
40 if (!$this->sqlite instanceof SQLiteDB) return;
42 $schemaName = $this->sqlite->escape_string($schemaName);
47 $pattern = $this->sqlite->escape_string($pattern);
51 $this->sqlite->doTransaction($sql);
66 $this->sqlite = $helper->getDB(false);
67 if (!$this->sqlite instanceof SQLiteDB) return [];
70 $patterns = $this->sqlite
15 private $sqlite; global() variable in helper_plugin_struct_imexport
[all...]
/plugin/fksnewsfeed/
H A Dhelper.php47 public helper_plugin_sqlite $sqlite; variable in helper_plugin_newsfeed
62 $this->sqlite = $this->loadHelper('sqlite');
64 $this->serviceNews = new ServiceNews($this->sqlite);
65 $this->servicePriority = new ServicePriority($this->sqlite);
66 $this->serviceDependence = new ServiceDependence($this->sqlite);
67 $this->serviceStream = new ServiceStream($this->sqlite);
70 if (!$this->sqlite) {
74 …if (!$this->sqlite->init('newsfeed', DOKU_PLUGIN . $pluginName . DIRECTORY_SEPARATOR . 'db' . DIRE…
96 $res = $this->sqlite->query('SELECT * FROM dependence WHERE parent=?', $streamId);
97 foreach ($this->sqlite->res2arr($res) as $row) {
/plugin/firenews/
H A Dsyntax.php56 $sqlite = $this->sqlConnection($pluginname);
59 $sqlite->query("CREATE TABLE IF NOT EXISTS $tablename
176 $sqlite->query("UPDATE {$tablename}
198 $sqlite->query("DELETE FROM {$tablename}
238 $result = $sqlite->query("SELECT * FROM {$tablename}
298 /** @var helper_plugin_sqlite $sqlite */
299 $sqlite = plugin_load('helper', 'sqlite');
300 if (!$sqlite) {
308 if (!$sqlite->init($dbname, $updatedir)) {
312 return $sqlite;
[all …]
/plugin/bez/action/
H A Dmigration.php31 if ($event->data['sqlite']->getAdapter()->getDbName() !== 'b3p') {
46 /** @var helper_plugin_sqlite $sqlite */
47 $sqlite = $data['sqlite'];
58 $db = $sqlite->getAdapter()->getPdo();
79 /** @var helper_plugin_sqlite $sqlite */
80 $sqlite = $data['sqlite'];
91 $db = $sqlite->getAdapter()->getPdo();
113 * @param helper_plugin_sqlite $sqlite
[all...]
/plugin/top/_test/
H A Ddate.test.php18 $sqlite = $top_helper->getDBHelper();
21 $sqlite->query($sql,'wiki:start',3,'','201407');
22 $sqlite->query($sql,'wiki:start',2,'','201401');
23 $sqlite->query($sql,'wiki:start',6,'','201201');
24 $sqlite->query($sql,'wiki:start',1,'',null);
25 $sqlite->query($sql,'en:wiki:start',8,'en','201201');
26 $sqlite->query($sql,'en:wiki:start',1,'en','201303');
27 $sqlite->query($sql,'de:wiki:start',6,'de','201201');
/plugin/bibtex4dw/lib/
H A Dbibtexrender.php25 public static $sqlite = array(); variable in bibtexrender_plugin_bibtex4dw
33 'sqlite' => false,
92 $this->_conf['sqlite'] = $this->plugin->getConf('sqlite');
98 if ($this->_conf['sqlite']) {
99 $this->sqlite = plugin_load('helper', 'sqlite');
100 if(!$this->sqlite){
101 msg('You asked for using the sqlite plugin but it is not installed. Please install it', -1);
105 if(!$this->sqlite
[all...]
/plugin/combo/ComboStrap/
H A DEvent.php60 $sqlite = Sqlite::createOrGetBackendSqlite();
72 $version = $sqlite->getVersion();
76 // https://www.sqlite.org/lang_returning.html
80 // https://www.sqlite.org/lang_delete.html#optional_limit_and_order_by_clauses
81 if ($sqlite->hasOption("SQLITE_ENABLE_UPDATE_DELETE_LIMIT")) {
84 $request = $sqlite->createRequest()
112 $request = $sqlite->createRequest()
132 $request = $sqlite->createRequest()
193 $sqlite = Sqlite::createOrGetBackendSqlite();
214 $request = $sqlite
[all...]
/plugin/sqlite/helper/
H A Ddb.php6 * DokuWiki Plugin sqlite (Helper Component)
16 protected $sqlite;
32 $this->sqlite = plugin_load('helper', 'sqlite');
35 if (!$this->sqlite->init('sqlite', DOKU_PLUGIN . 'sqlite/db/')) {
36 $this->sqlite = null;
45 return $this->sqlite;
14 protected $sqlite; global() variable in helper_plugin_sqlite_db
/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);
/plugin/telleveryone/
H A Dapi.php10 $sqlite = $db_helper->getDB(); variable
16 $res = $sqlite->query("SELECT value FROM config WHERE key='token'");
17 if ($sqlite->res2single($res) != $INPUT->str('token')) {
22 $res = $sqlite->query('SELECT id, timestamp, user, message_html FROM log
24 $arr = $sqlite->res2arr($res);
/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...]

12345678