com.openkm.dao

Class TaskDao

java.lang.Object

com.openkm.dao.AbstractDao

com.openkm.dao.TaskDao

@Service
public class TaskDao
extends AbstractDao

Task dao.

Author:

jabad

Field Summary

Fields inherited from class com.openkm.dao.AbstractDao

connection, dateFormat

Constructor Summary

Constructors

Constructor and Description
TaskDao()

Method Summary

Modifier and Type	Method and Description
void	deleteExecutionEvents(long id) Delete execution events method.
void	deleteTask(long id) Delete task method.
Set<Long>	findExecutionWithErrorsNotRevised() Find all executions not revised.
List<TaskExecutionEvent>	getExecutionEvents(long taskExecutionId) Get execution events.
List<TaskExecution>	getExecutions(long taskId) Get executions for a task.
TaskExecution	getTaskExecutionById(String taskExecutionId) Get task execution by id.
long	insertTask(FormProperties taskProperties) Insert task.
long	insertTaskExecution(long taskId) Insert task execution.
void	insertTaskExecutionEvent(long taskExecutionId, String description, String type) Insert task execution event.
List<FormProperties>	loadAllTasks() Load all tasks from database.
FormProperties	loadTaskById(long id) Load task by id
void	markAllAsRevised(String id) Mark every execution of a task as revised.
void	markAsRevised(String id) Mark an execution as revised.
void	stopAllTasks() Stop all tasks.
void	updateTask(FormProperties taskProperties) Update task data.
void	updateTaskExecution(long taskId, String state) Update task execution.
void	updateTaskRunningState(long id, boolean running) Update task running state.
void	updateTaskScheduledState(long id, boolean scheduled) Update task scheduled state.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

TaskDao

public TaskDao()

Method Detail

insertTask

public long insertTask(FormProperties taskProperties)
                throws SQLException

Insert task.

Parameters:

taskProperties - task properties

Throws:

SQLException - exception

insertTaskExecutionEvent

public void insertTaskExecutionEvent(long taskExecutionId,
                                     String description,
                                     String type)
                              throws SQLException

Insert task execution event.

Parameters:

taskExecutionId - task execution id

type - type

Throws:

SQLException - exception

loadAllTasks

public List<FormProperties> loadAllTasks()
                                  throws SQLException

Load all tasks from database.

Returns:

all tasks

Throws:

SQLException - exception

loadTaskById

public FormProperties loadTaskById(long id)
                            throws SQLException

Load task by id

Parameters:

id - task id

Returns:

task

Throws:

SQLException - exception

updateTaskExecution

public void updateTaskExecution(long taskId,
                                String state)
                         throws SQLException

Update task execution.

Parameters:

taskId - task id

state - execution state

Throws:

SQLException - exception

stopAllTasks

public void stopAllTasks()
                  throws SQLException

Stop all tasks.

Throws:

SQLException - exception

insertTaskExecution

public long insertTaskExecution(long taskId)
                         throws SQLException

Insert task execution.

Parameters:

taskId - task id

Returns:

the id for the new value stored

Throws:

SQLException - exception

getExecutions

public List<TaskExecution> getExecutions(long taskId)
                                  throws SQLException,
                                         ParseException

Get executions for a task.

Parameters:

taskId - task id

Returns:

the list of executions

Throws:

SQLException - exception

ParseException - exception

getTaskExecutionById

public TaskExecution getTaskExecutionById(String taskExecutionId)
                                   throws SQLException,
                                          ParseException

Get task execution by id.

Parameters:

taskExecutionId - task execution id

Returns:

the execution data

Throws:

SQLException - exception

ParseException - exception

getExecutionEvents

public List<TaskExecutionEvent> getExecutionEvents(long taskExecutionId)
                                            throws SQLException

Get execution events.

Parameters:

taskExecutionId - execution id

Returns:

a list of events for an execution

Throws:

SQLException - exception

updateTaskRunningState

public void updateTaskRunningState(long id,
                                   boolean running)
                            throws SQLException

Update task running state.

Parameters:

id - task id

running - running state

Throws:

SQLException - exception

updateTaskScheduledState

public void updateTaskScheduledState(long id,
                                     boolean scheduled)
                              throws SQLException

Update task scheduled state.

Parameters:

id - task id

scheduled - scheduled state

Throws:

SQLException - exception

updateTask

public void updateTask(FormProperties taskProperties)
                throws SQLException

Update task data.

Parameters:

taskProperties - task properties

Throws:

SQLException - exception

markAsRevised

public void markAsRevised(String id)
                   throws SQLException

Mark an execution as revised.

Parameters:

id - execution id

Throws:

SQLException - exception

findExecutionWithErrorsNotRevised

public Set<Long> findExecutionWithErrorsNotRevised()
                                            throws ParseException,
                                                   SQLException

Find all executions not revised.

Returns:

a list of executions

Throws:

ParseException - exception

SQLException - exception

markAllAsRevised

public void markAllAsRevised(String id)
                      throws SQLException

Mark every execution of a task as revised.

Parameters:

id - task id

Throws:

SQLException - exception

deleteTask

public void deleteTask(long id)
                throws SQLException

Delete task method.

Parameters:

id - task id

Throws:

SQLException - exception

deleteExecutionEvents

public void deleteExecutionEvents(long id)
                           throws SQLException

Delete execution events method.

Parameters:

id - task id

Throws:

SQLException - exception