| org.sandev.tools.JDBC.THD_QueryProcessor |
public static final java.lang.String |
externalPlanQueryConnector |
"FROM THD_PlanComponent, THD_ExternalPlan WHERE THD_ExternalPlan.uniqueID > 0 AND THD_PlanComponent.uniqueID=THD_ExternalPlan.uniqueID " |
public static final java.lang.String |
externalPlanQueryPreamble |
"THD_PlanComponent.name AS name, THD_PlanComponent.description AS description, THD_PlanComponent.parent AS parent, THD_PlanComponent.resourceID AS resourceID, THD_PlanComponent.timeEstimate AS timeEstimate, THD_PlanComponent.dueDate AS dueDate, THD_PlanComponent.notes AS notes, THD_PlanComponent.uniqueID AS uniqueID, THD_PlanComponent.creationTime AS creationTime, THD_PlanComponent.lastModifiedTime AS lastModifiedTime, THD_PlanComponent.lastModifiedReason AS lastModifiedReason, THD_PlanComponent.revisionNumber AS revisionNumber, THD_PlanComponent.recordStatus AS recordStatus, THD_ExternalPlan.updateURL AS updateURL, THD_ExternalPlan.sourceID AS sourceID, THD_ExternalPlan.username AS username, THD_ExternalPlan.password AS password, THD_ExternalPlan.refresh AS refresh, THD_ExternalPlan.uniqueID AS uniqueID " |
public static final java.lang.String |
heapAttributesQueryConnector |
"FROM THD_HeapAttributes WHERE THD_HeapAttributes.uniqueID > 0 " |
public static final java.lang.String |
heapAttributesQueryPreamble |
"THD_HeapAttributes.description AS description, THD_HeapAttributes.defaultTaskType AS defaultTaskType, THD_HeapAttributes.defaultView AS defaultView, THD_HeapAttributes.hoursPerDay AS hoursPerDay, THD_HeapAttributes.externalPlanLatency AS externalPlanLatency, THD_HeapAttributes.title AS title, THD_HeapAttributes.taskHeapReportHeader AS taskHeapReportHeader, THD_HeapAttributes.taskHeapReportSig AS taskHeapReportSig, THD_HeapAttributes.decorationLevel AS decorationLevel, THD_HeapAttributes.activityIndicator AS activityIndicator, THD_HeapAttributes.lineSummary AS lineSummary, THD_HeapAttributes.uniqueID AS uniqueID, THD_HeapAttributes.creationTime AS creationTime, THD_HeapAttributes.lastModifiedTime AS lastModifiedTime, THD_HeapAttributes.lastModifiedReason AS lastModifiedReason, THD_HeapAttributes.revisionNumber AS revisionNumber, THD_HeapAttributes.recordStatus AS recordStatus " |
public static final java.lang.String |
planComponentQueryConnector |
"FROM THD_PlanComponent WHERE THD_PlanComponent.uniqueID > 0 " |
public static final java.lang.String |
planComponentQueryPreamble |
"THD_PlanComponent.name AS name, THD_PlanComponent.description AS description, THD_PlanComponent.parent AS parent, THD_PlanComponent.resourceID AS resourceID, THD_PlanComponent.timeEstimate AS timeEstimate, THD_PlanComponent.dueDate AS dueDate, THD_PlanComponent.notes AS notes, THD_PlanComponent.uniqueID AS uniqueID, THD_PlanComponent.creationTime AS creationTime, THD_PlanComponent.lastModifiedTime AS lastModifiedTime, THD_PlanComponent.lastModifiedReason AS lastModifiedReason, THD_PlanComponent.revisionNumber AS revisionNumber, THD_PlanComponent.recordStatus AS recordStatus " |
public static final java.lang.String |
planQueryConnector |
"FROM THD_PlanComponent, THD_Plan WHERE THD_Plan.uniqueID > 0 AND THD_PlanComponent.uniqueID=THD_Plan.uniqueID " |
public static final java.lang.String |
planQueryPreamble |
"THD_PlanComponent.name AS name, THD_PlanComponent.description AS description, THD_PlanComponent.parent AS parent, THD_PlanComponent.resourceID AS resourceID, THD_PlanComponent.timeEstimate AS timeEstimate, THD_PlanComponent.dueDate AS dueDate, THD_PlanComponent.notes AS notes, THD_PlanComponent.uniqueID AS uniqueID, THD_PlanComponent.creationTime AS creationTime, THD_PlanComponent.lastModifiedTime AS lastModifiedTime, THD_PlanComponent.lastModifiedReason AS lastModifiedReason, THD_PlanComponent.revisionNumber AS revisionNumber, THD_PlanComponent.recordStatus AS recordStatus, THD_Plan.visibility AS visibility, THD_Plan.execution AS execution, THD_Plan.uniqueID AS uniqueID " |
public static final java.lang.String |
readerQueryConnector |
"FROM THD_Reader WHERE THD_Reader.uniqueID > 0 " |
public static final java.lang.String |
readerQueryPreamble |
"THD_Reader.username AS username, THD_Reader.password AS password, THD_Reader.name AS name, THD_Reader.description AS description, THD_Reader.email AS email, THD_Reader.userStatus AS userStatus, THD_Reader.uniqueID AS uniqueID, THD_Reader.creationTime AS creationTime, THD_Reader.lastModifiedTime AS lastModifiedTime, THD_Reader.lastModifiedReason AS lastModifiedReason, THD_Reader.revisionNumber AS revisionNumber, THD_Reader.recordStatus AS recordStatus " |
public static final java.lang.String |
resourceQueryConnector |
"FROM THD_Reader, THD_Resource WHERE THD_Resource.uniqueID > 0 AND THD_Reader.uniqueID=THD_Resource.uniqueID " |
public static final java.lang.String |
resourceQueryPreamble |
"THD_Reader.username AS username, THD_Reader.password AS password, THD_Reader.name AS name, THD_Reader.description AS description, THD_Reader.email AS email, THD_Reader.userStatus AS userStatus, THD_Reader.uniqueID AS uniqueID, THD_Reader.creationTime AS creationTime, THD_Reader.lastModifiedTime AS lastModifiedTime, THD_Reader.lastModifiedReason AS lastModifiedReason, THD_Reader.revisionNumber AS revisionNumber, THD_Reader.recordStatus AS recordStatus, THD_Resource.allocationPercentage AS allocationPercentage, THD_Resource.uniqueID AS uniqueID " |
public static final java.lang.String |
taskPhaseQueryConnector |
"FROM THD_TaskPhase WHERE THD_TaskPhase.uniqueID > 0 " |
public static final java.lang.String |
taskPhaseQueryPreamble |
"THD_TaskPhase.name AS name, THD_TaskPhase.description AS description, THD_TaskPhase.uniqueID AS uniqueID, THD_TaskPhase.creationTime AS creationTime, THD_TaskPhase.lastModifiedTime AS lastModifiedTime, THD_TaskPhase.lastModifiedReason AS lastModifiedReason, THD_TaskPhase.revisionNumber AS revisionNumber, THD_TaskPhase.recordStatus AS recordStatus " |
public static final java.lang.String |
taskQueryConnector |
"FROM THD_PlanComponent, THD_Task WHERE THD_Task.uniqueID > 0 AND THD_PlanComponent.uniqueID=THD_Task.uniqueID " |
public static final java.lang.String |
taskQueryPreamble |
"THD_PlanComponent.name AS name, THD_PlanComponent.description AS description, THD_PlanComponent.parent AS parent, THD_PlanComponent.resourceID AS resourceID, THD_PlanComponent.timeEstimate AS timeEstimate, THD_PlanComponent.dueDate AS dueDate, THD_PlanComponent.notes AS notes, THD_PlanComponent.uniqueID AS uniqueID, THD_PlanComponent.creationTime AS creationTime, THD_PlanComponent.lastModifiedTime AS lastModifiedTime, THD_PlanComponent.lastModifiedReason AS lastModifiedReason, THD_PlanComponent.revisionNumber AS revisionNumber, THD_PlanComponent.recordStatus AS recordStatus, THD_Task.taskTypeID AS taskTypeID, THD_Task.taskPhaseID AS taskPhaseID, THD_Task.uniqueID AS uniqueID " |
public static final java.lang.String |
taskTypeQueryConnector |
"FROM THD_TaskType WHERE THD_TaskType.uniqueID > 0 " |
public static final java.lang.String |
taskTypeQueryPreamble |
"THD_TaskType.name AS name, THD_TaskType.description AS description, THD_TaskType.uniqueID AS uniqueID, THD_TaskType.creationTime AS creationTime, THD_TaskType.lastModifiedTime AS lastModifiedTime, THD_TaskType.lastModifiedReason AS lastModifiedReason, THD_TaskType.revisionNumber AS revisionNumber, THD_TaskType.recordStatus AS recordStatus " |
| org.sandev.tools.JDBC.THD_UpdateProcessor |
public static final java.lang.String |
insertExternalPlanSQL |
"INSERT INTO THD_ExternalPlan(updateURL, sourceID, username, password, refresh, uniqueID) VALUES(?,?,?,?,?,?)" |
public static final java.lang.String |
insertHeapAttributesSQL |
"INSERT INTO THD_HeapAttributes(description, defaultTaskType, defaultView, hoursPerDay, externalPlanLatency, title, taskHeapReportHeader, taskHeapReportSig, decorationLevel, activityIndicator, lineSummary, uniqueID, creationTime, lastModifiedTime, lastModifiedReason, revisionNumber, recordStatus) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)" |
public static final java.lang.String |
insertPlanComponentSQL |
"INSERT INTO THD_PlanComponent(name, description, parent, resourceID, timeEstimate, dueDate, notes, uniqueID, creationTime, lastModifiedTime, lastModifiedReason, revisionNumber, recordStatus) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?)" |
public static final java.lang.String |
insertPlanSQL |
"INSERT INTO THD_Plan(visibility, execution, uniqueID) VALUES(?,?,?)" |
public static final java.lang.String |
insertReaderSQL |
"INSERT INTO THD_Reader(username, password, name, description, email, userStatus, uniqueID, creationTime, lastModifiedTime, lastModifiedReason, revisionNumber, recordStatus) VALUES(?,?,?,?,?,?,?,?,?,?,?,?)" |
public static final java.lang.String |
insertResourceSQL |
"INSERT INTO THD_Resource(allocationPercentage, uniqueID) VALUES(?,?)" |
public static final java.lang.String |
insertTaskPhaseSQL |
"INSERT INTO THD_TaskPhase(name, description, uniqueID, creationTime, lastModifiedTime, lastModifiedReason, revisionNumber, recordStatus) VALUES(?,?,?,?,?,?,?,?)" |
public static final java.lang.String |
insertTaskSQL |
"INSERT INTO THD_Task(taskTypeID, taskPhaseID, uniqueID) VALUES(?,?,?)" |
public static final java.lang.String |
insertTaskTypeSQL |
"INSERT INTO THD_TaskType(name, description, uniqueID, creationTime, lastModifiedTime, lastModifiedReason, revisionNumber, recordStatus) VALUES(?,?,?,?,?,?,?,?)" |
public static final java.lang.String |
updateExternalPlanSQL |
"UPDATE THD_ExternalPlan SET updateURL=?, sourceID=?, username=?, password=?, refresh=?, uniqueID=? WHERE uniqueID=?" |
public static final java.lang.String |
updateHeapAttributesSQL |
"UPDATE THD_HeapAttributes SET description=?, defaultTaskType=?, defaultView=?, hoursPerDay=?, externalPlanLatency=?, title=?, taskHeapReportHeader=?, taskHeapReportSig=?, decorationLevel=?, activityIndicator=?, lineSummary=?, uniqueID=?, creationTime=?, lastModifiedTime=?, lastModifiedReason=?, revisionNumber=?, recordStatus=? WHERE uniqueID=? AND revisionNumber=?" |
public static final java.lang.String |
updatePlanComponentSQL |
"UPDATE THD_PlanComponent SET name=?, description=?, parent=?, resourceID=?, timeEstimate=?, dueDate=?, notes=?, uniqueID=?, creationTime=?, lastModifiedTime=?, lastModifiedReason=?, revisionNumber=?, recordStatus=? WHERE uniqueID=? AND revisionNumber=?" |
public static final java.lang.String |
updatePlanSQL |
"UPDATE THD_Plan SET visibility=?, execution=?, uniqueID=? WHERE uniqueID=?" |
public static final java.lang.String |
updateReaderSQL |
"UPDATE THD_Reader SET username=?, password=?, name=?, description=?, email=?, userStatus=?, uniqueID=?, creationTime=?, lastModifiedTime=?, lastModifiedReason=?, revisionNumber=?, recordStatus=? WHERE uniqueID=? AND revisionNumber=?" |
public static final java.lang.String |
updateResourceSQL |
"UPDATE THD_Resource SET allocationPercentage=?, uniqueID=? WHERE uniqueID=?" |
public static final java.lang.String |
updateTaskPhaseSQL |
"UPDATE THD_TaskPhase SET name=?, description=?, uniqueID=?, creationTime=?, lastModifiedTime=?, lastModifiedReason=?, revisionNumber=?, recordStatus=? WHERE uniqueID=? AND revisionNumber=?" |
public static final java.lang.String |
updateTaskSQL |
"UPDATE THD_Task SET taskTypeID=?, taskPhaseID=?, uniqueID=? WHERE uniqueID=?" |
public static final java.lang.String |
updateTaskTypeSQL |
"UPDATE THD_TaskType SET name=?, description=?, uniqueID=?, creationTime=?, lastModifiedTime=?, lastModifiedReason=?, revisionNumber=?, recordStatus=? WHERE uniqueID=? AND revisionNumber=?" |