@@ -0,0 +1,2262 @@
+package org.ensembl.healthcheck.testcase.generic;%0A%0A/*%0A * Copyright (C) 2003 EBI, GRL%0A * %0A * This library is free software; you can redistribute it and/or modify it under the terms of the GNU Lesser General Public License as published by%0A * the Free Software Foundation; either version 2.1 of the License, or (at your option) any later version.%0A * %0A * This library is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or%0A * FITNESS FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public License for more details.%0A * %0A * You should have received a copy of the GNU Lesser General Public License along with this library; if not, write to the Free Software Foundation,%0A * Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA%0A */%0A%0A%0Aimport java.sql.Connection;%0Aimport java.util.HashMap;%0Aimport java.util.Iterator;%0A%0Aimport org.ensembl.healthcheck.DatabaseRegistryEntry;%0Aimport org.ensembl.healthcheck.ReportManager;%0Aimport org.ensembl.healthcheck.testcase.SingleDatabaseTestCase;%0A%0A/**%0A * Check that there are no blank db_display_name fields in external_db.%0A */%0A%0Apublic class ExternalDBDisplayName extends SingleDatabaseTestCase %7B%0A%0A%09/**%0A   * Create a new PredictedXrefs testcase.%0A   */%0A%09public ExternalDBDisplayName() %7B%0A%0A%09%09addToGroup(%22release%22);%0A%09%09addToGroup(%22core_xrefs%22);%0A%09%09setDescription(%22Check that there are no blank db_display_name fields in external_db%22);%0A%0A%09%7D%0A%0A%09/**%0A   * Run the test.%0A   * %0A   * @param dbre The database to use.%0A   * @return true if the test pased.%0A   * %0A   */%0A%09public boolean run(DatabaseRegistryEntry dbre) %7B%0A%0A%09%09boolean result = true;%0A%0A%09%09Connection con = dbre.getConnection();%0A%09%09%0A%09%09int rows = getRowCount(con, %22SELECT COUNT(*) FROM external_db WHERE db_display_name IS NULL OR db_display_name LIKE ' %25'%22);%0A%09%09%0A%09%09if (rows %3E 0) %7B%0A%09%09%09%0A%09%09%09ReportManager.problem(this, con, rows + %22 rows in external_db have null or blank db_display_name - this will mean their label is missing on the web page%22);%0A%09%09%09result = false;%0A%09%09%09%0A%09%09%7D else %7B%0A%09%09%09%0A%09%09%09ReportManager.correct(this, con, %22No blank db_display_name fields in external_db%22);%0A%09%09%09%0A%09%09%7D%0A%0A%09%09return result;%0A%0A%09%7D // run%0A%0A%09// ----------------------------------------------------------------------%0A%0A%7D // ExternalDBDisplayName%0A

Check that there are no blank or null db_display_name fields in external_db - would cause problems for web display.