Changes for page Rooms

Summary

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

Details

Page properties

Content

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