/plugin/combo/grammar/ |
H A D | PageSql.g4 | 98 // https://www.sqlite.org/lang_expr.html
|
/plugin/combo/ |
H A D | requirements.txt | 2 https://github.com/cosmocode/sqlite.git lib/plugins/sqlite
|
/plugin/combo/syntax/ |
H A D | iterator.php | 365 $sqlite = Sqlite::createOrGetSqlite(); 418 $request = $sqlite
|
/plugin/data-au/_test/ |
H A D | action_edit_button.test.php | 8 protected $pluginsEnabled = array('dataau, 'sqlite');
|
H A D | action_handle.test.php | 8 protected $pluginsEnabled = array('dataau, 'sqlite');
|
/plugin/data-au/ |
H A D | action.php | 50 $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 D | requirements.txt | 2 https://github.com/cosmocode/sqlite.git lib/plugins/sqlite
|
/plugin/data-au/admin/ |
H A D | aliases.php | 65 $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 D | clean.php | 65 $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 D | cloud.php | 73 $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 D | entry.php | 210 $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 D | related.php | 36 $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 D | table.php | 245 $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 D | requirements.txt | 1 https://github.com/cosmocode/sqlite.git lib/plugins/sqlite
|
H A D | syntax.php | 15 $sqlite = plugin_load('helper', 'sqlite'); 16 if(!$sqlite){ 21 if(! $sqlite->init('data', dirname(__FILE__) . '/db/')){ 25 $this->db = $sqlite;
|
/plugin/data/ |
H A D | action.php | 57 $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 D | requirements.txt | 2 https://github.com/cosmocode/sqlite.git lib/plugins/sqlite
|
/plugin/data/admin/ |
H A D | aliases.php | 73 $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 D | clean.php | 12 * 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 D | cloud.php | 85 $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 D | entry.php | 230 $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 D | related.php | 41 $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 D | table.php | 253 $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 D | requirements.txt | 1 https://github.com/cosmocode/sqlite.git lib/plugins/sqlite
|
H A D | syntax.php | 15 $sqlite = plugin_load('helper', 'sqlite'); 16 if(!$sqlite){ 21 if(! $sqlite->init('data', dirname(__FILE__) . '/db/')){ 25 $this->db = $sqlite;
|