Skip to Content

Team

Summer Fellowships

Changes for page Rooms

Last modified by Ricardo Julio Rodríguez Fernández on 2024/03/13 12:06
From version 6.1
edited by Ricardo Julio Rodríguez Fernández
on 2024/03/11 19:57
Change comment: There is no comment for this version
To version 16.1
edited by Ricardo Julio Rodríguez Fernández
on 2024/03/11 20:18
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -1,26 +1,6 @@
1 1  {{groovy}}
2 2  import groovy.sql.Sql
3 3  def sql = new Sql(services.igfaebbdddummyas.getConnection())
4 -def query = "SELECT
5 - JSON_ARRAYAGG(room_data) AS all_data
6 -FROM (
7 - SELECT
8 - JSON_OBJECT(
9 - 'id', room_id,
10 - 'title', room_title,
11 - 'color', room_color,
12 - 'item', JSON_ARRAYAGG(JSON_OBJECT('title', person))
13 - ) AS room_data
14 - FROM
15 - json
16 - GROUP BY
17 - room_id, room_title, room_color
18 -) AS room_data;"
19 -
20 -println(query.get(0).testid.toString())
21 -
22 -def countitems = appitems.size() println(countitems)
23 -
24 -assert countitems == query.get(0).testid
4 +sql.firstRow('SELECT COUNT(*) AS num FROM json').num == 3
25 25  sql.close()
26 26  {{/groovy}}