Wiki source code of Rooms
Version 35.1 by Abdullah Sharifi on 2024/03/12 16:03
Hide last authors
| author | version | line-number | content |
|---|---|---|---|
 |
1.1 | 1 | {{groovy}} |
| 2 | import groovy.sql.Sql | ||
| |
2.1 | 3 | def sql = new Sql(services.igfaebbdddummyas.getConnection()) |
| |
27.1 | 4 | |
 |
35.1 | 5 | sql.eachRow('SELECT JSON_ARRAYAGG(room_data) AS all_dat FROM (SELECT JSON_OBJECT('id', room_id, 'title', room_title, 'color', room_color, 'item', JSON_ARRAYAGG(JSON_OBJECT('title', person))) AS room_data FROM json GROUP BY room_id, room_title, room_color) AS room_data;'){println "${it.room_title}"} |
| |
27.1 | 6 | |
| |
1.1 | 7 | sql.close() |
| 8 | {{/groovy}} |