Changes for page Rooms

Summary

• Page properties (1 modified, 0 added, 0 removed)

Details

Page properties

Content

...	...	@@ -1,11 +1,22 @@
1	1	{{groovy}}
2	2	import groovy.sql.Sql
3	3	def sql = new Sql(services.igfaebbdddummyas.getConnection())
4		-rowNum = 0
5		-sql.eachRow('SELECT * FROM json') { row ->
6		- def first = row[0]
7		- def last = row.person
8		- assert expected[rowNum++] == "$room_id $room_title"
9		-}
	4	+sql.execute """
	5	+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;
	20	+"""
10	10	sql.close()
11	11	{{/groovy}}