Page Comparison

...

Anchor

	TqlQuery grammar
	TqlQuery grammar

Gliffy


name	TqlQuery Grammar

solid

Panel

borderStyle

Paste code macro

language	yaml
title	TqlQuery grammar

Example

<Query var=

Query:
  var: "some"

>

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.

</Documentation>

<Find using=


  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=


    Entity:
      QType: "Business"

as=


      as: "some.Business"

/> <Light operatedBy=


    Light:
      operatedBy: "some.Business.EIN"

not.state=


      not:
        state: "OutOfOrder"

as="MyLight">

<Lattitude between=


      as: "MyLight"
      Brightness:
        gt: "80%"
      Location:
        Lattitude:
          between: "1.234,0.9876"

/>

</Location>

</Light>

<Parking.Meter operatedBy=


    Parking.Meter:
      operatedBy: "some.Business.EIN"

as="MyParkingMeter">

<or>

vacant

</eq>

<and>

</and>

</or>

</Parking.Meter>

<not>

</Distance>

</not>

</Find>

</Query>

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


      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

<Query>

<Find as=

Panel

borderStyle	solid
title	TqlAs grammar

Paste code macro

language	yaml

Query:
  Find:
    as: "X:Y:Z"

format=


    format: "version,current"

>

</Zone>

</ZoneInfo>

</Find>

</Query>

returns

<X>
<Y>
<Z>
<ZoneID>KPDWP77BAAAMBKABAGF37PTP</ZoneID>
<Zone.Attr...
</Z>
<Z>


    Zone:
      as: "var.Zone"
      ZoneID:
        ne: ""
    ZoneInfo:

<ZoneInfo.Attr...

 ZoneName:

</Z>

</Y>
</X>

Referenced by:

TqlAs

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

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

 eq: "var.Zone.Name"

Anchor

	TqlContainer grammar
	TqlContainer grammar

Gliffy


name	TqlContainer Grammar

Example

<Query>

<Find as=

Panel

borderStyle	solid
title	TqlContainer grammar

Paste code macro

language	yaml

Query:
  Find:
    as: "$none:Zone:$none"

format=


    format: "version,current"

> <Zone as=


    Zone:
      as: "var.Zone"

>

</Zone>

</ZoneInfo>

</Find>

</Query>

returns

 <Zone>
   <ZoneID>KPDWP77BAAAMBKABAGF37PTP</ZoneID>
   <Zone.Attr...
   <ZoneInfo.Attr...
 </Zone>
 <Zone>
   ...
 </Zone>

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


      ZoneID:
        ne: ""
    ZoneInfo:
      ZoneName:
        eq: "var.Zone.Name"

Anchor

	TqlFindDeleteAll grammar
	TqlFindDeleteAll grammar

Gliffy


name	TqlFindDeleteAll Grammar

Example

<Query>

<Find as=

Panel

borderStyle	solid
title	TqlFindDeleteAll grammar

Paste code macro

language	yaml

Query:
  Find:
    as: "$none:Zone:$none"

Only=


    Only: "Zone:Name"

format=


    format: "version,current"

> <Zone as=


    Zone:
      as: "var.Zone"

>

</Zone>

</Find>

</Query>

Returns

<Zone>

<Name

Value="CV-F1-Zone-1"

Version="1"/>

</Zone> <Zone>
...

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

 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>

<gateway.agriculture.Zone>

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

<UserName>myName</UserName>

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

<City>Sunnyvale</City>

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

New Version Current

Key