Page Comparison

...

Expand

title	Expand to see legends and methodology

Include Page

	Legends and methodology	Legends and methodologyMethodology
	Methodology

Go to page

Anchor

	TqlQuery grammar
	TqlQuery grammar

Gliffy


name	TqlQuery Grammar

solid

Panel

borderStyle

Paste code macro

language	yaml
title	TqlQuery grammar

Example

Referenced by:

Query

Label: Query label, will be copied into result

From: Dot-delimited path to source container

TqlAs is written as "As": Colon-separated whole result: result set [:instance] container specifiers

FsExpression: any facet script expressions. They can be used both before the "Find/DeleteAll/Save/Create/Update/Delete" tags or after them. In either case, the execution is different

ListQName Using: List of namespace hints

Tag Using: Additional model definitions

Query:
  var: "some"
  Documentation: >
    This query finds all pairs of illuminated street lights next to vacant (or about to become vacant) parking
    meters operated by the same business outside of 1000 feet radius of a Chevron gas station if any.
  Find:
    using: "Sensity,City,Business"
    Entity:
      QType: "Business"
      as: "some.Business"
    Light:
      operatedBy: "some.Business.EIN"
      not:
        state: "OutOfOrder"
      as: "MyLight"
      Brightness:
        gt: "80%"
      Location:
        Lattitude:
          between: "1.234,0.9876"
    Parking.Meter:
      operatedBy: "some.Business.EIN"
      as: "MyParkingMeter"
      or:
        - eq:
            target: "state"
            value: "vacant"
        - and:
            - eq:
                target: "state"
                value: "occupied"
            - le:
                target: "remainingTime"
                value: "PT10M"
    not:
      Business:
        name: "Chevron"
        businessType: "GasStation"
        as: "Chevron"
      Distance:
        from: "Chevron.EID"
        to: "var.MyLight.LID"
        feet:
          le: "1000"

Anchor

	TqlAs grammar
	TqlAs grammar

Gliffy


name	TqlAs Grammar

Example

Referenced by:

TqlAs

TqlAs: This defines a micro-language for a string value

TqlContainer - Instance container - this part is only used in Find.

Panel

borderStyle	solid
title	TqlAs grammar

Paste code macro

language	yaml

Query:
  Find:
    as: "X:Y:Z"
    format: "version,current"
    Zone:
      as: "var.Zone"
      ZoneID:
        ne: ""
    ZoneInfo:
      ZoneName:
        eq: "var.Zone.Name"

Anchor

	TqlContainer grammar
	TqlContainer grammar

Gliffy


name	TqlContainer Grammar

Example

Referenced by:

TqlAs

TqlContainer

TqlContainer: This is a [partial] string value definition.

ValueOf(sid): use SID as a container

ValueOf(name): use [model] name as a container

$none: no container requested

Panel

borderStyle	solid
title	TqlContainer grammar

Paste code macro

language	yaml

Query:
  Find:
    as: "$none:Zone:$none"
    format: "version,current"
    Zone:
      as: "var.Zone"
      ZoneID:
        ne: ""
    ZoneInfo:
      ZoneName:
        eq: "var.Zone.Name"

Anchor

	TqlFindDeleteAll grammar
	TqlFindDeleteAll grammar

Gliffy


name	TqlFindDeleteAll Grammar

Example

Referenced by:

TqlQuery

TqlFindDeleteAll

TqlFindDeleteAll: Find or DeleteAll content

From: Dot-delimited path to source container

TqlAs is written as "As": Colon-separated whole result:result set[:instance] container specifiers

Distinct: Reference to a model

TqlOnly is written as "Only": List of attributes to fetch

Panel

borderStyle	solid
title	TqlFindDeleteAll grammar

Paste code macro

language	yaml

Query:
  Find:
    as: "$none:Zone:$none"
    Only: "Zone:Name"
    format: "version,current"
    Zone:
      as: "var.Zone"
      ZoneID:
        ne: ""

Anchor

	TqlOnly grammar
	TqlOnly grammar

Gliffy


name	TqlOnly Grammar

Panel

borderStyle	solid
title	TqlOnly grammar

Example

<Query>

</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

...

Panel

borderStyle	solid
title	TqlFindModel grammar

Example

<Query>

<gateway.agriculture.Zone as="var.X">

</gateway.agriculture.Zone>

</Find>

</Query>

Referenced by:

TqlFindDeleteAll

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

...

Panel

borderStyle	solid
title	TqlFindAttribute grammar

Example

<Query>

<And>

</And>

</Zone>

</Find>

</Query>

Returns all the records except with Name as CV-F1-Zone-1.

Referenced by:

TqlFindModel

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

...

Panel

borderStyle	solid
title	TqlCrud grammar

Example



<Query>

<Zone>

</Zone>

</Create>

</Query>

Referenced by:

TqlQuery

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

...

Panel

borderStyle	solid
title	TqlCrudModel grammar

Example

<Query>
   <Create>
        <gateway.agriculture.Zone>
               <Name = "Zone-1" />
        </gateway.agriculture.Zone>
    </Create>
</Query>
Referenced by:
TqlCrud
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

...

Panel

borderStyle	solid
title	TqlCrudAttribute grammar

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:
TqlCrudModel
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

...

Panel

borderStyle	solid
title	TqlCrudAttribute grammar

Example

<Query>

<UserName>myName</UserName>

<Street>1151 Sonora Ct, Suite 2</Street>

<City>Sunnyvale</City>

</Address>

</User>

<User>

...

</Update>

</Query>

Referenced by:

TqlCrudAttribute

Versions Compared

Old Version 35

New Version Current

Key