Mercurial > hg > LGServices
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;