Changes for page Rooms

Summary

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

Details

Page properties

Content

...	...	@@ -1,13 +3,10 @@
1		-
2		-
3	3	{{groovy}}
4	4	import groovy.sql.Sql
5	5	def sql = new Sql(services.igfaebbdddummyas.getConnection())
6	6
7		-sql.eachRow("SELECT JSON_ARRAYAGG(room_data) AS all_data FROM (SELECT JSON_OBJECT('id', room_id, 'title', room_title, 'color', room_color, 'items', JSON_ARRAYAGG(JSON_OBJECT('title', person))) AS room_data FROM json GROUP BY room_id, room_title, room_color) AS aggregated_data") { row ->
8		- println(row.all_data)
9		-}
	5	+ sql.eachRow('SELECT * FROM json'){
	6	+ println "${it.room_title}"
	7	+ }
10	10
11	11	sql.close()
12	12	{{/groovy}}
13		-