Re: Apache Cayenne - Merge Data

Hi Keena,

The short answer is - write some Java code to transform the Cayenne result into a data structure appropriate for Thymeleaf display. 

I don't know anything about Thymeleaf, but from quick googling, it might look like this:

<table>
  <tr>
     <th>HOST</th>
     <th th:each="ts: ${timestamps}" th:text="${ts}"/>
  </tr>
  <tr th:each="hostData: ${valuesByHost}">
     <td th:each="ts: ${timestamps}" th:text="${hostData.get(ts)}"/>
  </tr>
</table>


Now you need to build "timestamps" and "valuesByHost" collections:

List<UtilizationData> result = ...
Set<LocalDateTime> timestampsUnsorted = new HashSet<>();
Map<String, Map<LocalDateTime , Integer>> valuesByHost = new HashMap<>();

// iterate over "result", populating "timestampsUnsorted" and "valuesByHost" from the object data
...

List<LocalDateTime> timestamps = new ArrayList<>(timestampsUnsorted);
Collections.sort(timestamps);

HTH,
Andrus

P.S. BTW, can you show your Cayenne query. You are saying that you have ObjectSelect.columnQuery (which normally returns a List<Object> or List<Object[]>), while your result seems to be a List<UtilizationData>, which would be the case if you ran a regular (not column) ObjectSelect query.


> On Aug 15, 2019, at 6:16 AM, Keena Grepo <[email protected]> wrote:
> 
> Hi, 
> 
> I have this data returned by ObjectSelect.columnQuery :
> 
> [{<ObjectId:UtilizationData, id=1>; committed; [hostname=>cc001; percentagePerHour=>100; timestamp=>2019-07-09 00:00:00]}, {<ObjectId:UtilizationData, id=2>; committed; [hostname=>cc001; percentagePerHour=>50; timestamp=>2019-07-09 01:00:00]}, {<ObjectId:UtilizationData, id=3>; committed; [hostname=>cc001; percentagePerHour=>50; ; timestamp=>2019-07-09 02:00:00]}, {<ObjectId:UtilizationData, id=4>; committed; [hostname=>cc001; percentagePerHour=>83; timestamp=>2019-07-09 03:00:00]}, ...]
> 
> And I want to display the data in a table with "HOST", and timestamps as table head. Then for the table data are the value of hostname and the percentagePerHour for each respective timestamp (like the sample table below). How can I achieve this? 
> -------------------------------------------------------------------------------------------------------------------------------
> | HOST  | 2019-07-09 00:00:00 | 2019-07-09 01:00:00 | 2019-07-09 02:00:00 | 2019-07-09 03:00:00 |
> -------------------------------------------------------------------------------------------------------------------------------
> | cc001  | 100                            | 50                               | 50                              | 83                               |
> -------------------------------------------------------------------------------------------------------------------------------
> 
> By the way, I am using Springboot + Thymeleaf.
> 
> Thanks.