GroIMP wiki

a part of grogra.de

User Tools

Site Tools

Trace: • maven-commands • create-module-lib
tutorials:xl-queries-and-operators

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
tutorials:xl-queries-and-operators [2024/12/06 01:35] – [Aggregators] ksmolentutorials:xl-queries-and-operators [2025/01/10 11:17] (current) – gaetan
Line 48: Line 48:
 </code> </code>
  
-We create a new method called ''analyse()''. The method will appear as a new button in the RGG toolbar. Inside this method, we first call the ''run()'' method for 3 steps. The result is a simple plant made of 3 internodes and 3 leaves.+We create a new method called ''analyse()''. The method will appear as a new button in the RGG toolbar. Before running the ''analyse()'' method, press the ''Reset'' button in the RGG Toolbar, to reset the graph structure. Inside this method, we first call the ''run()'' method for 3 steps. The result is a simple plant made of 3 internodes and 3 leaves.
  
 {{ :tutorials:testplant_crop.png?100|}} {{ :tutorials:testplant_crop.png?100|}}
Line 60: Line 60:
 } }
 </code> </code>
 +
 +The underlying 2d graph of the generated structure given below:
 +
 +{{ :tutorials:graph_query_example_2.png?620|}}
 +
 +Beginning from //RGGRoot//, we have the sequence of three //Internodes// where to each is a //Leaf// linked by a branching edge. The last internode, additionally, has a Bud node successor.
 +
  
 ==== Query examples ==== ==== Query examples ====
  
 Replace the text (in red) inside the ''println()'' one by one by the queries below. Replace the text (in red) inside the ''println()'' one by one by the queries below.
 +
 +Below each query, there is a result of the print command, for illustration. Note, that the ids will differ with different model execution. 
  
   * Find all the internodes in the structure:   * Find all the internodes in the structure:
Line 72: Line 81:
  
 The query will return ids of all the internodes in the plant structure.  The query will return ids of all the internodes in the plant structure. 
 +
 +<hidden answer>
 +Model.Internode[id=1911]@ecc95fb
 +
 +Model.Internode[id=1906]@7b431a06
 +
 +Model.Internode[id=1901]@5753e950
 +
 +__Note:__
 +
 +Internode with the id=1901 is the first internode from the bottom (with the highest age: 3).
 +
 +Internode with the id=1911 is the top internode (with the lowest age: 1)
 +</hidden>
  
 Notice, that when you click with a mouse on an internode in the 3D View window, information about the selected internode will be displayed in the Attribute Editor. In the Attribute Editor, you can check the internode id (e.g. Model$Internode [Internode.1756]) and compare it with the one that was printed in the XL Console. Another option is to look at the node ids in the 2D Graph (Panels -> 2D -> Graph, in the graph window: View -> Redraw). Notice, that when you click with a mouse on an internode in the 3D View window, information about the selected internode will be displayed in the Attribute Editor. In the Attribute Editor, you can check the internode id (e.g. Model$Internode [Internode.1756]) and compare it with the one that was printed in the XL Console. Another option is to look at the node ids in the 2D Graph (Panels -> 2D -> Graph, in the graph window: View -> Redraw).
Line 80: Line 103:
 (* i:Internode, (i[age] == 1) *) (* i:Internode, (i[age] == 1) *)
 </code> </code>
 +
 +<hidden answer>
 +Model.Internode[id=1911]@ecc95fb
 +</hidden>
  
   * Find the internode below the bud:   * Find the internode below the bud:
Line 90: Line 117:
  
 ''<'' represents a successor edge in the indicated direction ''<'' represents a successor edge in the indicated direction
 +
 +<hidden answer>
 +Model.Internode[id=1911]@ecc95fb
 +</hidden>
  
   * Find all leaves connected to an internode:   * Find all leaves connected to an internode:
Line 98: Line 129:
  
 This is just to illustrate how to define different edge types inside a query. ''+>'' represents a branch edge. This is just to illustrate how to define different edge types inside a query. ''+>'' represents a branch edge.
 +
 +<hidden answer>
 +Model.Leaf[id=1913]@4b0f7bd
 +
 +Model.Leaf[id=1908]@1c6dbfa5
 +
 +Model.Leaf[id=1903]@668c1f97
 +
 +__Note:__
 +Leaf with the id=1903 is the first (and the oldest) leaf, leaf with the id=1913 is the last (and the yongest) leaf.
 +</hidden>
  
 ==== Aggregators ==== ==== Aggregators ====
Line 103: Line 145:
 Aggregate operations are used to collect multiple values when traversing the graph structure and return a single value. Aggregate operations are used to collect multiple values when traversing the graph structure and return a single value.
  
-Standard aggregate operations are: ''count'', ''sum'', ''empty'', ''exist'', ''forall'', ''first'', ''last'', ''max'', ''min'', ''mean'', ''selectRandomly'', ''selectWhereMin'', ''selectWhereMax'', ...+Standard [[:groimp-platform:xl-builtin-methods|aggregate operations]] are: ''count'', ''sum'', ''empty'', ''exist'', ''forall'', ''first'', ''last'', ''max'', ''min'', ''mean'', ''selectRandomly'', ''selectWhereMin'', ''selectWhereMax'', ...
  
   * Count all leaves:    * Count all leaves: 
Line 110: Line 152:
 count((* Leaf *)) count((* Leaf *))
 </code> </code>
 +
 +<hidden answer>
 +3
 +</hidden>
 +
  
   * Sum up the area of all leaves:   * Sum up the area of all leaves:
Line 116: Line 163:
 sum((* Leaf *)[area]) sum((* Leaf *)[area])
 </code> </code>
 +
 +<hidden answer>
 +6.0
 +</hidden>
 +
  
   * Sum up the length of internodes:   * Sum up the length of internodes:
Line 122: Line 174:
 sum((* Internode *)[length]) sum((* Internode *)[length])
 </code> </code>
 +
 +<hidden answer>
 +6.0
 +</hidden>
  
 In this particular example with internodes forming (only) the main stem, the query will return stem length. In this particular example with internodes forming (only) the main stem, the query will return stem length.
Line 130: Line 186:
 selectWhereMax((* l:Leaf *), (l[area])) selectWhereMax((* l:Leaf *), (l[area]))
 </code> </code>
 +
 +<hidden answer>
 +Model.Leaf[id=1903]@668c1f97
 +</hidden>
 +
  
   * Count internodes that are older than 2 (time units):   * Count internodes that are older than 2 (time units):
Line 136: Line 197:
 count((* i:Internode, (i[age] >= 2) *)) count((* i:Internode, (i[age] >= 2) *))
 </code> </code>
 +
 +<hidden answer>
 +2
 +</hidden>
  
tutorials/xl-queries-and-operators.1733445300.txt.gz · Last modified: 2024/12/06 01:35 by ksmolen