Wiki source code of Rooms
Version 39.1 by Abdullah Sharifi on 2024/03/12 16:09
Show last authors
| author | version | line-number | content |
|---|---|---|---|
| 1 | |||
| 2 | |||
| 3 | {{groovy}} | ||
| 4 | import groovy.sql.Sql | ||
| 5 | def sql = new Sql(services.igfaebbdddummyas.getConnection()) | ||
| 6 | |||
| 7 | sql.eachRow("SELECT JSON_ARRAYAGG(room_data) AS all_data FROM (SELECT JSON_OBJECT('id', room_id, 'title', room_title, 'color', room_color, 'items', JSON_ARRAYAGG(JSON_OBJECT('title', person))) AS room_data FROM json GROUP BY room_id, room_title, room_color) AS aggregated_data") { row -> | ||
| 8 | println(row.all_data) | ||
| 9 | } | ||
| 10 | |||
| 11 | sql.close() | ||
| 12 | {{/groovy}} |