com.centurylink.mdw.service.data.CollaborationDataAccess Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of mdw-services Show documentation
Show all versions of mdw-services Show documentation
MDW is a workflow framework specializing in microservice orchestration
/*
* Copyright (C) 2017 CenturyLink, Inc.
*
* Licensed 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 com.centurylink.mdw.service.data;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;
import com.centurylink.mdw.dataaccess.DataAccessException;
import com.centurylink.mdw.dataaccess.db.CommonDataAccess;
import com.centurylink.mdw.model.Attachment;
import com.centurylink.mdw.model.Comment;
public class CollaborationDataAccess extends CommonDataAccess {
public List getNotes(String owner, Long ownerId) throws DataAccessException {
try {
db.openConnection();
List notes = new ArrayList();
String query = "select * from INSTANCE_NOTE"
+ " where instance_note_owner = ? and INSTANCE_NOTE_OWNER_ID = ?"
+ " order by create_dt";
Object[] args = new Object[2];
args[0] = owner;
args[1] = ownerId;
ResultSet rs = db.runSelect(query, args);
while (rs.next()) {
Comment note = new Comment();
note.setId(rs.getLong("instance_note_id"));
note.setOwnerType(rs.getString("instance_note_owner"));
note.setOwnerId(rs.getLong("instance_note_owner_id"));
note.setName(rs.getString("instance_note_name"));
note.setContent(rs.getString("instance_note_details"));
note.setCreated(rs.getTimestamp("create_dt"));
note.setCreateUser(rs.getString("create_usr"));
note.setModified(rs.getTimestamp("mod_dt"));
note.setModifyUser(rs.getString("mod_usr"));
notes.add(note);
}
return notes;
}
catch (Exception ex) {
throw new DataAccessException("Failed to get notes", ex);
}
finally {
db.closeConnection();
}
}
public Comment getNote(Long id) throws DataAccessException {
try {
db.openConnection();
Comment note = null;
String query = "select * from INSTANCE_NOTE where instance_note_id = ?";
ResultSet rs = db.runSelect(query, id);
while (rs.next()) {
note = new Comment();
note.setId(rs.getLong("instance_note_id"));
note.setOwnerType(rs.getString("instance_note_owner"));
note.setOwnerId(rs.getLong("instance_note_owner_id"));
note.setName(rs.getString("instance_note_name"));
note.setContent(rs.getString("instance_note_details"));
note.setCreated(rs.getTimestamp("create_dt"));
note.setCreateUser(rs.getString("create_usr"));
note.setModified(rs.getTimestamp("mod_dt"));
note.setModifyUser(rs.getString("mod_usr"));
}
return note;
}
catch (Exception ex) {
throw new DataAccessException("Failed to get note " + id, ex);
}
finally {
db.closeConnection();
}
}
public Long createNote(String owner, Long ownerId, String name, String contents, String user)
throws DataAccessException {
try {
db.openConnection();
Long id = db.isMySQL() ? null : this.getNextId("INSTANCE_NOTE_ID_SEQ");
String query = "insert into INSTANCE_NOTE "
+ "(INSTANCE_NOTE_ID,INSTANCE_NOTE_OWNER,INSTANCE_NOTE_OWNER_ID,"
+ " INSTANCE_NOTE_NAME,INSTANCE_NOTE_DETAILS," + " CREATE_DT,CREATE_USR) "
+ "values (?,?,?,?,?," + now() + ",?)";
Object[] args = new Object[6];
args[0] = id;
args[1] = owner;
args[2] = ownerId;
args[3] = name;
args[4] = contents;
args[5] = user;
if (db.isMySQL())
id = db.runInsertReturnId(query, args);
else
db.runUpdate(query, args);
db.commit();
return id;
}
catch (Exception ex) {
db.rollback();
throw new DataAccessException("Failed to create " + owner + " note for: " + ownerId, ex);
}
finally {
db.closeConnection();
}
}
public void deleteNote(Long id) throws DataAccessException {
try {
db.openConnection();
String query = "delete from INSTANCE_NOTE where instance_note_id = ?";
db.runUpdate(query, id);
db.commit();
}
catch (Exception ex) {
db.rollback();
throw new DataAccessException("Failed to delete note: " + id, ex);
}
finally {
db.closeConnection();
}
}
public void updateNote(Long id, String name, String contents, String user) throws DataAccessException {
try {
db.openConnection();
String query = "update INSTANCE_NOTE "
+ "set INSTANCE_NOTE_NAME=?,INSTANCE_NOTE_DETAILS=?,MOD_DT=" + now()
+ ",MOD_USR=? " + "where INSTANCE_NOTE_ID=?";
Object[] args = new Object[4];
args[0] = name;
args[1] = contents;
args[2] = user;
args[3] = id;
db.runUpdate(query, args);
db.commit();
}
catch (Exception e) {
db.rollback();
throw new DataAccessException(0, "failed to update instance note", e);
}
finally {
db.closeConnection();
}
}
public List getAttachments(String ownerType, Long ownerId) throws DataAccessException {
try {
db.openConnection();
List attachments = new ArrayList();
String query = "select * from ATTACHMENT where attachment_owner=? and attachment_owner_id=?";
Object[] args = new Object[2];
args[0] = ownerType;
args[1] = ownerId;
ResultSet rs = db.runSelect(query, args);
while (rs.next()) {
Attachment attachment = new Attachment();
attachment.setId(rs.getLong("attachment_id"));
attachment.setOwnerType(rs.getString("attachment_owner"));
attachment.setOwnerId(rs.getLong("attachment_owner_id"));
attachment.setName(rs.getString("attachment_name"));
attachment.setLocation(rs.getString("attachment_location"));
attachment.setContentType(rs.getString("attachment_content_type"));
attachment.setCreated(rs.getTimestamp("create_dt"));
attachment.setCreateUser(rs.getString("create_usr"));
attachment.setModified(rs.getTimestamp("mod_dt"));
attachment.setModifyUser(rs.getString("mod_usr"));
attachments.add(attachment);
}
return attachments;
}
catch (Exception ex) {
throw new DataAccessException("Failed to get attachments", ex);
}
finally {
db.closeConnection();
}
}
public Attachment getAttachment(Long id) throws DataAccessException {
try {
db.openConnection();
Attachment attachment = null;
String query = "select * from ATTACHMENT where attachment_id=?";
ResultSet rs = db.runSelect(query, id);
if (rs.next()) {
attachment = new Attachment();
attachment.setId(rs.getLong("attachment_id"));
attachment.setOwnerType(rs.getString("attachment_owner"));
attachment.setOwnerId(rs.getLong("attachment_owner_id"));
attachment.setName(rs.getString("attachment_name"));
attachment.setLocation(rs.getString("attachment_location"));
attachment.setContentType(rs.getString("attachment_content_type"));
attachment.setCreated(rs.getTimestamp("create_dt"));
attachment.setCreateUser(rs.getString("create_usr"));
attachment.setModified(rs.getTimestamp("mod_dt"));
attachment.setModifyUser(rs.getString("mod_usr"));
}
return attachment;
}
catch (Exception ex) {
throw new DataAccessException("Failed to retrieve attachment " + id, ex);
}
finally {
db.closeConnection();
}
}
public Long createAttachment(String ownerType, Long ownerId,
String name, String location, String contentType, String user)
throws DataAccessException {
try {
db.openConnection();
Long id = db.isMySQL() ? null : this.getNextId("ATTACHMENT_ID_SEQ");
String query = "insert into ATTACHMENT"
+ " (attachment_id, attachment_owner, attachment_owner_id,"
+ " attachment_name, attachment_location, attachment_content_type,"
+ " create_dt, create_usr) " + "values (?,?,?,?,?,?," + now() + ",?)";
Object[] args = new Object[7];
args[0] = id;
args[1] = ownerType;
args[2] = ownerId;
args[3] = name;
args[4] = location;
args[5] = contentType;
args[6] = user;
if (db.isMySQL())
id = db.runInsertReturnId(query, args);
else
db.runUpdate(query, args);
db.commit();
return id;
}
catch (Exception ex) {
db.rollback();
throw new DataAccessException("Failed to create " + ownerType + " attachment for: " + ownerId, ex);
}
finally {
db.closeConnection();
}
}
public void deleteAttachment(Long id) throws DataAccessException {
try {
db.openConnection();
String query = "delete from ATTACHMENT where attachment_id = ?";
Object[] args = new Object[1];
args[1] = id;
db.runUpdate(query, args);
db.commit();
}
catch (Exception ex) {
db.rollback();
throw new DataAccessException("Failed to delete attachment: " + id, ex);
}
finally {
db.closeConnection();
}
}
public void updateAttachment(Long id, String user)
throws DataAccessException {
try {
db.openConnection();
String query = "update ATTACHMENT set mod_dt=" + now()
+ ", mod_usr= ? where attachment_id = ?";
Object[] args = new Object[2];
args[0] = user;
args[1] = id;
db.runUpdate(query, args);
db.commit();
}
catch (Exception ex) {
db.rollback();
throw new DataAccessException("Failed to update attachment: " + id, ex);
}
finally {
db.closeConnection();
}
}
}
© 2015 - 2025 Weber Informatics LLC | Privacy Policy