@@ -0,0 +1,2282 @@
+/*%0A Copyright (C) 2003 EBI, GRL%0A %0A This library is free software; you can redistribute it and/or%0A modify it under the terms of the GNU Lesser General Public%0A License as published by the Free Software Foundation; either%0A 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,%0A but WITHOUT ANY WARRANTY; without even the implied warranty of%0A MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU%0A Lesser General Public License for more details.%0A %0A You should have received a copy of the GNU Lesser General Public%0A License along with this library; if not, write to the Free Software%0A Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA%0A */%0Apackage org.ensembl.healthcheck.testcase.generic;%0A%0Aimport java.sql.Connection;%0A%0Aimport org.ensembl.healthcheck.DatabaseRegistryEntry;%0Aimport org.ensembl.healthcheck.ReportManager;%0Aimport org.ensembl.healthcheck.DatabaseType;%0Aimport org.ensembl.healthcheck.util.DBUtils;%0Aimport org.ensembl.healthcheck.testcase.SingleDatabaseTestCase;%0A%0A/**%0A * Check that the gene_stable_id table is populated in EST databases. %0A */%0A%0Apublic class ESTStableIDs extends SingleDatabaseTestCase %7B%0A%0A%0A    /**%0A     * Create a new ESTStableIDs testcase.%0A     */%0A    public ESTStableIDs() %7B%0A%0A        addToGroup(%22post_genebuild%22);%0A        addToGroup(%22release%22);%0A        setDescription(%22Check the gene_stable_id table is populated in EST databases.%22);%0A%0A    %7D%0A%0A    /**%0A     * This only applies to EST databases.%0A     */%0A    public void types() %7B%0A%0A        removeAppliesToType(DatabaseType.CORE);%0A        removeAppliesToType(DatabaseType.VEGA);%0A%0A    %7D%0A    %0A    /**%0A     * Run the test.%0A     * %0A     * @param dbre%0A     *          The database to use.%0A     * @return true if the test pased.%0A     *  %0A     */%0A    public boolean run(DatabaseRegistryEntry dbre) %7B%0A%09%0A        boolean result = true;%0A        %0A%09Connection con = dbre.getConnection();%0A%09%0A%09int rows = getRowCount(con, %22SELECT COUNT(*) FROM gene_stable_id%22);%0A%0A%09if (rows == 0) %7B%0A%09    ReportManager.problem(this, con, %22gene_stable_id is empty%22);%0A%09    return false;%0A%09%7D else %7B%0A%09    ReportManager.correct(this, con, %22gene_stable_id has %22 + rows + %22 rows%22);%0A%09%7D%0A%0A        return result;%0A%0A    %7D // run%0A%0A%7D // ESTStableIDs%0A

Check that the gene_stable_id table is populated in EST databases (needs to be a separate healthcheck from StableIDs since this is required at a different point in the release process).