@@ -0,0 +1,1081 @@
+package org.ensembl.healthcheck.testcase.eg_core;%0A%0Aimport java.sql.Connection;%0A%0Aimport org.ensembl.healthcheck.DatabaseRegistryEntry;%0Aimport org.ensembl.healthcheck.DatabaseType;%0Aimport org.ensembl.healthcheck.ReportManager;%0Aimport org.ensembl.healthcheck.testcase.SingleDatabaseTestCase;%0Aimport org.ensembl.healthcheck.util.DBUtils;%0A%0Apublic class SimpleFeatureEnds extends SingleDatabaseTestCase %7B%0A%0A%09private static int THRESHOLD = 0;%0A%0A%09public SimpleFeatureEnds() %7B%0A%09%09setDescription(%22Check that simple feature co-ordinates make sense%22);%0A%09%7D%0A%0A%09public boolean run(DatabaseRegistryEntry dbre) %7B%0A%0A%09%09boolean result = true;%0A%0A%09%09Connection con = dbre.getConnection();%0A%0A%09%09logger.fine(%22Checking simple features for %22 + DBUtils.getShortDatabaseName(con) + %22 ...%22);%0A%09%09int rows = DBUtils.getRowCount(con, %22SELECT COUNT(*) FROM simple_feature INNER JOIN seq_region USING (seq_region_id) WHERE seq_region_end %3E length%22);%0A%09%09if (rows %3E THRESHOLD) %7B%0A%09%09%09result = false;%0A%09%09%09ReportManager.problem(this, con, rows + %22 simple features have seq_region_end %3E seq_region.length%22);%0A%09%09%7D%0A%0A%09%09return result;%0A%09%7D%0A%7D%0A

Check whether simple_features end beyond the end of their scaffold