Changes for page Rooms

Last modified by Ricardo Julio Rodríguez Fernández on 2024/03/13 12:06

From version 25.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 28.3
edited by Ricardo Julio Rodríguez Fernández
on 2024/03/12 09:39
Change comment: Added comment

Summary

Details

Page properties
Content
... ... @@ -1,11 +1,10 @@
1 1  {{groovy}}
2 2  import groovy.sql.Sql
3 3  def sql = new Sql(services.igfaebbdddummyas.getConnection())
4 -
5 - println sql.rows('SELECT count(*) FROM json')
6 -
4 +
7 7   sql.eachRow('SELECT * FROM json'){
8 8   println "${it.room_title}"
9 9   }
8 +
10 10  sql.close()
11 11  {{/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