Java tutorial
/* * Licensed to the Apache Software Foundation (ASF) under one * or more contributor license agreements. See the NOTICE file * distributed with this work for additional information * regarding copyright ownership. The ASF licenses this file * to you under the Apache License, Version 2.0 (the * "License") + you may not use this file except in compliance * with the License. You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, * software distributed under the License is distributed on an * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY * KIND, either express or implied. See the License for the * specific language governing permissions and limitations * under the License. */ package org.openmeetings.app.data.file.dao; import java.util.Date; import java.util.List; import javax.persistence.EntityManager; import javax.persistence.NoResultException; import javax.persistence.PersistenceContext; import javax.persistence.TypedQuery; import org.openmeetings.app.OpenmeetingsVariables; import org.openmeetings.app.persistence.beans.files.FileExplorerItem; import org.red5.logging.Red5LoggerFactory; import org.slf4j.Logger; import org.springframework.transaction.annotation.Transactional; /** * @author sebastianwagner * */ @Transactional public class FileExplorerItemDaoImpl { private static final Logger log = Red5LoggerFactory.getLogger(FileExplorerItemDaoImpl.class, OpenmeetingsVariables.webAppRootKey); @PersistenceContext private EntityManager em; public Long add(String fileName, String fileHash, Long parentFileExplorerItemId, Long ownerId, Long room_id, Long insertedBy, Boolean isFolder, Boolean isImage, Boolean isPresentation, String wmlFilePath, Boolean isStoredWmlFile, Boolean isChart, Long externalFileId, String externalType) { log.debug(".add(): adding file " + fileName + " roomID: " + room_id); try { FileExplorerItem fileItem = new FileExplorerItem(); fileItem.setFileName(fileName); fileItem.setFileHash(fileHash); fileItem.setDeleted("false"); fileItem.setParentFileExplorerItemId(parentFileExplorerItemId); fileItem.setOwnerId(ownerId); fileItem.setRoom_id(room_id); fileItem.setInserted(new Date()); fileItem.setInsertedBy(insertedBy); fileItem.setIsFolder(isFolder); fileItem.setIsImage(isImage); fileItem.setIsPresentation(isPresentation); fileItem.setUpdated(new Date()); fileItem.setWmlFilePath(wmlFilePath); fileItem.setIsStoredWmlFile(isStoredWmlFile); fileItem.setIsChart(isChart); fileItem.setExternalFileId(externalFileId); fileItem.setExternalType(externalType); fileItem = em.merge(fileItem); Long fileItemId = fileItem.getFileExplorerItemId(); log.debug(".add(): file " + fileName + " added as " + fileItemId); return fileItemId; } catch (Exception ex2) { log.error(".add(): ", ex2); } return null; } public Long addFileExplorerItem(FileExplorerItem fileItem) { try { fileItem = em.merge(fileItem); Long fileItemId = fileItem.getFileExplorerItemId(); return fileItemId; } catch (Exception ex2) { log.error("[addFileExplorerItem]", ex2); } return null; } public List<FileExplorerItem> getFileExplorerItemsByRoomAndOwner(Long room_id, Long ownerId) { log.debug(".getFileExplorerItemsByRoomAndOwner() started"); try { String hql = "SELECT c FROM FileExplorerItem c " + "WHERE c.deleted <> :deleted " + "AND c.room_id = :room_id " + "AND c.ownerId = :ownerId " + "ORDER BY c.isFolder DESC, c.fileName "; TypedQuery<FileExplorerItem> query = em.createQuery(hql, FileExplorerItem.class); query.setParameter("deleted", "true"); query.setParameter("room_id", room_id); query.setParameter("ownerId", ownerId); List<FileExplorerItem> fileExplorerList = query.getResultList(); return fileExplorerList; } catch (Exception ex2) { log.error("[getFileExplorerItemsByRoomAndOwner]: ", ex2); } return null; } public FileExplorerItem[] getFileExplorerItemsByRoom(Long room_id, Long parentFileExplorerItemId) { log.debug("getFileExplorerItemsByRoom room_id :: " + room_id); try { String hql = "SELECT c FROM FileExplorerItem c " + "WHERE c.deleted <> :deleted " + "AND c.room_id = :room_id " + "AND c.ownerId IS NULL " + "AND c.parentFileExplorerItemId = :parentFileExplorerItemId " + "ORDER BY c.isFolder DESC, c.fileName "; TypedQuery<FileExplorerItem> query = em.createQuery(hql, FileExplorerItem.class); query.setParameter("deleted", "true"); query.setParameter("room_id", room_id); query.setParameter("parentFileExplorerItemId", parentFileExplorerItemId); FileExplorerItem[] fileExplorerList = query.getResultList().toArray(new FileExplorerItem[0]); return fileExplorerList; } catch (Exception ex2) { log.error("[getFileExplorerRootItemsByRoom]: ", ex2); } return null; } public FileExplorerItem[] getFileExplorerItemsByOwner(Long ownerId, Long parentFileExplorerItemId) { log.debug(".getFileExplorerItemsByOwner() started"); try { String hql = "SELECT c FROM FileExplorerItem c " + "WHERE c.deleted <> :deleted " + "AND c.ownerId = :ownerId " + "AND c.parentFileExplorerItemId = :parentFileExplorerItemId " + "ORDER BY c.isFolder DESC, c.fileName "; TypedQuery<FileExplorerItem> query = em.createQuery(hql, FileExplorerItem.class); query.setParameter("deleted", "true"); query.setParameter("ownerId", ownerId); query.setParameter("parentFileExplorerItemId", parentFileExplorerItemId); FileExplorerItem[] fileExplorerList = query.getResultList().toArray(new FileExplorerItem[0]); return fileExplorerList; } catch (Exception ex2) { log.error("[getFileExplorerRootItemsByOwner]: ", ex2); } return null; } public FileExplorerItem[] getFileExplorerItemsByParent(Long parentFileExplorerItemId) { log.debug(".getFileExplorerItemsByParent() started"); try { String hql = "SELECT c FROM FileExplorerItem c " + "WHERE c.deleted <> :deleted " + "AND c.parentFileExplorerItemId = :parentFileExplorerItemId " + "ORDER BY c.isFolder DESC, c.fileName "; TypedQuery<FileExplorerItem> query = em.createQuery(hql, FileExplorerItem.class); query.setParameter("deleted", "true"); query.setParameter("parentFileExplorerItemId", parentFileExplorerItemId); FileExplorerItem[] fileExplorerList = query.getResultList().toArray(new FileExplorerItem[0]); return fileExplorerList; } catch (Exception ex2) { log.error("[getFileExplorerRootItemsByOwner]: ", ex2); } return null; } public FileExplorerItem getFileExplorerItemsById(Long fileExplorerItemId) { //log.debug(".getFileExplorerItemsById() started"); try { String hql = "SELECT c FROM FileExplorerItem c " + "WHERE c.fileExplorerItemId = :fileExplorerItemId"; TypedQuery<FileExplorerItem> query = em.createQuery(hql, FileExplorerItem.class); query.setParameter("fileExplorerItemId", fileExplorerItemId); FileExplorerItem fileExplorerList = null; try { fileExplorerList = query.getSingleResult(); } catch (NoResultException ex) { } return fileExplorerList; } catch (Exception ex2) { log.error("[getFileExplorerItemsById]: ", ex2); } return null; } public FileExplorerItem getFileExplorerItemsByExternalIdAndType(Long externalFileId, String externalType) { log.debug(".getFileExplorerItemsByExternalIdAndType() started"); try { String hql = "SELECT c FROM FileExplorerItem c " + "WHERE c.externalFileId = :externalFileId " + "AND c.externalType LIKE :externalType"; TypedQuery<FileExplorerItem> query = em.createQuery(hql, FileExplorerItem.class); query.setParameter("externalFileId", externalFileId); query.setParameter("externalType", externalType); FileExplorerItem fileExplorerList = null; try { fileExplorerList = query.getSingleResult(); } catch (NoResultException ex) { } return fileExplorerList; } catch (Exception ex2) { log.error("[getFileExplorerItemsByExternalIdAndType]: ", ex2); } return null; } public List<FileExplorerItem> getFileExplorerItems() { log.debug(".getFileExplorerItemsById() started"); try { String hql = "SELECT c FROM FileExplorerItem c "; TypedQuery<FileExplorerItem> query = em.createQuery(hql, FileExplorerItem.class); List<FileExplorerItem> fileExplorerList = query.getResultList(); return fileExplorerList; } catch (Exception ex2) { log.error("[getFileExplorerItemsById]: ", ex2); } return null; } /** * @param fileExplorerItemId */ public void deleteFileExplorerItem(Long fileExplorerItemId) { log.debug(".deleteFileExplorerItem() started"); try { FileExplorerItem fId = this.getFileExplorerItemsById(fileExplorerItemId); fId.setDeleted("true"); fId.setUpdated(new Date()); if (fId.getFileExplorerItemId() == 0) { em.persist(fId); } else { if (!em.contains(fId)) { em.merge(fId); } } } catch (Exception ex2) { log.error("[deleteFileExplorerItem]: ", ex2); } } public void deleteFileExplorerItemByExternalIdAndType(Long externalFilesid, String externalType) { log.debug(".deleteFileExplorerItemByExternalIdAndType() started"); try { FileExplorerItem fId = this.getFileExplorerItemsByExternalIdAndType(externalFilesid, externalType); if (fId == null) { throw new Exception("externalFilesid: " + externalFilesid + " and externalType: " + externalType + " Not found"); } fId.setDeleted("true"); fId.setUpdated(new Date()); if (fId.getFileExplorerItemId() == 0) { em.persist(fId); } else { if (!em.contains(fId)) { em.merge(fId); } } } catch (Exception ex2) { log.error("[deleteFileExplorerItemByExternalIdAndType]: ", ex2); } } /** * @param fileExplorerItemId * @param fileName */ public void updateFileOrFolderName(Long fileExplorerItemId, String fileName) { log.debug(".updateFileOrFolderName() started"); try { FileExplorerItem fId = this.getFileExplorerItemsById(fileExplorerItemId); fId.setFileName(fileName); fId.setUpdated(new Date()); if (fId.getFileExplorerItemId() == 0) { em.persist(fId); } else { if (!em.contains(fId)) { em.merge(fId); } } } catch (Exception ex2) { log.error("[updateFileOrFolderName]: ", ex2); } } public void updateFileOrFolder(FileExplorerItem fId) { log.debug(".updateFileOrFolder() started"); try { // fId.setUpdated(new Date()); if (fId.getFileExplorerItemId() == 0) { em.persist(fId); } else { if (!em.contains(fId)) { em.merge(fId); } } } catch (Exception ex2) { log.error("[updateFileOrFolder]: ", ex2); } } /** * @param fileExplorerItemId * @param newParentFileExplorerItemId * @param isOwner */ public void moveFile(Long fileExplorerItemId, Long parentFileExplorerItemId, Long room_id, Boolean isOwner, Long ownerId) { log.debug(".moveFile() started"); try { FileExplorerItem fId = this.getFileExplorerItemsById(fileExplorerItemId); fId.setParentFileExplorerItemId(parentFileExplorerItemId); if (parentFileExplorerItemId == 0) { if (isOwner) { // move to personal Folder fId.setOwnerId(ownerId); } else { // move to public room folder fId.setOwnerId(null); fId.setRoom_id(room_id); } } else { fId.setOwnerId(null); } fId.setUpdated(new Date()); if (fId.getFileExplorerItemId() == 0) { em.persist(fId); } else { if (!em.contains(fId)) { em.merge(fId); } } } catch (Exception ex2) { log.error("[updateFileOrFolderName]: ", ex2); } } }