[GitHub] [cayenne] Ivan-nikitko opened a new pull request, #593: Case when statement implementation

[via GitHub]

Ivan-nikitko opened a new pull request, #593:
URL: https://github.com/apache/cayenne/pull/593

   **SQLBulder API example**
   ```
   
      SelectBuilder builder = new SelectBuilder(column("OrderID"), 
column("Quantity"),
                   caseWhen()
                           
.when(column("Quantity").gt(value(30)).and(column("Quantity").lt(value(100))))
                           .then(value("The quantity from 30 to 100"))
                           .when(column("Quantity").eq(value(30)))
                           .then(value("The quantity is 30"))
                           .elseResult(value("The quantity is under 30"))
                           .as("QuantityText"))
                   .from(table("OrderDetails"));
   ```
                   
                   
   **Expression API example**
   
   ```
   Expression caseWhenNoDefault = caseWhen(
                   List.of((betweenExp("estimatedPrice", 0, 9)),
                           (betweenExp("estimatedPrice", 10, 20))),
                   List.of((wrapScalarValue("firstThenResult")),
                           (wrapScalarValue("secondThenResult")))),
                   wrapScalarValue("defaultResult"));
   ```
                   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscr...@cayenne.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org