TQL

Please note: This page is currently being updated!

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 SELECT statement. SELECT retrieves data from a running Tygron game session. The SELECT 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:

Result Parameter	Description	Example
FLOORSIZE	Floor size of buildings	CATEGORY_IS_OFFICES
LOTSIZE	Ground surface size of buildings	CATEGORY_IS_OFFICES
UNITS	Amount of housing units	CATEGORY_IS_OFFICES
FLOORSIZE	Equal to	SELECT_FLOORSIZE_WHERE_CATEGORY_IS_SOCIAL

SELECT is the most complex statement in SQL, with optional keywords and clauses that include:

Clauses

Operators

TQL clausses currently support the following Operators:

Operator	Description	Example
IS	Equal to	CATEGORY_IS_OFFICES