Home
last modified time | relevance | path

Searched refs:query (Results 876 – 900 of 964) sorted by path

1...<<313233343536373839

/plugin/sqlquery/
H A DREADME.md2 A dokiwiki plugin for processing query to MySQL databases and display results as a table.
H A Dplugin.info.txt5 name SQL query plugin
6 desc Processing query to mysql database and display results as a table.
/plugin/sqlraw/
H A Dplugin.info.txt6 desc Execute SQL query on remote csv data or table data and display the result as a table
H A Dsyntax.php187 foreach ($data['sql'] as $query) {
188 $result =& $db->getAll($query);
761 $query = 'DROP TEMPORARY TABLE IF EXISTS '.$table;
762 $result =& $database->query ($query);
764 …$renderer->doc .= '<div class="error">DROP TABLE failed for query: '. $query .'the error: '. $resu…
790 $query = 'CREATE TEMPORARY TABLE '.$table . ' (';
794 … $query .= str_replace($badChars,'_',trim($header)).' VARCHAR('.$max_field_lengths[$key].'), ';
796 $query = rtrim($query,', ');
797 $query .= ') DEFAULT CHARACTER SET \'utf8\'';
798 $result =& $database->query ($query);
[all …]
/plugin/statistics/
H A Ddb.sql96 `query` VARCHAR(255)
/plugin/statistics/inc/
H A DStatisticsGraph.class.php71 * @param string $query The function to call on the Query object to get the data
75 protected function sumUpPieChart($query, $key, $max=4){ argument
76 $result = $this->hlp->Query()->$query($this->tlimit, $this->start, 0, false);
H A DStatisticsLogger.class.php125 $query = '';
131 $qpart = $urlparts['query'];
145 $query = $params[$k];
153 if($type != 'search') foreach(array('search', 'query', 'q', 'keywords', 'keyword') as $k) {
155 $query = $params[$k];
167 // clean the query
168 $query = preg_replace('/^(cache|related):[^\+]+/', '', $query); // non-search queries
169 $query = preg_replace('/ +/', ' ', $query); // w
184 log_search($page, $query, $words, $engine) global() argument
[all...]
/plugin/strata/
H A DREADME.md7 Strata is a semi-structured data plugin for [DokuWiki][dw]. Strata allows you to add data to your wiki pages, and later on query that data to create automatic indices or other overviews.
H A Dmanual.txt3 The strata plugin allows you to add data to your pages and to query that data from your pages. This manual is split into two parts:
11 The quick guide will get you up and running with some examples of how to enter and query. More advanced uses are discussed in the reference guide.
61 Queries are written inside ''<table>'' or ''<list>'' tags. You query the data by describing what pattern the data should fit. A simple example that produces a table of all persons and their birthday would be described as follows:
79 **Types**: In a query, you can use [[#types]]. You can use types for fields and values, and you can use them in the opening tag. Types are 'sticky': if you put ''?p Birthday [date]: ?b'' the date type will automatically stick to the ''?b'' variable (you could have achieved the same with ''?p Birthday: ?b [date]'').
216 Querying data is done through the ''<table>'' and ''<list>'' syntax. A table or list block defines what data to query, and how to display it. This part of the reference is about querying the data. The [[#Query Results]] section discusses how to control the display of data (this includes sorting, grouping, and aggregation).
218 The following sections contain short samples, each of these samples is situated inside a table or list block. It is possible to enclose the whole of the query (not including sorting, grouping, or other [[#Query Results]] related blocks) in a ''query'' block as a convenience.
220 The query blocks are [[#optional]], [[#minus]], [[#union]].
247 Types are 'sticky'. This means that the first mentioned type for a certain variable will stick to the variable for the whole query. You can override a specific use, but without an explicit type a variable will be of the type first attached to it.
302 An optional block must contain at least a [[#patterns|pattern]]. Filters and other query block
[all...]
/plugin/strata/_test/
H A Dquery.test.php138 $query = array (
239 $this->assertQueryResult($query, $expected);
243 $query = array (
364 $this->assertQueryResult($query, $expected);
369 $query = array (
397 $this->assertQueryResult($query, $expected);
402 $query = array (
462 $this->assertQueryResult($query, $expected);
467 $query = array (
534 $this->assertQueryResult($query,
[all...]
H A Dquery_operators.test.php17 $query = array (
67 $this->assertQueryResult($query, $expected);
71 $query = array (
124 $this->assertQueryResult($query, $expected);
128 $query = array (
178 $this->assertQueryResult($query, $expected);
182 $query = array (
235 $this->assertQueryResult($query, $expected);
239 $query = array (
289 $this->assertQueryResult($query,
[all...]
H A Dquery_operators_numeric.test.php17 $query = array (
86 $this->assertQueryResult($query, $expected);
90 $query = array (
159 $this->assertQueryResult($query, $expected);
163 $query = array (
222 $this->assertTrue($this->_triples->queryRelations($query));
226 $query = array (
284 $this->assertTrue($this->_triples->queryRelations($query));
H A Dquery_operators_numeric_optional.test.php17 $query = array (
86 $this->assertQueryResult($query, $expected, 'Partial numeric comparison (first numbers, then text) unsupported');
90 $query = array (
159 $this->assertQueryResult($query, $expected, 'Partial numeric comparison (first numbers, then text) unsupported');
163 $query = array (
232 $this->assertQueryResult($query, $expected, 'Natural comparison unsupported');
236 $query = array (
305 $this->assertQueryResult($query, $expected, 'Natural comparison unsupported');
H A Dquery_sort.test.php17 $query = array (
62 $this->assertQueryResult($query, $expected);
66 $query = array (
97 $this->assertTrue($this->_triples->queryRelations($query));
H A Dquery_sort_optional.test.php17 $query = array (
62 $this->assertQueryResult($query, $expected, 'Partial numeric sort (numbers first, text second) unsupported');
66 $query = array (
111 $this->assertQueryResult($query, $expected, 'Full natural sort unsupported');
115 $query = array (
160 $this->assertQueryResult($query, $expected, 'Case insensitive unicode sort unsupported');
H A Dstrataquerytest.inc.php6 * Tests query.
67 function assertQueryResult($query, $expectedResult, $message='') { argument
68 $relations = $this->_triples->queryRelations($query);
/plugin/strata/driver/
H A Ddriver.php175 if(!$this->query($s, $this->util->getLang('driver_setup_failed'))) {
193 return $this->query('DROP TABLE data', $this->util->getLang('driver_remove_failed'));
197 * Prepares a query and reports any problems to Dokuwiki.
199 * @param query string the query to prepare
202 public function prepare($query) { argument
205 $result = $this->_db->prepare($query);
208 msg(sprintf($this->util->getLang('driver_prepare_failed'),hsc($query), hsc($error[2])),-1);
216 * Executes a query and reports any problems to Dokuwiki.
218 * @param query strin
222 query($query, $message = false) global() argument
[all...]
H A Dmysql.php25 $this->query('SET NAMES utf8mb4');
26 $this->query("SET sql_mode = 'PIPES_AS_CONCAT'"); // Ensure that || works as string concatenation
30 return $this->_db->query("SHOW TABLES LIKE 'data'")->rowCount() != 0;
H A Dpgsql.php33 return $this->_db->query("SELECT * FROM pg_tables WHERE schemaname = 'public' AND tablename = 'data'")->rowCount() != 0;
H A Dsqlite.php20 return $this->_db->query("SELECT count(*) FROM sqlite_master WHERE name = 'data'")->fetchColumn() != 0;
/plugin/strata/helper/
H A Dtriples.php131 // prepare query
132 $query = $this->_db->prepare($sql);
133 if($query == false) return;
135 // execute query
136 $res = $query->execute($values);
138 $error = $query->errorInfo();
142 $query->closeCursor();
179 $query = $this->_db->prepare($sql);
180 if($query == false) return;
182 // execute query
268 queryResources($query) global() argument
539 _trans_opt($query) global() argument
548 _trans_and($query) global() argument
557 _trans_filter($query) global() argument
633 _trans_minus($query) global() argument
661 _trans_union($query) global() argument
703 _trans_select($query) global() argument
810 _dispatch($query) global() argument
835 translate($query) global() argument
[all...]
/plugin/strata/lib/
H A Dstrata_querytree_visitor.php28 function visit_opt(&$query) { argument
29 $this->dispatch($query['lhs']);
30 $this->dispatch($query['rhs']);
36 function visit_and(&$query) { argument
37 $this->dispatch($query['lhs']);
38 $this->dispatch($query['rhs']);
44 function visit_filter(&$query) { argument
45 $this->dispatch($query['lhs']);
46 foreach($query['rhs'] as &$filter) {
54 function visit_minus(&$query) { argument
63 visit_union(& $query) global() argument
72 visit_select(& $query) global() argument
76 dispatch(& $query) global() argument
99 visit(& $query) global() argument
[all...]
/plugin/strata/syntax/
H A Dlist.php12 * List syntax for basic query handling.
38 $query = $this->prepareQuery($data['query']);
40 // execute the query
41 $result = $this->triples->queryRelations($query);
H A Dselect.php12 * Select syntax for basic query handling.
89 $tree = $this->helper->constructTree($lines,'query');
120 // parse the query itself
121 list($result['query'], $variables) = $this->helper->constructQuery($tree, $typemap, $projection);
245 * query has been parsed, but before the typemap is applied to determine
251 * @param variables array of variables used in query
260 * the query for use.
262 * @param query array the query tree
263 * @return the query tre argument
[all...]
H A Dtable.php12 * Table syntax for basic query handling.
41 $query = $this->prepareQuery($data['query']);
43 // execute the query
44 $result = $this->triples->queryRelations($query);

1...<<313233343536373839