TQL: Difference between revisions

From Tygron Support wiki
Jump to navigation Jump to search
m (Replaced content with "#REDIRECT Tygron Query Language")
 
(107 intermediate revisions by 5 users not shown)
Line 1: Line 1:
{|style="border-style: solid; border-width: 20px" align="center"
#REDIRECT [[Tygron Query Language]]
|
Please note: This page is currently being updated!
|}
 
{{learned|what the Tygron Query Language (TQL) is|how to create TQL queries|what type of queries you can create|what TQL is currently applied for}}
 
==TQL==
The Tygron Query Language is a special-purpose programming language designed for obtaining spacial area information from a specific game session on the Tygron Engine. The primary reason for its development was to make an easy to use bridge between the Tygron Engine and Microsoft Excel.
 
==Queries==
The operation used in TQL is the query, which is performed with the declarative <code>SELECT</code> statement. <code>SELECT</code> retrieves data from a running Tygron game session. The <code>SELECT</code> statements have no persistent effects on the game session itself.
 
Queries allow the user to describe desired data, leaving the Tygron Engine responsible for planning, optimizing, and performing the physical operations necessary to produce that result as it chooses.
 
A query includes a parameter to include in the final result, immediately following the <code>SELECT</code> keyword. Currently, one of the following result parameters can be chosen:
{| class="wikitable"
|-
! Result Parameter
! Description
! Example
|-
| <code>FLOORSIZE</code>
| Floor size of buildings.
| <code>SELECT_FLOORSIZE_WHERE_CATEGORY_IS_OFFICES</code>
|-
| <code>LOTSIZE</code>
| Lot size of buildings.
| <code>SELECT_LOTSIZE_WHERE_CATEGORY_IS_OFFICES</code>
|-
| <code>UNITS</code>
| Amount of housing units.
| <code>SELECT_UNITS_WHERE_CATEGORY_IS_SOCIAL</code>
|-
| <code>DIKES</code>
| Surface space of constructed dikes or levees.
| <code>SELECT_DIKES_WHERE_ZONE_IS_1</code>
|}
 
===Comparison Predicate and Clauses===
The <code>SELECT</code> and result parameter are followed by the <code>WHERE</code> statement. The <code>WHERE</code> statements includes a comparison predicate, which restricts the information taken into account by the query. The WHERE clause eliminates all information from the result set where the comparison predicate does not evaluate to True.
 
The comparison predicate consists of 0 or more clauses. Clauses consists of three parts;
* Clause Type
* Operator
* Value
 
The clause types and expected values currently supported are:
{| class="wikitable"
|-
! Clause Type
! Description
! Value Type
! Example
|-
| <code>CATEGORY</code>
| Function category type, see [Function]
| <code>CATEGORY_IS_OFFICES</code>
|
|}
 
 
====Operators====
TQL clausses currently support the following Operators:
{| class="wikitable"
|-
! Operator
! Description
! Example
|-
| <code>IS</code>
| Equal to
| <code>CATEGORY_IS_OFFICES</code>
|}

Latest revision as of 09:23, 20 August 2018

Redirect to:

Retrieved from "https://support.tygron.com/w/index.php?title=TQL&oldid=15456"