Home
last modified time | relevance | path

Searched refs:sql (Results 1 – 25 of 186) sorted by last modified time

12345678

/plugin/dbquery/
H A Dhelper.php88 * @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 DHelperTest.php76 $sql = 'SELECT :user, :mail, :id, :page, :ns WHERE \'foo\' in (:groups)';
77 $sth = $this->hlp->prepareStatement($pdo, $sql, $parameters);
/plugin/structpublish/action/
H A Dmigration.php23 * 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 Ddb.php50 $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 DAccessTableStructpublish.php73 $sql = "SELECT rev FROM $table $where ORDER BY rev DESC LIMIT 1";
74 $ret = $this->sqlite->queryValue($sql, $opts);
H A DAssignments.php60 $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 DAccessTable.php336 $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 DAccessTableGlobal.php27 $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 DAccessTablePage.php58 $sql = "SELECT rev FROM $table $where ORDER BY rev DESC LIMIT 1";
59 $ret = $this->sqlite->queryValue($sql, $opts);
H A DAssignments.php62 $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 DPageMeta.php41 $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 DQueryBuilder.php207 * @return array ($sql, $vals)
229 $sql =
235 $sql .=
240 $sql .=
244 return [$sql, array_values($this->values)];
255 fixPlaceholders($sql) global() argument
H A DQueryBuilderWhere.php120 $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 DSchema.php72 $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 DSchemaBuilder.php157 $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 DSearch.php468 [$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 DSearchCloud.php19 * @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 DLookup.php253 $sql = $QB->getSelectStatement($alias);
254 $QB->addSelectStatement("STRUCT_JSON($tablealias.$colname, $sql)", $alias);
H A DTag.php58 $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 Dmigration.php59 $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 Dmove.php103 $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 Dimexport.php43 $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 Dhelper.php77 $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 Dprism.css2 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 DQuerySaver.php37 $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...]

12345678