Wiki source code of Rooms
Version 30.1 by Abdullah Sharifi on 2024/03/12 15:50
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 | |
 |
30.1 | 5 | sql.eachRow('SELECT |
| 6 | JSON_ARRAYAGG(room_data) AS all_data | ||
| 7 | FROM ( | ||
| 8 | SELECT | ||
| 9 | JSON_OBJECT( | ||
| 10 | 'id', room_id, | ||
| 11 | 'title', room_title, | ||
| 12 | 'color', room_color, | ||
| 13 | 'item', JSON_ARRAYAGG(JSON_OBJECT('title', person)) | ||
| 14 | ) AS room_data | ||
| 15 | FROM | ||
| 16 | json | ||
| 17 | GROUP BY | ||
| 18 | room_id, room_title, room_color | ||
| 19 | ) AS room_data;'){ | ||
| |
21.1 | 20 | println "${it.room_title}" |
| 21 | } | ||
| |
27.1 | 22 | |
| |
1.1 | 23 | sql.close() |
| 24 | {{/groovy}} |