Changes for page Rooms

Summary

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

Details

Page properties

Content

...	...	@@ -1,11 +1,26 @@
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	+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
10	10	sql.close()
11	11	{{/groovy}}