Skip to Content

Team

Summer Fellowships

Changes for page Rooms

Last modified by Ricardo Julio Rodríguez Fernández on 2024/03/13 12:06
From version 26.1
edited by Ricardo Julio Rodríguez Fernández
on 2024/03/11 20:31
Change comment: There is no comment for this version
To version 30.1
edited by Abdullah Sharifi
on 2024/03/12 15:50
Change comment: There is no comment for this version

Summary

Details

Page properties
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.RicardoJulioRodriguezFernandez
1 +XWiki.AbdullahSharifi
Content
... ... @@ -1,8 +1,24 @@
1 1  {{groovy}}
2 2  import groovy.sql.Sql
3 3  def sql = new Sql(services.igfaebbdddummyas.getConnection())
4 - sql.eachRow('SELECT * FROM json'){
4 +
5 + sql.eachRow('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;'){
5 5   println "${it.room_title}"
6 6   }
22 +
7 7  sql.close()
8 8  {{/groovy}}
XWiki.XWikiComments[0]
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.RicardoJulioRodriguezFernandez
Comment
... ... @@ -1,0 +1,1 @@
1 +https://portal.igfae.usc.es/xwiki/bin/view/Towards%20JSON/Rooms/?outputSyntax=plain&xpage=plain
Date
... ... @@ -1,0 +1,1 @@
1 +2024-03-12 09:39:13.364
XWiki.XWikiComments[1]
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.RicardoJulioRodriguezFernandez
Comment
... ... @@ -1,0 +1,1 @@
1 +https://docs.groovy-lang.org/latest/html/documentation/sql-userguide.html
Date
... ... @@ -1,0 +1,1 @@
1 +2024-03-12 09:39:23.722
XWiki.XWikiComments[2]
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.RicardoJulioRodriguezFernandez
Comment
... ... @@ -1,0 +1,1 @@
1 +https://groovy-lang.org/databases.html#_reading_rows
Date
... ... @@ -1,0 +1,1 @@
1 +2024-03-12 09:39:33.285
XWiki.XWikiComments[3]
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.RicardoJulioRodriguezFernandez
Comment
... ... @@ -1,0 +1,1 @@
1 +https://www.xwiki.org/xwiki/bin/view/Documentation/DevGuide/Architecture/URL%20Architecture/Standard%20URL%20Format/
Date
... ... @@ -1,0 +1,1 @@
1 +2024-03-12 09:40:02.365