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 8.1
edited by Ricardo Julio Rodríguez Fernández
on 2024/03/11 19:58
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -1,7 +1,8 @@
1 1  {{groovy}}
2 2  import groovy.sql.Sql
3 3  def sql = new Sql(services.igfaebbdddummyas.getConnection())
4 -def query = "SELECT
4 +sql.execute """
5 +SELECT
5 5   JSON_ARRAYAGG(room_data) AS all_data
6 6  FROM (
7 7   SELECT
... ... @@ -15,12 +15,7 @@
15 15   json
16 16   GROUP BY
17 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
19 +) AS room_data;
20 +"""
25 25  sql.close()
26 26  {{/groovy}}