Changes for page Rooms

Summary

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

Details

Page properties

Content

...	...	@@ -1,26 +1,11 @@
1	1	{{groovy}}
2	2	import groovy.sql.Sql
3	3	def sql = new Sql(services.igfaebbdddummyas.getConnection())
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
	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	+}
25	25	sql.close()
26	26	{{/groovy}}