Changeset 1753 for trunk/grails-app/controllers/HomeController.groovy

Timestamp:

Apr 12, 2011, 12:04:06 PM (11 years ago)

Author:

work@…

Message:

homecontroller breaks if database is empty

File:

• trunk/grails-app/controllers/HomeController.groovy (modified) (1 diff)

trunk/grails-app/controllers/HomeController.groovy

@@ -53 +53 @@
                 def startDate, endDate, date, userTotal, studyTotal, templateTotal
                 def dailyStatistics = [:]
-                if (db == "org.postgresql.Driver") {
+                if (db == "org.postgresql.Driver" && studyCount) {
                         //sql.eachRow("SELECT b.*,(select cast( now() - '120 day'::interval * random() as date) FROM Template c WHERE c.id=b.id) as newDate FROM Template b WHERE b.id IN (SELECT id FROM Template a)") {sql.execute(sprintf("UPDATE Template SET date_created='%s' WHERE id=%s", it.newDate, it.id))}
                         def studiesPerDay       = sql.rows("SELECT DISTINCT date_trunc('day', a.date_created) as day, (SELECT count(b.*) FROM study b WHERE date_trunc('day', b.date_created) = date_trunc('day', a.date_created)) as count FROM study a ORDER BY day ASC")