import com.onresolve.scriptrunner.db.DatabaseUtil
import groovy.xml.MarkupBuilder
def rows = DatabaseUtil.withSql('petstore') { sql -> // <1>
sql.rows('select NAME, SPECIES, ID From petstore')
}
def writer = new StringWriter()
def builder = new MarkupBuilder(writer) // <2>
builder.table('class': 'aui') {
tr {
rows.first().keySet().each { key ->
th {
mkp.yield(key)
}
}
}
rows.each { columns ->
tr {
columns.each { cell ->
td {
mkp.yield(cell.value)
}
}
}
}
}
return writer.toString()