Changes for page Rooms

Summary

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

Details

Page properties

Content

...	...	@@ -1,6 +1,22 @@
1	1	{{groovy}}
2	2	import groovy.sql.Sql
3		-def sql = new Sql(services.igfaebbdddummyas.getConnection())
4		-assert sql.firstRow('SELECT COUNT(*) AS num FROM json').num == 3
	3	+def sql = new Sql(services.igfaebbdddummy.getConnection())
	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	+"""
5	5	sql.close()
6	6	{{/groovy}}