Output DTO enhancement solution

[babyfish-ct]

OutputDTO was weaker than Fetcher before, which became more obvious after Fetcher supports join fetch in next version.

Preview join fetch of next version by Fetcher(not Output DTO)

• Java Example:
  https://github.com/babyfish-ct/jimmer/blob/dev/project/jimmer-sql/src/test/java/org/babyfish/jimmer/sql/fetcher/JoinFetchTest.java

• Kotlin Example:
  https://github.com/babyfish-ct/jimmer/blob/dev/project/jimmer-sql-kotlin/src/test/kotlin/org/babyfish/jimmer/sql/kt/query/JoinFetchTest.kt

Now we need to enhance the DTO language. This is my design, @ means annotation, @@ means built-in configuration

• Example 1

  BookView {
  
      #allScalars
  
      @@fetchBy(JOIN_ALWAYS)
      store {
          #allScalars
      }
      
      @@limit(5)
      @@orderBy(firstName desc, lastName desc)
      @@batch(10)
      authors {
          #allScalars
      }
  }
  

• Example 2

  ModuleView {
  
     #allScalars
  
     @@where(parent is null)
     treeNodes {
         
         #allScalars
         
         childNodes*
     }
  }
  

[babyfish-ct]

Solution 2

() is used, such as id(store), so [] is used

• Example 1

  BookView {
  
      #allScalars
  
      store[
          fetchType(JOIN_ALWAYS)
      ] {
          #allScalars
      }
      
      authors[
          limit(5)
          orderBy(firstName desc, lastName desc)
          batch(10)
      ] {
          #allScalars
      }
  }
  

• Example 2

  ModuleView {
  
     #allScalars
  
     treeNodes[
         where(parent is null)
     ] {
         
         #allScalars
         
         childNodes*
     }
  }
  

[babyfish-ct]

Solution 3

• Example 1

  BookView {
  
      #allScalars
  
      store {
          #config {
              fetchType(JOIN_ALWAYS)
          }
          
          #allScalars
      }
      
      authors {
          #config {
              limit(5)
              orderBy(firstName desc, lastName desc)
              batch(10)
          }
          #allScalars
      }
  }
  

• Example 2

  ModuleView {
  
     #allScalars
  
     treeNodes{
     
         #config {
             where(parent is null)
         }
         
         #allScalars
         
         childNodes*
     }
  }
  

[ArgonarioD]

This can maintain the semantic meaning of the '#' symbol as a built-in macro, reduce the introduction of additional tokens into the dto language, and hold the complexity.

[Enaium]

#{
    limit(5)
    orderBy(firstName desc, lastName desc)
    batch(10)
    ...
}

or

#limit(5)
#orderBy(firstName desc, lastName desc)
#batch(10)
#...

[babyfish-ct]

Solution 4

• Example 1

  BookView {
  
      #allScalars
  
      store {
          #allScalars
      } by {
         fetchType(JOIN_ALWAYS) 
      }
      
      authors {
          #allScalars
      } by {
          limit(5)
          orderBy(firstName desc, lastName desc)
          batch(10)
      }
  }
  

• Example 2

  ModuleView {
  
     #allScalars
  
     treeNodes{
         
         #allScalars
         
         childNodes*
     } by  {
         where(parent is null)
     }
  }
  

[jhlzlove]

The expressions 3 and 4 are personally preferred, and there is also this one, which I have little experience with and I don't know how difficult it would be to realize. Because I want to keep the notation as simple as possible.

BookView {

    #allScalars

    store {
        #allScalars
    }.fetchType(JOIN_ALWAYS)
    
    authors {
        #allScalars
    }
    .limit(5)
    .orderBy(firstName desc, lastName desc)
    .batch(10)
}

But it looks a lot like Fetcher. 😂

[babyfish-ct]

Solution 5

C# style annotation after annotations, merged to one

• Example 1

  BookView {
  
      #allScalars
  
      [fetchType(JOIN_ALWAYS) ]
      store {
          #allScalars
      }
      
      [
          limit(5)
          orderBy(firstName desc, lastName desc)
          batch(10)
      ]
      authors {
          #allScalars
      }
  }
  

• Example 2

  ModuleView {
  
     #allScalars
  
     [where(parent is null)]
     treeNodes{
         
         #allScalars
         
         childNodes*
     }
  }
  

[babyfish-ct]

Solution 6

C# style annotation one by one, can be mixed with annotations

• Example 1

  BookView {
  
      #allScalars
  
      [fetchType(JOIN_ALWAYS) ]
      store {
          #allScalars
      }
      
      [limit(5)]
      [orderBy(firstName desc, lastName desc)]
      [batch(10)]
      authors {
          #allScalars
      }
  }
  

• Example 2

  ModuleView {
  
     #allScalars
  
     [where(parent is null)]
     treeNodes{
         
         #allScalars
         
         childNodes*
     }
  }
  

[babyfish-ct]

Solution 7

BookView {

    #allScalars

    store { 
        fetchBy(JOIN_ALWAYS) 
    } select {
        #allScalars
    }

    authors {
       limit(5)
       orderBy(firstName desc, lastName desc)
       batch(10)
    } select {
        #allScalars
    }
}

[babyfish-ct]

Solution 8

BookView {

#allScalars

store with fetchBy(JOIN_ALWAYS) {
    #allScalars
}

authors with 
   limit(5),
   orderBy(firstName desc, lastName desc),
   batch(10) {
   #allScalars
}

}

[babyfish-ct]

Solution 9

• Example 1

  BookView {
  
      #allScalars
  
      $fetchBy(JOIN_ALWAYS)
      store {
          #allScalars
      }
      
      $limit(5)
      $orderBy(firstName desc, lastName desc)
      $batch(10)
      authors {
          #allScalars
      }
  }
  

• Example 2

  ModuleView {
  
     #allScalars
  
     $where(parent is null)
     treeNodes {
         
         #allScalars
         
         childNodes*
     }
  }
  

[storympro]

Solution 10

• Example 1

BookView {

    #allScalars

    &fetchBy(JOIN_ALWAYS)
    store {
        #allScalars
    }
    
    &limit(5)
    &orderBy(firstName desc, lastName desc)
    &batch(10)
    authors {
        #allScalars
    }
}

• Example 2

ModuleView {

   #allScalars

   &where(parent is null)
   treeNodes {
       
       #allScalars
       
       childNodes*
   }
}

[babyfish-ct]

Solution 11

Solution2 + comma

BookView {

    #allScalars

    store[
        fetchType(JOIN_ALWAYS)
    ] {
        #allScalars
    }
    
    authors[
        limit(5),
        orderBy(firstName desc, lastName desc),
        batch(10), // last one comma can be omitted
    ] {
        #allScalars
    }
}

[babyfish-ct]

Solution 12

Like 2, but [] can be omitted when there is only one option

BookView {

    #allScalars

    store fetchType(JOIN_ALWAYS) {
        #allScalars
    }
    
    authors[
        limit(5)
        orderBy(firstName desc, lastName desc)
        batch(10)
    ] {
        #allScalars
    }
}

[belovaf]

And can you remove commas in this variant? It was my mistake.

[babyfish-ct]

done