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 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
To 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

Summary

Details

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