Differences

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

--- dido:public:s_cli:05_contents:01_prt:06_dddl:aggregates [2021/06/15 13:24]
nick created
+++ dido:public:s_cli:05_contents:01_prt:06_dddl:aggregates [2022/02/03 20:35] (current)
52.45.51.99 ↷ Links adapted because of a move operation
@@ Line 1: / Line 1: @@
-====== Aggregate ======
+====== 5.4 Aggregate ======
+[[dido:public:s_cli:05_contents:01_prt:04_dll:start| Return to DidoDLL]]
+An Aggregate is when a new [[dido:public:ra:xapend:xapend.a_glossary:s:smart_contract|Smart Contract]] is created from a collection of other Smart Contracts and the originally Smart Contracts no longer exist as entities. For example, a can of soup is an aggregate of a can, tomatoes, salt, and other sices. Each of the original objects contained within a Smart Contract are not part of the can of soup.
 <code sql>
-CREATE  AGGREGATE Grades.ReportCard
+CREATE  AGGREGATE CanOfSoup
-      FROM  CourseListing.Post   POSTING
+      FROM  Tomatoes,
-     WHERE  POSTING.StudentId = ‘$1.'
+            Salt,
-     RECORD POSTING.Current.*    AS parents,
+            Spice,
-            "UniDido.ReportCard" AS process;
+            Water,
+            Onion,
+            Butter,
+            Oregano,
+            Broth
+     WHERE  Tomatoes.id = '$1' and
+            Salt.id = '$2' and
+            Spice.id = '$3' and
+            Water.id = '$4' and
+            Onion.id = '$5' and
+            Butter.id = '$6' and
+            Oregano.id = '$7' and
+            Broth.id = '$8'
+     RECORD {"Tomatoes", Tomatoes.id} and
+            {"Salt", Salt.id} and
+            {"Spice", Spice.id} and
+            {"Water", Water.id} and
+            {"Onion", Onion.id} and
+            {"Butter", Butter.id} and
+            {"Oregano", Oregano.id} and
+            {"Broth", Broth.id}
+            AS parents,
+            "Canning Factory Q, Assembly Line 1" AS process;
 </code>
+/**=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
+/* To add a discussion page to this page, comment out the line that says
+  ~~DISCUSSION:off~~
+*/
+~~DISCUSSION:on|Outstanding Issues~~
+~~DISCUSSION:off~~

DIDO Wiki

User Tools

Site Tools

Differences

Page Tools