TQL Query Grammar
Example
<Query>
<Find as="$none:Zone:$none" Only="Zone:Name" format="version,current">
<Zone as="var.Zone">
<ZoneID ne=""/>
</Zone>
</Find>
</Query>
Returns
<Zone> <Name Value="CV-F1-Zone-1" Version="1"/> </Zone> <Zone>
...
Referenced by:
TqlOnly
TqlOnly: comma-separated list of attribute names with optional predicates
Has optional "not." or "!" prefix
not.: canonical prefix
!: abbreviated prefix
Attribute reference: can be qualified by a model name or a variable name
"," and optional white space between attribute references
Example
<Query>
<Find as="$none:Zone:$none" format="version,current">
<gateway.agriculture.Zone as="var.X">
<ZoneID ne=""/>
</gateway.agriculture.Zone>
</Find>
</Query>
Referenced by:
TqlFindModel
TqlFindModel: Tql Find query model content
$Model=SubtypeOf(DataModel): this should set the $Model variable to be the name of any subtypes of DataModel (i.e. all Models). This variable value will be carried on to be used by TqlFindAttribute.
TqlFindAttribute: This will use the $Model variable
Example
<Query>
<Find as="$none:Zone:$none" format="version,current">
<Zone as="var.X">
<And>
<ZoneID ne=""/>
<Name ne="CV-F1-Zone-1" />
</And>
</Zone>
</Find>
</Query>
Returns all the records except with Name as CV-F1-Zone-1.
Referenced by:
TqlFindAttribute
TqlFindAttribute: Tql Find query model attribute content
AttributeOf($Model): name of an attribute of the enclosing model.
ConditionExpression: see definition on TQL Model Grammar
Example
<Query>
<Create>
<Zone>
<Name = "Zone-1" />
</Zone>
</Create>
</Query>
Referenced by:
TqlCrud
TqlCrud: CRUD operation content
From: Dot-delimited path to source container
- TqlAs is written as "As": Colon-separated whole result:instance container specifiers
- TqlOnly is written as "Only": List of attributes to store
Example
<Query>
<Create>
<gateway.agriculture.Zone>
<Name = "Zone-1" />
</gateway.agriculture.Zone>
</Create>
</Query>
Referenced by:
TqlCrudModel
TqlCrudModel: Tql CRUD query model content
$Model=SubtypeOf(DataModel): this should set the $Model variable to be the name of any subtypes of DataModel (i.e. all Models). This variable value will be carried on to be used by TqlCrudAttribute.
TqlCrudAttribute: This will use the $Model variable
Example
<Query>
<Create format="version,order,timestamp">
<User UserId="User1">
<UserName>myName</UserName>
<Password>pass</Password>
<isActive>true</isActive>
<Address Label="Work">
<Street>1151 Sonora Ct, Suite 2</Street>
<City>Sunnyvale</City>
<State>CA</State>
<ZipCode>94086</ZipCode>
</Address>
</User>
<User>
...
</Create>
</Query>
Referenced by:
TqlCrudAttribute
TqlCrudAttribute: Tql CRUD query model attribute content
AttributeOf($Model): name of an attribute of the enclosing model; abbreviated form or extended form
Value: actual value
- Version: optional version
- do: optional operation
Example
<Query>
<Update format="version,order,timestamp">
<User UserId="User1">
<UserName>myName</UserName>
<Password>pass</Password>
<isActive>true</isActive>
<Role Do="Create">user</Role>
<Address Label="Work">
<Street>1151 Sonora Ct, Suite 2</Street>
<City>Sunnyvale</City>
<State>CA</State>
<ZipCode>94086</ZipCode>
</Address>
</User>
<User>
...
</Update>
</Query>Referenced by: