Whoops.
Yields: Caught: groovy.lang.MissingMethodException: No
signture of method Test$_run_closure2.body() is applicable for argument types
Test$_run_closure2.body() is applicable for argument types:
(Test$_run_closure2_closure4) values:
[Test$_run_closure2_closure@1f6226]
import groovy.sql.*;
import
groovy.xml.*;
release = "3.11";
I'm trying to spit
out a td row for each line of my sql, but it complains about
closures.
sql =
Sql.newInstance("jdbc:mysql://mcaosdev2:3306/mantis_db",
"furashgf",
"melissa", "org.gjt.mm.mysql.Driver");
getWorkloadSql =
<<<EOS
SELECT mut.last_name, mut.first_name, COUNT(*)
AS total_tasks, SUM(IF(mbt.projection IS NULL OR mbt.projection = 10, 1,0)) AS
unsized_tasks,
SUM(mbp.value) AS
workload
FROM mantis_user_table AS mut
LEFT OUTER
JOIN mantis_bug_table AS mbt ON (mbt.handler_id = mut.id)
LEFT
OUTER JOIN mantis_project_version_table AS mpvt ON (mpvt.id =
mbt.version_id)
LEFT OUTER JOIN m_bug_status AS mbs ON
(mbs.status_cd = mbt.status)
LEFT OUTER JOIN m_bug_projection
AS mbp ON (mbp.projection_cd =
mbt.projection)
WHERE mpvt.version = ${release} AND
mbs.is_active_state = "Y" AND mut.role_cd IN ("DEV", "ADM")
GROUP
BY mut.last_name, mut.first_name
ORDER BY mut.last_name,
mut.first_name;
EOS
htmlOut = new MarkupBuilder();
htmlOut.html()
{
head() {
title("Load By Developer for Release
$release");
}
body() {
table()
{
tr() {
th("Team
Member");
th("Total
Tasks");
th("Workload");
}
sql.eachRow(getWorkloadSql)
{
tr()
{
td(it.last_name + ", " +
it.first_name);
td(it.total_tasks);
td(it.workload);
}
}
}
}
}
println(htmlOut);
