Changeset 3238

Timestamp:

08/05/13 15:07:00 (11 years ago)

Author:

olhsha

Message:

2: methods:
-- returning all the internal id-s of cached representations
-- removing all the cached representations which are not referred from the versions_cached_representations tabel

DAO-tested

Location:

DASISH/t5.6/backend/annotator-backend/trunk/annotator-backend/src

Files:

• main/java/eu/dasish/annotation/backend/dao/CachedRepresentationDao.java (modified) (2 diffs)
• main/java/eu/dasish/annotation/backend/dao/impl/JdbcCachedRepresentationDao.java (modified) (1 diff)
• test/java/eu/dasish/annotation/backend/dao/impl/JdbcCachedRepresentationDaoTest.java (modified) (1 diff)

DASISH/t5.6/backend/annotator-backend/trunk/annotator-backend/src/main/java/eu/dasish/annotation/backend/dao/CachedRepresentationDao.java

@@ -20 +20 @@
 import eu.dasish.annotation.backend.identifiers.CachedRepresentationIdentifier;
 import eu.dasish.annotation.schema.CachedRepresentationInfo;
-import eu.dasish.annotation.schema.CachedRepresentations;
 import java.util.List;
 
@@ -82 +81 @@
     public int purge(Number internalID);
    
+    /**
+     * 
+     * @return the list of all the internal id-s of the cached representations. 
+     */
+    public List<Number> cachedRepresentationIDs();
+    
+    /**
+     * removes all the cahed representations which are not referred from the versions_cached_representations table
+     * @return the number of affected rows
+     */
+    public int purgeAll();
 }

DASISH/t5.6/backend/annotator-backend/trunk/annotator-backend/src/main/java/eu/dasish/annotation/backend/dao/impl/JdbcCachedRepresentationDao.java

@@ -188 +188 @@
         }
      }; 
+     
+     //////////////////////////////////////////////////////////////////////////////////////////////
+      @Override
+      public List<Number> cachedRepresentationIDs(){        
+       String sqlCheck = "SELECT "+cached_representation_id+" FROM "+cachedRepresentationTableName;
+       List<Number> result= getSimpleJdbcTemplate().query(sqlCheck, cachedRepresentationRunnerRowMapper); 
+       return result;
+     }
+     
+     private final RowMapper<Number> cachedRepresentationRunnerRowMapper = new RowMapper<Number>() {        
+        @Override
+        public Number mapRow(ResultSet rs, int rowNumber) throws SQLException {
+            Number result = rs.getInt(cached_representation_id);
+            return result;
+        }
+     }; 
+     
+     
+     @Override
+     public int purgeAll(){
+         List<Number> ids = cachedRepresentationIDs();
+         int countRemoved = 0;
+         for (Number id: ids){
+             countRemoved = countRemoved + purge(id);
+         }
+         return countRemoved;
+     }
       
       ////////// Helpers ///////////////////

DASISH/t5.6/backend/annotator-backend/trunk/annotator-backend/src/test/java/eu/dasish/annotation/backend/dao/impl/JdbcCachedRepresentationDaoTest.java

@@ -155 +155 @@
     /**
      * Test of purge, of class JdbcCachedRepresentationDao.
-     * public CachedRepresentationInfo addCachedRepresentationInfo(CachedRepresentationInfo cached);    
+     *  public int purge(Number internalID) 
      */
     @Test  
     public void testPurge() {
-        System.out.println(" purge");
+        System.out.println("test purge");
         int result = jdbcCachedRepresentationDao.purge(6);
         assertEquals(1, result);
     }
     
+    /**
+     * test public List<Number> cachedRepresentationIDs()
+     * public List<Number> cachedRepresentationIDs()
+     */
+    @Test  
+    public void testCachedRepresentationIDs() {
+        System.out.println(" test cachedRepresentationIDs");
+        List<Number>  result = jdbcCachedRepresentationDao.cachedRepresentationIDs();
+        assertEquals(6, result.size());
+        assertEquals(1, result.get(0));
+        assertEquals(2, result.get(1));
+        assertEquals(3, result.get(2));
+        assertEquals(4, result.get(3));
+        assertEquals(5, result.get(4));
+        assertEquals(6, result.get(5));
+    }
+    
+     /**
+     * Test of purgeAll, of class JdbcCachedRepresentationDao.
+     * public  int purgeAll() 
+     */
+    @Test  
+    public void testPurgeAll() {
+        System.out.println("test purge All");
+        int result = jdbcCachedRepresentationDao.purgeAll();
+        assertEquals(1, result);
+    }
 }