|
|
| (116 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 SELECT 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>
| |
| |}
| |
| | |
| | |
| | |
| SELECT is the most complex statement in SQL, with optional keywords and clauses that include:
| |
| | |
| | |
| | |
| | |
| ===Clauses===
| |
| | |
| | |
| | |
| ====Operators====
| |
| TQL clausses currently support the following Operators:
| |
| {| class="wikitable"
| |
| |-
| |
| ! Operator
| |
| ! Description
| |
| ! Example
| |
| |-
| |
| | <code>IS</code>
| |
| | Equal to
| |
| | <code>CATEGORY_IS_OFFICES</code>
| |
| |}
| |