Mercurial > hg > LGServices

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

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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
comparison
equal deleted inserted replaced
53:db2088ac1f50 54:a00efd5d9e77
720 session.getTransaction().commit(); 720 session.getTransaction().commit();
721 721
722 return modifiedFiles; 722 return modifiedFiles;
723 } 723 }
724 724
725 protected static int deleteFullTextSearchFileFromDB(Long fileId){
726 int modifiedFiles = 0;
727
728 Session session = HibernateUtil.getSessionFactory().getCurrentSession();
729 session.getTransaction().begin();
730
731 Query query0 = session.createQuery("delete LGFullTextSearchFile where id = :fileId");
732 query0.setLong("fileId", fileId);
733 modifiedFiles = query0.executeUpdate();
734
735 session.getTransaction().commit();
736
737 return modifiedFiles;
738 }
739
725 protected static int deleteFileFromDB(Long fileId){ 740 protected static int deleteFileFromDB(Long fileId){
726 741
727 int modifiedFiles; 742 int modifiedFiles;
728 Session session = HibernateUtil.getSessionFactory().getCurrentSession(); 743 Session session = HibernateUtil.getSessionFactory().getCurrentSession();
729 session.getTransaction().begin(); 744 session.getTransaction().begin();