/*
 * Copyright (C) 2004 EBI, GRL
 * 
 * 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 the Free Software Foundation; either version
 * 2.1 of the License, or (at your option) any later version.
 * 
 * This library is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without
 * even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
 * Lesser General Public License for more details.
 * 
 * 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, Inc., 59 Temple Place, Suite 330, Boston, MA
 * 02111-1307 USA
 */

package org.ensembl.healthcheck.testcase.generic;

import org.ensembl.healthcheck.DatabaseRegistry;
import org.ensembl.healthcheck.DatabaseType;
import org.ensembl.healthcheck.testcase.MultiDatabaseTestCase;

/**
 * Check that the seq_region_attrib table is the same in all necessary databases.
 */
public class SeqRegionAttribAcrossSpecies extends MultiDatabaseTestCase {

    private DatabaseType[] types = {DatabaseType.CORE, DatabaseType.VEGA, DatabaseType.OTHERFEATURES};

    /**
     * Creates a new instance of SeqRegionAttribAcrossSpecies
     */
    public SeqRegionAttribAcrossSpecies() {

        addToGroup("release");
        setDescription("Check that the seq_region_attrib table is the same across all generic DBs");

    }

    /**
     * Make sure that the seq_region tables are all the same.
     * 
     * @param dbr The database registry containing all the specified databases.
     * @return True if the seq_region_attrib table is the same across all the species in the
     *         registry.
     */
    public boolean run(DatabaseRegistry dbr) {

        return checkTableAcrossSpecies("seq_region_attrib", dbr, types, "seq_region_attrib tables all the same", "seq_region_attribs are different", "");

    } // run

} // SeqRegionAttribAcrossSpecies


@@ -1988,16 +1988,45 @@
 rent%22, %22
+WHERE code NOT LIKE 'GeneNo%25'
 %22);%0A%0A   

Exclude GeneNo_* from counts