/plugin/dbquery/ |
H A D | helper.php | 88 * @param string $sql 92 public function prepareStatement(\PDO $pdo, $sql, $parameters) argument 103 $sql = str_replace(':groups', join(',', $groupids), $sql); 105 $sth = $pdo->prepare($sql); 109 if (strpos($sql, $key) === false) continue; // skip if parameter is missing
|
/plugin/dbquery/_test/ |
H A D | HelperTest.php | 76 $sql = 'SELECT :user, :mail, :id, :page, :ns WHERE \'foo\' in (:groups)'; 77 $sth = $this->hlp->prepareStatement($pdo, $sql, $parameters);
|
/plugin/structpublish/action/ |
H A D | migration.php | 23 * which processes updateXXXX.sql files 72 $sql = "REPLACE INTO opts (val,opt) VALUES ($version,'dbversion_structpublish')"; 73 $ok = $ok && $sqlite->query($sql); 90 $sql = 'SELECT opt, val FROM opts WHERE opt=? OR opt=?'; 91 $vals = $sqlite->queryAll($sql, ['dbversion', 'dbversion_structpublish']); 126 $sql = io_readFile(DOKU_PLUGIN . 'structpublish/db/update0001.sql', false); 127 $sqlArr = Tools::SQLstring2array($sql); 128 foreach ($sqlArr as $sql) { 129 $ok = $ok && $sqlite->query($sql); [all...] |
/plugin/structpublish/helper/ |
H A D | db.php | 50 $sql = 'SELECT pid FROM titles'; 51 $list = $sqlite->queryAll($sql); 73 $sql = 'SELECT pid FROM structpublish_assignments WHERE pid = ? AND assigned = 1'; 74 return (bool) $sqlite->queryAll($sql, $pid);
|
/plugin/structpublish/meta/ |
H A D | AccessTableStructpublish.php | 73 $sql = "SELECT rev FROM $table $where ORDER BY rev DESC LIMIT 1"; 74 $ret = $this->sqlite->queryValue($sql, $opts);
|
H A D | Assignments.php | 60 $sql = 'SELECT * FROM structpublish_assignments_patterns ORDER BY pattern'; 61 $this->patterns = $this->sqlite->queryAll($sql); 75 $sql = 'REPLACE INTO structpublish_assignments_patterns (pattern, user, status) VALUES (?,?,?)'; 76 $ok = (bool) $this->sqlite->query($sql, [$pattern, $user, $status]); 113 $sql = 'DELETE FROM structpublish_assignments_patterns WHERE pattern = ? AND user = ? AND status = ?'; 114 $ok = (bool) $this->sqlite->query($sql, [$pattern, $user, $status]); 120 $sql = 'SELECT pid FROM structpublish_assignments WHERE user = ? AND status = ?'; 121 $pagerows = $this->sqlite->queryAll($sql, [$user, $status]); 163 $sql = 'DELETE FROM structpublish_assignments_patterns'; 164 $ok = (bool) $this->sqlite->query($sql); [all...] |
/plugin/struct/meta/ |
H A D | AccessTable.php | 336 $sql = array_shift($query); 337 $ok = $ok && $this->sqlite->query($sql, $query); 443 [$sql, $opt] = $this->buildGetDataSQL($idColumn); 445 return $this->sqlite->queryAll($sql, $opt);
|
H A D | AccessTableGlobal.php | 27 $sql = 'DELETE FROM data_' . $this->schema->getTable() . ' WHERE rid = ?'; 28 $this->sqlite->query($sql, $this->rid); 29 $sql = 'DELETE FROM multi_' . $this->schema->getTable() . ' WHERE rid = ?'; 30 $this->sqlite->query($sql, $this->rid);
|
H A D | AccessTablePage.php | 58 $sql = "SELECT rev FROM $table $where ORDER BY rev DESC LIMIT 1"; 59 $ret = $this->sqlite->queryValue($sql, $opts);
|
H A D | Assignments.php | 62 $sql = 'SELECT * FROM schema_assignments_patterns ORDER BY pattern'; 63 $this->patterns = $this->sqlite->queryAll($sql); 76 $sql = 'REPLACE INTO schema_assignments_patterns (pattern, tbl) VALUES (?,?)'; 77 $ok = (bool)$this->sqlite->query($sql, [$pattern, $table]); 97 $sql = 'DELETE FROM schema_assignments_patterns WHERE pattern = ? AND tbl = ?'; 98 $ok = (bool)$this->sqlite->query($sql, [$pattern, $table]); 104 $sql = 'SELECT pid FROM schema_assignments WHERE tbl = ?'; 105 $pagerows = $this->sqlite->queryAll($sql, [$table]); 130 $sql = 'SELECT tbl FROM schema_assignments WHERE pid = ?'; 131 $tablerows = $this->sqlite->queryAll($sql, [ [all...] |
H A D | PageMeta.php | 41 $sql = "SELECT pid, title, lasteditor, lastrev, lastsummary FROM titles WHERE pid = ?"; 42 $data = $this->sqlite->queryRecord($sql, [$this->pid]); 51 $sql = "REPLACE INTO titles (pid, title, lasteditor, lastrev, lastsummary) VALUES (?,?,?,?,?)"; 52 $this->sqlite->query($sql, [$this->pid, $this->title, $this->lasteditor, $this->lastrev, $this->lastsummary]);
|
H A D | QueryBuilder.php | 207 * @return array ($sql, $vals) 229 $sql = 235 $sql .= 240 $sql .= 244 return [$sql, array_values($this->values)]; 255 fixPlaceholders($sql) global() argument
|
H A D | QueryBuilderWhere.php | 120 $sql = ' '; 121 if (!$first) $sql .= $this->type . ' '; 125 $sql .= '('; 127 $sql .= $where->toSQL($first); 130 $sql .= ' )'; 132 $sql .= $this->statement; 135 return $sql;
|
H A D | Schema.php | 72 $sql = "SELECT * 80 $sql = "SELECT * 87 $schema = $this->sqlite->queryAll($sql, $opt); 102 $sql = "SELECT SC.*, T.* 108 $rows = $this->sqlite->queryAll($sql, [$this->id]); 196 $sql = "DROP TABLE "; 197 $this->sqlite->query($sql . 'data_' . $this->table); 198 $this->sqlite->query($sql . 'multi_' . $this->table); 200 $sql = "DELETE FROM schema_assignments WHERE tbl = '$this->table'"; 201 $this->sqlite->query($sql); [all...] |
H A D | SchemaBuilder.php | 157 $sql = "INSERT INTO schemas (tbl, ts, user, config) VALUES (?, ?, ?, ?)"; 158 $this->sqlite->query($sql, [$this->table, $this->time, $this->user, $config]); 318 $sql = "CREATE TABLE $tbl ( 326 $ok = $ok && (bool)$this->sqlite->query($sql); 329 $sql = "CREATE TABLE $tbl ( 340 $ok = $ok && (bool)$this->sqlite->query($sql); 354 $sql = " ALTER TABLE $tbl ADD COLUMN col$index DEFAULT ''"; 355 if (!$this->sqlite->query($sql)) {
|
H A D | Search.php | 468 [$sql, $opts] = $this->getSQL(); 471 $res = $this->sqlite->query($sql, $opts); 472 if ($res === false) throw new StructException("SQL execution failed for\n\n$sql"); 489 * @return array ($sql, $opts) The SQL and parameters to execute
|
H A D | SearchCloud.php | 19 * @return array ($sql, $opts) The SQL and parameters to execute 84 [$sql, $opts] = $QB->getSQL(); 85 return [$sql . $this->limit, $opts]; 107 [$sql, $opts] = $this->getSQL(); 110 $res = $this->sqlite->query($sql, $opts); 111 if ($res === false) throw new StructException("SQL execution failed for\n\n$sql");
|
/plugin/struct/types/ |
H A D | Lookup.php | 253 $sql = $QB->getSelectStatement($alias); 254 $QB->addSelectStatement("STRUCT_JSON($tablealias.$colname, $sql)", $alias);
|
H A D | Tag.php | 58 $sql = $this->buildSQLFromContext($context); 64 $rows = $sqlite->queryAll($sql, $opt); 78 * Create the sql to query the database for tags to do autocompletion 84 * @return string The sql with a single "?" placeholde for the search value 88 $sql = ''; 91 $sql .= "SELECT DISTINCT value 98 $sql .= "SELECT DISTINCT col{$context->getColref()} AS value 103 $sql .= "AND ( D.pid = '' OR ("; 104 $sql .= "PAGEEXISTS(D.pid) = 1\n"; 105 $sql [all...] |
/plugin/struct/action/ |
H A D | migration.php | 59 $sql = "SELECT name FROM sqlite_master WHERE type = 'table' AND name LIKE 'multi_%'"; 60 $tables = $sqlite->queryAll($sql); 64 $sql = "ALTER TABLE $table ADD COLUMN latest INT DEFAULT 1"; 65 $sqlite->query($sql); 82 $sql = "SELECT sql, name FROM sqlite_master 85 $tables = $sqlite->queryAll($sql); 88 $sql = "SELECT MAX(id) AS id, tbl, islookup FROM schemas 91 $schemas = $sqlite->queryAll($sql); 98 $sql [all...] |
H A D | move.php | 103 $sql = "UPDATE data_$tbl SET pid = ? WHERE pid = ?"; 104 $this->db->query($sql, [$new, $old]); 107 $sql = "UPDATE multi_$tbl SET pid = ? WHERE pid = ?"; 108 $this->db->query($sql, [$new, $old]); 121 $sql = "UPDATE schema_assignments SET pid = ? WHERE pid = ?"; 122 $this->db->query($sql, [$new, $old]); 136 $sql = "UPDATE titles SET pid = ? WHERE pid = ?"; 137 $this->db->query($sql, [$new, $old]); 156 $sql = "UPDATE multi_$table 163 $sql [all...] |
/plugin/struct/helper/ |
H A D | imexport.php | 43 $sql = []; 44 $sql[] = "DELETE FROM schema_assignments_patterns WHERE tbl = '$schemaName'"; 45 $sql[] = "DELETE FROM schema_assignments WHERE tbl = '$schemaName'"; 48 $sql[] = "INSERT INTO schema_assignments_patterns (pattern, tbl) VALUES ('$pattern','$schemaName')"; 51 $this->sqlite->doTransaction($sql); 69 $sql = 'SELECT pattern FROM schema_assignments_patterns WHERE tbl = ?'; 70 $patterns = $this->sqlite->queryAll($sql, $schemaName);
|
/plugin/acknowledge/ |
H A D | helper.php | 77 $sql = "INSERT OR IGNORE INTO pages (page, lastmod) VALUES (?,?)"; 85 $this->db->exec($sql, [$page, $lastmod]); 170 $sql = "DELETE FROM pages WHERE page = ?"; 171 $this->db->exec($sql, $page); 190 $sql = "REPLACE INTO pages (page, lastmod) VALUES (?,?)"; 191 $this->db->exec($sql, [$page, $lastmod]); 204 $sql = "UPDATE assignments SET pageassignees = '' WHERE page = ?"; 205 $this->db->exec($sql, $page); 219 $sql = "REPLACE INTO assignments ('page', 'pageassignees') VALUES (?,?)"; 220 $this->db->exec($sql, [ [all...] |
/plugin/dokuprism/prism/ |
H A D | prism.css | 2 https://prismjs.com/download.html#themes=prism&languages=markup+css+clike+javascript+abap+abnf+actionscript+ada+antlr4+apacheconf+apl+applescript+aql+arduino+arff+asciidoc+aspnet+asm6502+autohotkey+autoit+bash+basic+batch+bbcode+bison+bnf+brainfuck+brightscript+bro+c+csharp+cpp+cil+clojure+cmake+coffeescript+csp+crystal+css-extras+d+dart+diff+django+dns-zone-file+docker+ebnf+eiffel+ejs+elixir+elm+etlua+erb+erlang+fsharp+fortran+gml+gedcom+go+graphql+groovy+haml+handlebars+haskell+haxe+hcl+http+hpkp+hsts+ichigojam+icon+inform7+ini+io+j+java+javadoc+javadoclike+javastacktrace+jolie+jq+jsdoc+js-extras+json+json5+jsonp+js-templates+julia+keyman+kotlin+latex+latte+less+lilypond+liquid+lisp+livescript+lolcode+lua+makefile+markdown+markup-templating+matlab+mel+mizar+monkey+moonscript+n1ql+n4js+nand2tetris-hdl+nasm+neon+nginx+nim+nix+objectivec+pascal+perl+php+phpdoc+php-extras+plsql+powershell+processing+prolog+properties+protobuf+pug+puppet+pure+python+q+qml+qore+r+jsx+tsx+reason+regex+renpy+rest+rip+roboconf+robotframework+ruby+rust+sas+sass+scss+scala+scheme+shell-session+smalltalk+smarty+solidity+soy+sparql+splunk-spl+sqf+sql+stylus+swift+t4-templating+t4-cs+t4-vb+tap+tcl+tt2+textile+toml+turtle+twig+typescript+vala+vbnet+velocity+verilog+vhdl+vim+visual-basic+wasm+wiki+xeora+xojo+xquery+yaml+zig&plugins=show-language+remove-initial-line-feed+previewers+toolbar+copy-to-clipboard+download-button */
|
/plugin/sqlite/ |
H A D | QuerySaver.php | 37 $sql = 'INSERT INTO queries (db, name, sql) VALUES (?, ?, ?)'; 38 $this->db->exec($sql, [$this->upstream, $name, $query]); 51 $sql = 'SELECT sql FROM queries WHERE db = ? AND name = ?'; 52 return $this->db->queryValue($sql, [$this->upstream, $name]); 69 $sql = 'DELETE FROM queries WHERE db = ? AND name = ?'; 70 $this->db->exec($sql, [$this->upstream, $name]); 82 $sql = 'SELECT name, sql FRO [all...] |