Changes for page Rooms

Summary

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

Details

Page properties

Content

...	...	@@ -1,8 +1,7 @@
1	1	{{groovy}}
2	2	import groovy.sql.Sql
3		-def sql = new Sql(services.igfaebbdddummy.getConnection())
4		-sql.execute """
5		-SELECT
	3	+def sql = new Sql(services.igfaebbdddummyas.getConnection())
	4	+def query = "SELECT
6	6	JSON_ARRAYAGG(room_data) AS all_data
7	7	FROM (
8	8	SELECT
...	...	@@ -16,7 +16,12 @@
16	16	json
17	17	GROUP BY
18	18	room_id, room_title, room_color
19		-) AS room_data;
20		-"""
	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
21	21	sql.close()
22	22	{{/groovy}}