Package com.dotmarketing.common.db

Examples of com.dotmarketing.common.db.DotConnect.executeStatement()

82
83
84
85
86
87
88
89
90
91
92
      dc.addParam(uuid);
      dc.addParam(workflowTaskId);
      dc.addParam(fileInode);
      dc.loadResult();
      }
    dc.executeStatement(delete_task_file_relations);
  }
    private void workflowCommentChanges() throws SQLException, DotDataException{
      DotConnect dc = new DotConnect();
      String dropInode = "";
      if (DbConnectionFactory.isMySql()){
View Full Code Here
127
128
129
130
131
132
133
134
135
136
137
    String deleteFromTree = "Delete from tree where parent in(select id from workflow_task) and child in(select id from workflow_comment)";
   
    List<String> queries = SQLUtil.tokenize(dropInode+addWorkFlowCommentFK);
    for(String query :queries){
        try {
            dc.executeStatement(query);
        } catch(Exception ex) {
            Logger.warn(this, ex.getMessage());
        }
    }
    dc.setSQL(workflowtask_workflowcomment_relations);
View Full Code Here
142
143
144
145
146
147
148
149
150
151
152
        dc.setSQL("UPDATE workflow_comment set workflowtask_id = ? where id = ?");
      dc.addParam(workflowTaskId);
      dc.addParam(workflowCommentId);
      dc.loadResult();
      }
      dc.executeStatement(deleteFromTree);
  }
    private void workflowHistoryChanges() throws SQLException, DotDataException{
      String dropInode = "";
      DotConnect dc = new DotConnect();
      if (DbConnectionFactory.isMySql()){
View Full Code Here
187
188
189
190
191
192
193
194
195
196
197
    String deleteFromTree = "Delete from tree where parent in(select id from workflow_task) and child in(select id from workflow_history)";
   
    List<String> queries = SQLUtil.tokenize(dropInode+addWorkFlowHistoryFK);
    for(String query :queries){
        try {
            dc.executeStatement(query);
        } catch(Exception ex) {
            Logger.warn(this, ex.getMessage());
        }
    }
   
View Full Code Here
204
205
206
207
208
209
210
211
212
213
214
      dc.addParam(workflowTaskInode);
      dc.addParam(workflowHistoryInode);
      dc.loadResult();
      }
     
      dc.executeStatement(deleteFromTree);
    }
    private void dropWorkFlowTaskIndexes() throws SQLException{
      String indexes = "";
      DotConnect dc = new DotConnect();
      if(DbConnectionFactory.isOracle()||
View Full Code Here
225
226
227
228
229
230
231
232
233
234
235
                  "drop index workflow_task.idx_workflow_4;" +
                  "drop index workflow_task.idx_workflow_5;";
      }
      List<String> indexList = SQLUtil.tokenize(indexes);
      for(String index:indexList){
        dc.executeStatement(index);
      }
    }
    private void addWorkFlowTaskIndexes() throws SQLException{
      DotConnect dc = new DotConnect();
      if(DbConnectionFactory.isOracle()||
View Full Code Here
233
234
235
236
237
238
239
240
241
242
243
    private void addWorkFlowTaskIndexes() throws SQLException{
      DotConnect dc = new DotConnect();
      if(DbConnectionFactory.isOracle()||
                DbConnectionFactory.isPostgres() ||
                DbConnectionFactory.isMsSql()){
        dc.executeStatement("create index idx_workflow_4 on workflow_task (webasset)");
        dc.executeStatement("create index idx_workflow_5 on workflow_task (created_by)");
        dc.executeStatement("create index idx_workflow_2 on workflow_task (belongs_to)");
        dc.executeStatement("create index idx_workflow_3 on workflow_task (status)");
        dc.executeStatement("create index idx_workflow_1 on workflow_task (assigned_to)");
      }
View Full Code Here
234
235
236
237
238
239
240
241
242
243
244
      DotConnect dc = new DotConnect();
      if(DbConnectionFactory.isOracle()||
                DbConnectionFactory.isPostgres() ||
                DbConnectionFactory.isMsSql()){
        dc.executeStatement("create index idx_workflow_4 on workflow_task (webasset)");
        dc.executeStatement("create index idx_workflow_5 on workflow_task (created_by)");
        dc.executeStatement("create index idx_workflow_2 on workflow_task (belongs_to)");
        dc.executeStatement("create index idx_workflow_3 on workflow_task (status)");
        dc.executeStatement("create index idx_workflow_1 on workflow_task (assigned_to)");
      }
    }
View Full Code Here
235
236
237
238
239
240
241
242
243
244
245
      if(DbConnectionFactory.isOracle()||
                DbConnectionFactory.isPostgres() ||
                DbConnectionFactory.isMsSql()){
        dc.executeStatement("create index idx_workflow_4 on workflow_task (webasset)");
        dc.executeStatement("create index idx_workflow_5 on workflow_task (created_by)");
        dc.executeStatement("create index idx_workflow_2 on workflow_task (belongs_to)");
        dc.executeStatement("create index idx_workflow_3 on workflow_task (status)");
        dc.executeStatement("create index idx_workflow_1 on workflow_task (assigned_to)");
      }
    }
View Full Code Here
236
237
238
239
240
241
242
243
244
245
246
                DbConnectionFactory.isPostgres() ||
                DbConnectionFactory.isMsSql()){
        dc.executeStatement("create index idx_workflow_4 on workflow_task (webasset)");
        dc.executeStatement("create index idx_workflow_5 on workflow_task (created_by)");
        dc.executeStatement("create index idx_workflow_2 on workflow_task (belongs_to)");
        dc.executeStatement("create index idx_workflow_3 on workflow_task (status)");
        dc.executeStatement("create index idx_workflow_1 on workflow_task (assigned_to)");
      }
    }

  public void executeUpgrade() throws DotDataException, DotRuntimeException {
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.