Home
last modified time | relevance | path

Searched refs:sqlite (Results 51 – 75 of 181) sorted by path

12345678

/plugin/combo/grammar/
H A DPageSql.g498 // https://www.sqlite.org/lang_expr.html
/plugin/combo/
H A Drequirements.txt2 https://github.com/cosmocode/sqlite.git lib/plugins/sqlite
/plugin/combo/syntax/
H A Diterator.php365 $sqlite = Sqlite::createOrGetSqlite();
418 $request = $sqlite
/plugin/data-au/_test/
H A Daction_edit_button.test.php8 protected $pluginsEnabled = array('dataau, 'sqlite');
H A Daction_handle.test.php8 protected $pluginsEnabled = array('dataau, 'sqlite');
/plugin/data-au/
H A Daction.php50 $sqlite = $this->dthlp->_getDB();
51 if(!$sqlite) return;
55 $res = $sqlite->query('SELECT pid FROM pages WHERE page = ?',$id);
56 $pid = (int) $sqlite->res2single($res);
59 $sqlite->query('DELETE FROM dataau WHERE pid = ?',$pid);
60 $sqlite->query('DELETE FROM pages WHERE pid = ?',$pid);
H A Drequirements.txt2 https://github.com/cosmocode/sqlite.git lib/plugins/sqlite
/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-au/syntax/
H A Dcloud.php73 $sqlite = $this->dthlp->_getDB();
74 if(!$sqlite) return false;
98 $from .= ' AND ' . $tables[$col] . ".key = " . $sqlite->quote_string($col);
110 WHERE dataau.key = " . $sqlite->quote_string($ckey) . "
140 $sqlite = $this->dthlp->_getDB();
141 if(!$sqlite) return false;
153 $res = $sqlite->query($dataau['sql']);
154 $rows = $sqlite->res2arr($res);
H A Dentry.php210 $sqlite = $this->dthlp->_getDB();
211 if(!$sqlite) return false;
220 $sqlite->query("BEGIN TRANSACTION");
237 $pid = (int) $sqlite->res2single($res);
238 $sqlite->res_close($res);
242 $sqlite->query("ROLLBACK TRANSACTION");
247 $sqlite->query("DELETE FROM DATA WHERE pid = ?", $pid);
265 $sqlite->query("COMMIT TRANSACTION");
286 $sqlite = $this->dthlp->_getDB();
287 if(!$sqlite) return false;
[all …]
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 …]
H A Dtable.php245 $sqlite = $this->dthlp->_getDB();
246 if(!$sqlite) return false;
260 $res = $sqlite->query($dataau['sql']);
262 $rows = $sqlite->res2arr($res);
571 $sqlite = $this->dthlp->_getDB();
572 if(!$sqlite) return false;
591 $from .= ' AND ' . $tables[$key] . ".key = " . $sqlite->quote_string($key);
628 $from .= ' AND ' . $tables[$col] . ".key = " . $sqlite->quote_string($col);
662 $from2 .= ' AND ' . $table . ".key = " . $sqlite->quote_string($col);
666 …e2 .= ' ' . $filter['logic'] . ' DATARESOLVE(' . $table . '.value,\'' . $sqlite->escape_string($fi…
/plugin/data-graph/
H A Drequirements.txt1 https://github.com/cosmocode/sqlite.git lib/plugins/sqlite
H A Dsyntax.php15 $sqlite = plugin_load('helper', 'sqlite');
16 if(!$sqlite){
21 if(! $sqlite->init('data', dirname(__FILE__) . '/db/')){
25 $this->db = $sqlite;
/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 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/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/datagraph/
H A Drequirements.txt1 https://github.com/cosmocode/sqlite.git lib/plugins/sqlite
H A Dsyntax.php15 $sqlite = plugin_load('helper', 'sqlite');
16 if(!$sqlite){
21 if(! $sqlite->init('data', dirname(__FILE__) . '/db/')){
25 $this->db = $sqlite;

12345678