/plugin/sqlquery/ |
H A D | README.md | 2 A dokiwiki plugin for processing query to MySQL databases and display results as a table.
|
H A D | plugin.info.txt | 5 name SQL query plugin 6 desc Processing query to mysql database and display results as a table.
|
/plugin/sqlraw/ |
H A D | plugin.info.txt | 6 desc Execute SQL query on remote csv data or table data and display the result as a table
|
H A D | syntax.php | 187 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 D | db.sql | 96 `query` VARCHAR(255)
|
/plugin/statistics/inc/ |
H A D | StatisticsGraph.class.php | 71 * @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 D | StatisticsLogger.class.php | 125 $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 D | README.md | 7 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 D | manual.txt | 3 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 D | query.test.php | 138 $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 D | query_operators.test.php | 17 $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 D | query_operators_numeric.test.php | 17 $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 D | query_operators_numeric_optional.test.php | 17 $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 D | query_sort.test.php | 17 $query = array ( 62 $this->assertQueryResult($query, $expected); 66 $query = array ( 97 $this->assertTrue($this->_triples->queryRelations($query));
|
H A D | query_sort_optional.test.php | 17 $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 D | strataquerytest.inc.php | 6 * Tests query. 67 function assertQueryResult($query, $expectedResult, $message='') { argument 68 $relations = $this->_triples->queryRelations($query);
|
/plugin/strata/driver/ |
H A D | driver.php | 175 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 D | mysql.php | 25 $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 D | pgsql.php | 33 return $this->_db->query("SELECT * FROM pg_tables WHERE schemaname = 'public' AND tablename = 'data'")->rowCount() != 0;
|
H A D | sqlite.php | 20 return $this->_db->query("SELECT count(*) FROM sqlite_master WHERE name = 'data'")->fetchColumn() != 0;
|
/plugin/strata/helper/ |
H A D | triples.php | 131 // 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 D | strata_querytree_visitor.php | 28 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 D | list.php | 12 * List syntax for basic query handling. 38 $query = $this->prepareQuery($data['query']); 40 // execute the query 41 $result = $this->triples->queryRelations($query);
|
H A D | select.php | 12 * 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 D | table.php | 12 * Table syntax for basic query handling. 41 $query = $this->prepareQuery($data['query']); 43 // execute the query 44 $result = $this->triples->queryRelations($query);
|