Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP
branch: mysql56
Fetching contributors…

Cannot retrieve contributors at this time

883 lines (881 sloc) 43.56 kb
<?xml version="1.0" encoding="iso-8859-1"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<!-- template designed by Marco Von Ballmoos -->
<title></title>
<link rel="stylesheet" href="media/stylesheet.css" />
<meta http-equiv='Content-Type' content='text/html; charset=iso-8859-1'/>
</head>
<body>
<a name="top"></a>
<h2>Full index</h2>
<h3>Package indexes</h3>
<ul>
<li><a href="elementindex_default.html">default</a></li>
</ul>
<br />
<div class="index-letter-menu">
<a class="index-letter" href="elementindex.html#a">a</a>
<a class="index-letter" href="elementindex.html#c">c</a>
<a class="index-letter" href="elementindex.html#d">d</a>
<a class="index-letter" href="elementindex.html#e">e</a>
<a class="index-letter" href="elementindex.html#f">f</a>
<a class="index-letter" href="elementindex.html#g">g</a>
<a class="index-letter" href="elementindex.html#h">h</a>
<a class="index-letter" href="elementindex.html#i">i</a>
<a class="index-letter" href="elementindex.html#j">j</a>
<a class="index-letter" href="elementindex.html#l">l</a>
<a class="index-letter" href="elementindex.html#m">m</a>
<a class="index-letter" href="elementindex.html#n">n</a>
<a class="index-letter" href="elementindex.html#o">o</a>
<a class="index-letter" href="elementindex.html#p">p</a>
<a class="index-letter" href="elementindex.html#q">q</a>
<a class="index-letter" href="elementindex.html#r">r</a>
<a class="index-letter" href="elementindex.html#s">s</a>
<a class="index-letter" href="elementindex.html#t">t</a>
<a class="index-letter" href="elementindex.html#u">u</a>
<a class="index-letter" href="elementindex.html#v">v</a>
<a class="index-letter" href="elementindex.html#w">w</a>
<a class="index-letter" href="elementindex.html#_">_</a>
</div>
<a name="a"></a>
<div class="index-letter-section">
<div style="float: left" class="index-letter-title">a</div>
<div style="float: right"><a href="#top">top</a></div>
<div style="clear: both"></div>
</div>
<dl>
<dt class="field">
Anemometer
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/Anemometer.html">Anemometer</a> in Anemometer.php</div>
<div class="index-item-description">class Anemometer</div>
</dd>
<dt class="field">
<span class="include-title">Anemometer.php</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/_Anemometer.php.html">Anemometer.php</a> in Anemometer.php</div>
</dd>
<dt class="field">
AnemometerModel
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/AnemometerModel.html">AnemometerModel</a> in AnemometerModel.php</div>
<div class="index-item-description">class AnemometerModel</div>
</dd>
<dt class="field">
<span class="include-title">AnemometerModel.php</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/_AnemometerModel.php.html">AnemometerModel.php</a> in AnemometerModel.php</div>
</dd>
<dt class="field">
<span class="method-title">api</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/Anemometer.html#methodapi">Anemometer::api()</a> in Anemometer.php</div>
<div class="index-item-description">main method for getting report results. This method can be called as an ajax callback and return the raw data in json format, or it can display a table or graph directly. All other methods that get report results use this either directly or as an ajax call.</div>
</dd>
</dl>
<a name="c"></a>
<div class="index-letter-section">
<div style="float: left" class="index-letter-title">c</div>
<div style="float: right"><a href="#top">top</a></div>
<div style="clear: both"></div>
</div>
<dl>
<dt class="field">
<span class="method-title">checksum_exists</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/AnemometerModel.html#methodchecksum_exists">AnemometerModel::checksum_exists()</a> in AnemometerModel.php</div>
<div class="index-item-description">Query the database and return true if a given checksum exists</div>
</dd>
<dt class="field">
<span class="method-title">check_mysql_error</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/_Helpers.php.html#functioncheck_mysql_error">check_mysql_error()</a> in Helpers.php</div>
<div class="index-item-description">die with the error message if the given result handle or mysqli object has an error</div>
</dd>
<dt class="field">
<span class="method-title">clear</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/MySQLTableReport.html#methodclear">MySQLTableReport::clear()</a> in MySQLTableReport.php</div>
<div class="index-item-description">Remove blank strings as values in form fields.</div>
</dd>
<dt class="field">
<span class="method-title">connect_to_datasource</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/AnemometerModel.html#methodconnect_to_datasource">AnemometerModel::connect_to_datasource()</a> in AnemometerModel.php</div>
<div class="index-item-description">Try to connect to the datasource, throw an exception on failure</div>
</dd>
</dl>
<a name="d"></a>
<div class="index-letter-section">
<div style="float: left" class="index-letter-title">d</div>
<div style="float: right"><a href="#top">top</a></div>
<div style="clear: both"></div>
</div>
<dl>
<dt class="field">
<span class="method-title">date_range</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/MySQLTableReport.html#methoddate_range">MySQLTableReport::date_range()</a> in MySQLTableReport.php</div>
<div class="index-item-description">look for a range of date values for the given column, and return values to be added to the WHERE clause</div>
</dd>
</dl>
<a name="e"></a>
<div class="index-letter-section">
<div style="float: left" class="index-letter-title">e</div>
<div style="float: right"><a href="#top">top</a></div>
<div style="clear: both"></div>
</div>
<dl>
<dt class="field">
<span class="method-title">execute</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/MySQLTableReport.html#methodexecute">MySQLTableReport::execute()</a> in MySQLTableReport.php</div>
<div class="index-item-description">Execute the generated query on the configured databse and return a result handle</div>
</dd>
<dt class="field">
<span class="method-title">explain</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/QueryExplain.html#methodexplain">QueryExplain::explain()</a> in QueryExplain.php</div>
<div class="index-item-description">If the given query is a SELECT statement, return the explain plan</div>
</dd>
</dl>
<a name="f"></a>
<div class="index-letter-section">
<div style="float: left" class="index-letter-title">f</div>
<div style="float: right"><a href="#top">top</a></div>
<div style="clear: both"></div>
</div>
<dl>
<dt class="field">
<span class="method-title">from</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/MySQLTableReport.html#methodfrom">MySQLTableReport::from()</a> in MySQLTableReport.php</div>
<div class="index-item-description">define the primary table to select from</div>
</dd>
</dl>
<a name="g"></a>
<div class="index-letter-section">
<div style="float: left" class="index-letter-title">g</div>
<div style="float: right"><a href="#top">top</a></div>
<div style="clear: both"></div>
</div>
<dl>
<dt class="field">
<span class="method-title">ge</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/MySQLTableReport.html#methodge">MySQLTableReport::ge()</a> in MySQLTableReport.php</div>
<div class="index-item-description">apply a &quot;greater than or equal to&quot; operator to a WHERE condition, instead of the default equality matching</div>
</dd>
<dt class="field">
<span class="method-title">get_column_names</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/MySQLTableReport.html#methodget_column_names">MySQLTableReport::get_column_names()</a> in MySQLTableReport.php</div>
<div class="index-item-description">retuns a list of all column names. These will be exactly the same as the columns returned by the query.</div>
</dd>
<dt class="field">
<span class="method-title">get_create</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/QueryExplain.html#methodget_create">QueryExplain::get_create()</a> in QueryExplain.php</div>
<div class="index-item-description">Extract the table names from a query, and return the result of SHOW CREATE TABLE tablename;</div>
</dd>
<dt class="field">
<span class="method-title">get_create_table</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/AnemometerModel.html#methodget_create_table">AnemometerModel::get_create_table()</a> in AnemometerModel.php</div>
<div class="index-item-description">Get the create table definitions for the query</div>
</dd>
<dt class="field">
<span class="method-title">get_custom_fields</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/MySQLTableReport.html#methodget_custom_fields">MySQLTableReport::get_custom_fields()</a> in MySQLTableReport.php</div>
<div class="index-item-description">returns a list of custom fields names.</div>
</dd>
<dt class="field">
<span class="method-title">get_data_source</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/AnemometerModel.html#methodget_data_source">AnemometerModel::get_data_source()</a> in AnemometerModel.php</div>
<div class="index-item-description">Given a data source name, get the properties for it.</div>
</dd>
<dt class="field">
<span class="method-title">get_data_source_names</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/AnemometerModel.html#methodget_data_source_names">AnemometerModel::get_data_source_names()</a> in AnemometerModel.php</div>
<div class="index-item-description">Get the list of names for the configured data sources</div>
</dd>
<dt class="field">
<span class="method-title">get_default_report_action</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/AnemometerModel.html#methodget_default_report_action">AnemometerModel::get_default_report_action()</a> in AnemometerModel.php</div>
<div class="index-item-description">return the default report action name; usually either report or graph_search</div>
</dd>
<dt class="field">
<span class="method-title">get_distinct_values</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/MySQLTableReport.html#methodget_distinct_values">MySQLTableReport::get_distinct_values()</a> in MySQLTableReport.php</div>
<div class="index-item-description">given a table and column, find all the unique values. This is a utility method often used when building dropdown lists on a search form, or getting values for pivot operations.</div>
</dd>
<dt class="field">
<span class="method-title">get_explain_for_sample</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/AnemometerModel.html#methodget_explain_for_sample">AnemometerModel::get_explain_for_sample()</a> in AnemometerModel.php</div>
<div class="index-item-description">try to get the explain plan for a query</div>
</dd>
<dt class="field">
<span class="method-title">get_form_fields</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/AnemometerModel.html#methodget_form_fields">AnemometerModel::get_form_fields()</a> in AnemometerModel.php</div>
<div class="index-item-description">get the field names for the given report</div>
</dd>
<dt class="field">
<span class="method-title">get_form_fields</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/MySQLTableReport.html#methodget_form_fields">MySQLTableReport::get_form_fields()</a> in MySQLTableReport.php</div>
<div class="index-item-description">return the list of form fields defined by the configuration parameters used to construct this object. Field names are prefixed by the table *alias*</div>
</dd>
<dt class="field">
<span class="method-title">get_form_field_values</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/MySQLTableReport.html#methodget_form_field_values">MySQLTableReport::get_form_field_values()</a> in MySQLTableReport.php</div>
<div class="index-item-description">return an associate array with form_field_name =&gt; value for all fields.</div>
</dd>
<dt class="field">
<span class="method-title">get_pivot_values</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/MySQLTableReport.html#methodget_pivot_values">MySQLTableReport::get_pivot_values()</a> in MySQLTableReport.php</div>
<div class="index-item-description">return the list of values for a given pivot column</div>
</dd>
<dt class="field">
<span class="method-title">get_query_advisor</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/AnemometerModel.html#methodget_query_advisor">AnemometerModel::get_query_advisor()</a> in AnemometerModel.php</div>
<div class="index-item-description">invoke pt-query-advisor and get its output</div>
</dd>
<dt class="field">
<span class="method-title">get_query_by_checksum</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/AnemometerModel.html#methodget_query_by_checksum">AnemometerModel::get_query_by_checksum()</a> in AnemometerModel.php</div>
<div class="index-item-description">given a checksum, return the full database row from the fact table for it.</div>
</dd>
<dt class="field">
<span class="method-title">get_query_samples</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/AnemometerModel.html#methodget_query_samples">AnemometerModel::get_query_samples()</a> in AnemometerModel.php</div>
<div class="index-item-description">Retrieve query samples from the history table, ordered from most recent</div>
</dd>
<dt class="field">
<span class="method-title">get_report</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/AnemometerModel.html#methodget_report">AnemometerModel::get_report()</a> in AnemometerModel.php</div>
<div class="index-item-description">get the full config information for the given report.</div>
</dd>
<dt class="field">
<span class="method-title">get_report_defaults</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/AnemometerModel.html#methodget_report_defaults">AnemometerModel::get_report_defaults()</a> in AnemometerModel.php</div>
<div class="index-item-description">get the default search values for the specified report type</div>
</dd>
<dt class="field">
<span class="method-title">get_reviewers</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/AnemometerModel.html#methodget_reviewers">AnemometerModel::get_reviewers()</a> in AnemometerModel.php</div>
<div class="index-item-description">Return a list of reviewers defined by the config file</div>
</dd>
<dt class="field">
<span class="method-title">get_review_types</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/AnemometerModel.html#methodget_review_types">AnemometerModel::get_review_types()</a> in AnemometerModel.php</div>
<div class="index-item-description">return the list of review types. This is a configurable list of short text statuses that can describe the query.</div>
</dd>
<dt class="field">
<span class="method-title">get_search_uri</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/MySQLTableReport.html#methodget_search_uri">MySQLTableReport::get_search_uri()</a> in MySQLTableReport.php</div>
<div class="index-item-description">return a urlencoded string of parameters that were used in this report.</div>
</dd>
<dt class="field">
<span class="method-title">get_tables</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/MySQLTableReport.html#methodget_tables">MySQLTableReport::get_tables()</a> in MySQLTableReport.php</div>
<div class="index-item-description">returns the list of table names, not the aliases</div>
</dd>
<dt class="field">
<span class="method-title">get_tables_from_query</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/QueryExplain.html#methodget_tables_from_query">QueryExplain::get_tables_from_query()</a> in QueryExplain.php</div>
<div class="index-item-description">Try to parse the real table names out of a sql query</div>
</dd>
<dt class="field">
<span class="method-title">get_table_by_alias</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/MySQLTableReport.html#methodget_table_by_alias">MySQLTableReport::get_table_by_alias()</a> in MySQLTableReport.php</div>
<div class="index-item-description">gets the concrete name of a table for the given alias</div>
</dd>
<dt class="field">
<span class="method-title">get_table_fields</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/MySQLTableReport.html#methodget_table_fields">MySQLTableReport::get_table_fields()</a> in MySQLTableReport.php</div>
<div class="index-item-description">select the field names for the report tables from the database.</div>
</dd>
<dt class="field">
<span class="method-title">get_table_status</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/AnemometerModel.html#methodget_table_status">AnemometerModel::get_table_status()</a> in AnemometerModel.php</div>
<div class="index-item-description">Get the table status info for the given query</div>
</dd>
<dt class="field">
<span class="method-title">get_table_status</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/QueryExplain.html#methodget_table_status">QueryExplain::get_table_status()</a> in QueryExplain.php</div>
<div class="index-item-description">Extract the table names and the return the result of SHOW TABLE STATUS LIKE 'tablename' for each table;</div>
</dd>
<dt class="field">
<span class="method-title">get_var</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/_Helpers.php.html#functionget_var">get_var()</a> in Helpers.php</div>
<div class="index-item-description">search global request variables $_POST and $_GET in that order and return the first defined value for the given key</div>
</dd>
<dt class="field">
<span class="method-title">get_visual_explain</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/AnemometerModel.html#methodget_visual_explain">AnemometerModel::get_visual_explain()</a> in AnemometerModel.php</div>
<div class="index-item-description">invoke pt-visual-explain and get its output</div>
</dd>
<dt class="field">
<span class="method-title">graph_search</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/Anemometer.html#methodgraph_search">Anemometer::graph_search()</a> in Anemometer.php</div>
<div class="index-item-description">Search by using a graph. A brief search form is shown to allow a graph to be built. Html table results that corespond to the time range of the graph is displayed below. Regions can be selected in the graph directly which will update the table results with the new time range.</div>
</dd>
<dt class="field">
<span class="method-title">group</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/MySQLTableReport.html#methodgroup">MySQLTableReport::group()</a> in MySQLTableReport.php</div>
<div class="index-item-description">set the GROUP BY expression</div>
</dd>
<dt class="field">
<span class="method-title">gt</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/MySQLTableReport.html#methodgt">MySQLTableReport::gt()</a> in MySQLTableReport.php</div>
<div class="index-item-description">greater than: see documentation for ge()</div>
</dd>
</dl>
<a name="h"></a>
<div class="index-letter-section">
<div style="float: left" class="index-letter-title">h</div>
<div style="float: right"><a href="#top">top</a></div>
<div style="clear: both"></div>
</div>
<dl>
<dt class="field">
<span class="method-title">having</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/MySQLTableReport.html#methodhaving">MySQLTableReport::having()</a> in MySQLTableReport.php</div>
<div class="index-item-description">set the HAVING clause</div>
</dd>
<dt class="field">
<span class="include-title">Helpers.php</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/_Helpers.php.html">Helpers.php</a> in Helpers.php</div>
</dd>
</dl>
<a name="i"></a>
<div class="index-letter-section">
<div style="float: left" class="index-letter-title">i</div>
<div style="float: right"><a href="#top">top</a></div>
<div style="clear: both"></div>
</div>
<dl>
<dt class="field">
<span class="method-title">index</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/Anemometer.html#methodindex">Anemometer::index()</a> in Anemometer.php</div>
<div class="index-item-description">show the index page where users can select the datasource. If there's only</div>
</dd>
<dt class="field">
<span class="method-title">init_query_explainer</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/AnemometerModel.html#methodinit_query_explainer">AnemometerModel::init_query_explainer()</a> in AnemometerModel.php</div>
<div class="index-item-description">Create a new query explainer object for the given query sample</div>
</dd>
</dl>
<a name="j"></a>
<div class="index-letter-section">
<div style="float: left" class="index-letter-title">j</div>
<div style="float: right"><a href="#top">top</a></div>
<div style="clear: both"></div>
</div>
<dl>
<dt class="field">
<span class="method-title">join</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/MySQLTableReport.html#methodjoin">MySQLTableReport::join()</a> in MySQLTableReport.php</div>
<div class="index-item-description">add a table to the JOIN clause</div>
</dd>
</dl>
<a name="l"></a>
<div class="index-letter-section">
<div style="float: left" class="index-letter-title">l</div>
<div style="float: right"><a href="#top">top</a></div>
<div style="clear: both"></div>
</div>
<dl>
<dt class="field">
<span class="var-title">$len</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/QueryTableParser.html#var$len">QueryTableParser::$len</a> in QueryTableParser.php</div>
</dd>
<dt class="field">
<span class="method-title">le</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/MySQLTableReport.html#methodle">MySQLTableReport::le()</a> in MySQLTableReport.php</div>
<div class="index-item-description">less than or equal to: see documentation for ge()</div>
</dd>
<dt class="field">
<span class="method-title">like</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/MySQLTableReport.html#methodlike">MySQLTableReport::like()</a> in MySQLTableReport.php</div>
<div class="index-item-description">like: see documentation for ge()</div>
</dd>
<dt class="field">
<span class="method-title">limit</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/MySQLTableReport.html#methodlimit">MySQLTableReport::limit()</a> in MySQLTableReport.php</div>
<div class="index-item-description">set the LIMIT clause</div>
</dd>
<dt class="field">
Loader
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/Loader.html">Loader</a> in Loader.php</div>
<div class="index-item-description">class to mimic codigniter's syntax for loading views from the controller</div>
</dd>
<dt class="field">
<span class="include-title">Loader.php</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/_Loader.php.html">Loader.php</a> in Loader.php</div>
</dd>
<dt class="field">
<span class="method-title">lt</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/MySQLTableReport.html#methodlt">MySQLTableReport::lt()</a> in MySQLTableReport.php</div>
<div class="index-item-description">less than: see documentation for ge()</div>
</dd>
</dl>
<a name="m"></a>
<div class="index-letter-section">
<div style="float: left" class="index-letter-title">m</div>
<div style="float: right"><a href="#top">top</a></div>
<div style="clear: both"></div>
</div>
<dl>
<dt class="field">
MySQLTableReport
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/MySQLTableReport.html">MySQLTableReport</a> in MySQLTableReport.php</div>
<div class="index-item-description">class MySQLTableReport Generic reporting class. Given a configuration file, that describes the tables and fields to be searched, and information to connect to a database, take form data and generate an SQL query to run.</div>
</dd>
<dt class="field">
<span class="include-title">MySQLTableReport.php</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/_MySQLTableReport.php.html">MySQLTableReport.php</a> in MySQLTableReport.php</div>
</dd>
</dl>
<a name="n"></a>
<div class="index-letter-section">
<div style="float: left" class="index-letter-title">n</div>
<div style="float: right"><a href="#top">top</a></div>
<div style="clear: both"></div>
</div>
<dl>
<dt class="field">
<span class="method-title">ne</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/MySQLTableReport.html#methodne">MySQLTableReport::ne()</a> in MySQLTableReport.php</div>
<div class="index-item-description">not equals: see documentation for ge()</div>
</dd>
</dl>
<a name="o"></a>
<div class="index-letter-section">
<div style="float: left" class="index-letter-title">o</div>
<div style="float: right"><a href="#top">top</a></div>
<div style="clear: both"></div>
</div>
<dl>
<dt class="field">
<span class="method-title">order</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/MySQLTableReport.html#methodorder">MySQLTableReport::order()</a> in MySQLTableReport.php</div>
<div class="index-item-description">set the ORDER BY clause</div>
</dd>
</dl>
<a name="p"></a>
<div class="index-letter-section">
<div style="float: left" class="index-letter-title">p</div>
<div style="float: right"><a href="#top">top</a></div>
<div style="clear: both"></div>
</div>
<dl>
<dt class="field">
<span class="var-title">$pos</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/QueryTableParser.html#var$pos">QueryTableParser::$pos</a> in QueryTableParser.php</div>
</dd>
<dt class="field">
<span class="method-title">parse</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/QueryTableParser.html#methodparse">QueryTableParser::parse()</a> in QueryTableParser.php</div>
<div class="index-item-description">parse a query and return an array of table names from it.</div>
</dd>
<dt class="field">
<span class="method-title">pivot</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/MySQLTableReport.html#methodpivot">MySQLTableReport::pivot()</a> in MySQLTableReport.php</div>
<div class="index-item-description">preform a pivot on a column. Get the unique list of values</div>
</dd>
<dt class="field">
<span class="method-title">prettyprint</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/_Helpers.php.html#functionprettyprint">prettyprint()</a> in Helpers.php</div>
<div class="index-item-description">wrap html pre tags around the given string, with class=&quot;prettyprint&quot;</div>
</dd>
<dt class="field">
<span class="method-title">process_form_data</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/MySQLTableReport.html#methodprocess_form_data">MySQLTableReport::process_form_data()</a> in MySQLTableReport.php</div>
<div class="index-item-description">Read all form data and process values. This will be called automatically by query() and execute() methods.</div>
</dd>
</dl>
<a name="q"></a>
<div class="index-letter-section">
<div style="float: left" class="index-letter-title">q</div>
<div style="float: right"><a href="#top">top</a></div>
<div style="clear: both"></div>
</div>
<dl>
<dt class="field">
<span class="var-title">$query</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/QueryTableParser.html#var$query">QueryTableParser::$query</a> in QueryTableParser.php</div>
</dd>
<dt class="field">
<span class="method-title">query</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/MySQLTableReport.html#methodquery">MySQLTableReport::query()</a> in MySQLTableReport.php</div>
<div class="index-item-description">generate the SQL query and return it as a string.</div>
</dd>
<dt class="field">
QueryExplain
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/QueryExplain.html">QueryExplain</a> in QueryExplain.php</div>
</dd>
<dt class="field">
<span class="include-title">QueryExplain.php</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/_QueryExplain.php.html">QueryExplain.php</a> in QueryExplain.php</div>
</dd>
<dt class="field">
QueryTableParser
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/QueryTableParser.html">QueryTableParser</a> in QueryTableParser.php</div>
<div class="index-item-description">class QueryTableParser</div>
</dd>
<dt class="field">
<span class="include-title">QueryTableParser.php</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/_QueryTableParser.php.html">QueryTableParser.php</a> in QueryTableParser.php</div>
</dd>
<dt class="field">
<span class="method-title">quicksearch</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/Anemometer.html#methodquicksearch">Anemometer::quicksearch()</a> in Anemometer.php</div>
<div class="index-item-description">Search for a checksum value. Redirect to show_query if it's found</div>
</dd>
</dl>
<a name="r"></a>
<div class="index-letter-section">
<div style="float: left" class="index-letter-title">r</div>
<div style="float: right"><a href="#top">top</a></div>
<div style="clear: both"></div>
</div>
<dl>
<dt class="field">
<span class="method-title">raw_where</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/MySQLTableReport.html#methodraw_where">MySQLTableReport::raw_where()</a> in MySQLTableReport.php</div>
<div class="index-item-description">raw_where is an unprocessed string that is added to the WHERE clause</div>
</dd>
<dt class="field">
<span class="method-title">report</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/Anemometer.html#methodreport">Anemometer::report()</a> in Anemometer.php</div>
<div class="index-item-description">Display the search form, and the report results (by default as a html table)</div>
</dd>
<dt class="field">
<span class="method-title">result_as_table</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/QueryExplain.html#methodresult_as_table">QueryExplain::result_as_table()</a> in QueryExplain.php</div>
<div class="index-item-description">given a mysqli result handle, format a string to look like the mysql cli</div>
</dd>
</dl>
<a name="s"></a>
<div class="index-letter-section">
<div style="float: left" class="index-letter-title">s</div>
<div style="float: right"><a href="#top">top</a></div>
<div style="clear: both"></div>
</div>
<dl>
<dt class="field">
<span class="method-title">samples</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/Anemometer.html#methodsamples">Anemometer::samples()</a> in Anemometer.php</div>
<div class="index-item-description">Show query samples for a specific checksum</div>
</dd>
<dt class="field">
<span class="method-title">select</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/MySQLTableReport.html#methodselect">MySQLTableReport::select()</a> in MySQLTableReport.php</div>
<div class="index-item-description">add a column to the select field list</div>
</dd>
<dt class="field">
<span class="method-title">set_data_source</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/AnemometerModel.html#methodset_data_source">AnemometerModel::set_data_source()</a> in AnemometerModel.php</div>
<div class="index-item-description">sets the currently active datasource.</div>
</dd>
<dt class="field">
<span class="method-title">set_pivot_values</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/MySQLTableReport.html#methodset_pivot_values">MySQLTableReport::set_pivot_values()</a> in MySQLTableReport.php</div>
<div class="index-item-description">pivot operations require some setup -- this defines the list of values to turn into additional columns when we ask the report to pivot a column.</div>
</dd>
<dt class="field">
<span class="method-title">set_tables</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/AnemometerModel.html#methodset_tables">AnemometerModel::set_tables()</a> in AnemometerModel.php</div>
<div class="index-item-description">set the current fact and dimension table. That is the query_review and query_review_history tables. This is used when we select samples or update a query by its checksum.</div>
</dd>
<dt class="field">
<span class="method-title">show_query</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/Anemometer.html#methodshow_query">Anemometer::show_query()</a> in Anemometer.php</div>
<div class="index-item-description">Display a specific query from its checksum value</div>
</dd>
<dt class="field">
<span class="method-title">site_url</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/_Helpers.php.html#functionsite_url">site_url()</a> in Helpers.php</div>
<div class="index-item-description">return the full URL for the base page of the site.</div>
</dd>
</dl>
<a name="t"></a>
<div class="index-letter-section">
<div style="float: left" class="index-letter-title">t</div>
<div style="float: right"><a href="#top">top</a></div>
<div style="clear: both"></div>
</div>
<dl>
<dt class="field">
<span class="var-title">$table_tokens</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/QueryTableParser.html#var$table_tokens">QueryTableParser::$table_tokens</a> in QueryTableParser.php</div>
</dd>
</dl>
<a name="u"></a>
<div class="index-letter-section">
<div style="float: left" class="index-letter-title">u</div>
<div style="float: right"><a href="#top">top</a></div>
<div style="clear: both"></div>
</div>
<dl>
<dt class="field">
<span class="method-title">update_query</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/AnemometerModel.html#methodupdate_query">AnemometerModel::update_query()</a> in AnemometerModel.php</div>
<div class="index-item-description">Preform an update query on the given checksum</div>
</dd>
<dt class="field">
<span class="method-title">upd_query</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/Anemometer.html#methodupd_query">Anemometer::upd_query()</a> in Anemometer.php</div>
<div class="index-item-description">Update the review and comments for a query by its checksum</div>
</dd>
</dl>
<a name="v"></a>
<div class="index-letter-section">
<div style="float: left" class="index-letter-title">v</div>
<div style="float: right"><a href="#top">top</a></div>
<div style="clear: both"></div>
</div>
<dl>
<dt class="field">
<span class="method-title">view</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/Loader.html#methodview">Loader::view()</a> in Loader.php</div>
<div class="index-item-description">Finds and displays the given view, and makes the values in $data available to it.</div>
</dd>
</dl>
<a name="w"></a>
<div class="index-letter-section">
<div style="float: left" class="index-letter-title">w</div>
<div style="float: right"><a href="#top">top</a></div>
<div style="clear: both"></div>
</div>
<dl>
<dt class="field">
<span class="method-title">where</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/MySQLTableReport.html#methodwhere">MySQLTableReport::where()</a> in MySQLTableReport.php</div>
<div class="index-item-description">add a condition to the WHERE clause.</div>
</dd>
</dl>
<a name="_"></a>
<div class="index-letter-section">
<div style="float: left" class="index-letter-title">_</div>
<div style="float: right"><a href="#top">top</a></div>
<div style="clear: both"></div>
</div>
<dl>
<dt class="field">
<span class="method-title">__construct</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/QueryExplain.html#method__construct">QueryExplain::__construct()</a> in QueryExplain.php</div>
<div class="index-item-description">Constructor. See class documentation for explaination of the parameters</div>
</dd>
<dt class="field">
<span class="method-title">__construct</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/MySQLTableReport.html#method__construct">MySQLTableReport::__construct()</a> in MySQLTableReport.php</div>
<div class="index-item-description">create a new instance, pass configuration information describing the datasource and the report tables and fields.</div>
</dd>
<dt class="field">
<span class="method-title">__construct</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/AnemometerModel.html#method__construct">AnemometerModel::__construct()</a> in AnemometerModel.php</div>
<div class="index-item-description">Constructor. Initialize the model object</div>
</dd>
<dt class="field">
<span class="method-title">__construct</span>
</dt>
<dd class="index-item-body">
<div class="index-item-details"><a href="default/Anemometer.html#method__construct">Anemometer::__construct()</a> in Anemometer.php</div>
<div class="index-item-description">Constructor. Pass in the global configuration object</div>
</dd>
</dl>
<div class="index-letter-menu">
<a class="index-letter" href="elementindex.html#a">a</a>
<a class="index-letter" href="elementindex.html#c">c</a>
<a class="index-letter" href="elementindex.html#d">d</a>
<a class="index-letter" href="elementindex.html#e">e</a>
<a class="index-letter" href="elementindex.html#f">f</a>
<a class="index-letter" href="elementindex.html#g">g</a>
<a class="index-letter" href="elementindex.html#h">h</a>
<a class="index-letter" href="elementindex.html#i">i</a>
<a class="index-letter" href="elementindex.html#j">j</a>
<a class="index-letter" href="elementindex.html#l">l</a>
<a class="index-letter" href="elementindex.html#m">m</a>
<a class="index-letter" href="elementindex.html#n">n</a>
<a class="index-letter" href="elementindex.html#o">o</a>
<a class="index-letter" href="elementindex.html#p">p</a>
<a class="index-letter" href="elementindex.html#q">q</a>
<a class="index-letter" href="elementindex.html#r">r</a>
<a class="index-letter" href="elementindex.html#s">s</a>
<a class="index-letter" href="elementindex.html#t">t</a>
<a class="index-letter" href="elementindex.html#u">u</a>
<a class="index-letter" href="elementindex.html#v">v</a>
<a class="index-letter" href="elementindex.html#w">w</a>
<a class="index-letter" href="elementindex.html#_">_</a>
</div> </body>
</html>
Jump to Line
Something went wrong with that request. Please try again.