@@ -0,0 +1,2376 @@
+/*%0A Copyright (C) 2004 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 */%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.testcase.SingleDatabaseTestCase;%0A%0A/**%0A * Healthcheck for the dna table.%0A * Should be empty in an est database%0A */%0A%0Apublic class DNAEmpty extends SingleDatabaseTestCase %7B%0A%0A    /**%0A     * Check the assembly_exception table.%0A     */%0A    public DNAEmpty() %7B%0A        addToGroup(%22post_genebuild%22);%0A        addToGroup(%22release%22);%0A        setDescription(%22Check that dna table is empty%22);%0A    %7D%0A%0A    /**%0A     * Check the data in the assembly_exception table. Note referential%0A     * integrity checks are done in CoreForeignKeys.%0A     * %0A     * @param dbre%0A     *          The database to use.%0A     * @return Result.%0A     */%0A    public boolean run(DatabaseRegistryEntry dbre) %7B%0A%0A        boolean result = true;%0A%0A        Connection con = dbre.getConnection();%0A%0A        // check that seq_region_end %3E seq_region_start%0A        int rows = getRowCount(con, %22SELECT COUNT(*) FROM dna%22);%0A        if (rows %3E 0) %7B%0A            result = false;%0A            ReportManager.problem(this, con, %22dna table contains %22 + rows%0A                    + %22 - it should be empty%22);%0A        %7D%0A%0A%0A        if (result) %7B%0A            ReportManager.correct(this, con, %22dna table is empty%22);%0A        %7D%0A%0A        return result;%0A%0A    %7D%0A%0A    /**%0A     * This applies to all core schema databases apart from 'core'%0A     */%0A    public void types() %7B%0A%0A        removeAppliesToType(DatabaseType.CORE);%0A%0A    %7D%0A%0A%0A%7D // DNAEmpty%0A

Test to check dna tables in non core, core schema dbs (eg. est and estgene) are empty (should be using core db as reference).