diff src/main/java/de/mpiwg/gazetteer/utils/DBService.java @ 54:a00efd5d9e77

new: adding delete saved table function
author Zoe Hong <zhong@mpiwg-berlin.mpg.de>
date Thu, 04 Feb 2016 11:30:46 +0100
parents 9dbbbfd474f4
children 95bf4ac726e6
line wrap: on
line diff
--- a/src/main/java/de/mpiwg/gazetteer/utils/DBService.java	Mon Feb 01 15:49:48 2016 +0100
+++ b/src/main/java/de/mpiwg/gazetteer/utils/DBService.java	Thu Feb 04 11:30:46 2016 +0100
@@ -722,6 +722,21 @@
 		return modifiedFiles;
 	}
 	
+	protected static int deleteFullTextSearchFileFromDB(Long fileId){
+		int modifiedFiles = 0;
+		
+		Session session = HibernateUtil.getSessionFactory().getCurrentSession();
+		session.getTransaction().begin();
+		
+		Query query0 = session.createQuery("delete LGFullTextSearchFile where id = :fileId");
+		query0.setLong("fileId", fileId);
+		modifiedFiles = query0.executeUpdate();
+		
+		session.getTransaction().commit();
+		
+		return modifiedFiles;
+	}
+	
 	protected static int deleteFileFromDB(Long fileId){
 		
 		int modifiedFiles;