Package com.dotmarketing.common.db

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

237
238
239
240
241
242
243
244
245
246
247
                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 {
    Connection conn = null;
View Full Code Here
26
27
28
29
30
31
32
33
34
35
36
  public void executeUpgrade() throws DotDataException, DotRuntimeException {
    try {
      DbConnectionFactory.getConnection().setAutoCommit(true);
      DotConnect dc = new DotConnect();
      try {
        dc.executeStatement("drop table container_structures");
      } catch (SQLException e) {
        Logger.info(getClass(),
            "container_structures table does not exist. Will be created.");
      }
      String createTable = "Create table container_structures"
View Full Code Here
43
44
45
46
47
48
49
50
51
52
53
            "varchar2\\(");
        createTable = createTable.replaceAll("text", "nclob");
      } else if (DbConnectionFactory.isMySql()) {
        createTable = createTable.replaceAll("text", "longtext");
      }
      dc.executeStatement(createTable);
    } catch (SQLException e) {
      throw new DotDataException(e.getMessage(), e);
    }
  }
View Full Code Here
34
35
36
37
38
39
40
41
42
43
44
                       + "parent in(select inode from structure)";
   
    String delete_template_htmlpage = "Delete from tree where child in(select inode from inode where type='htmlpage') and "
                    + "parent in(select identifier from template)";
   
    dc.executeStatement(delete_host_containers);
    dc.executeStatement(delete_host_template);
    dc.executeStatement(delete_host_folders);
    dc.executeStatement(delete_folder_folder);
    dc.executeStatement(delete_structure_containers);
    dc.executeStatement(delete_template_htmlpage);
View Full Code Here
35
36
37
38
39
40
41
42
43
44
45
   
    String delete_template_htmlpage = "Delete from tree where child in(select inode from inode where type='htmlpage') and "
                    + "parent in(select identifier from template)";
   
    dc.executeStatement(delete_host_containers);
    dc.executeStatement(delete_host_template);
    dc.executeStatement(delete_host_folders);
    dc.executeStatement(delete_folder_folder);
    dc.executeStatement(delete_structure_containers);
    dc.executeStatement(delete_template_htmlpage);
  }
View Full Code Here
36
37
38
39
40
41
42
43
44
45
46
    String delete_template_htmlpage = "Delete from tree where child in(select inode from inode where type='htmlpage') and "
                    + "parent in(select identifier from template)";
   
    dc.executeStatement(delete_host_containers);
    dc.executeStatement(delete_host_template);
    dc.executeStatement(delete_host_folders);
    dc.executeStatement(delete_folder_folder);
    dc.executeStatement(delete_structure_containers);
    dc.executeStatement(delete_template_htmlpage);
  }
   
View Full Code Here
37
38
39
40
41
42
43
44
45
46
47
                    + "parent in(select identifier from template)";
   
    dc.executeStatement(delete_host_containers);
    dc.executeStatement(delete_host_template);
    dc.executeStatement(delete_host_folders);
    dc.executeStatement(delete_folder_folder);
    dc.executeStatement(delete_structure_containers);
    dc.executeStatement(delete_template_htmlpage);
  }
   
  private void containerTableChanges() throws DotDataException, SQLException {
View Full Code Here
38
39
40
41
42
43
44
45
46
47
48
   
    dc.executeStatement(delete_host_containers);
    dc.executeStatement(delete_host_template);
    dc.executeStatement(delete_host_folders);
    dc.executeStatement(delete_folder_folder);
    dc.executeStatement(delete_structure_containers);
    dc.executeStatement(delete_template_htmlpage);
  }
   
  private void containerTableChanges() throws DotDataException, SQLException {
    DotConnect dc = new DotConnect();
View Full Code Here
39
40
41
42
43
44
45
46
47
48
49
    dc.executeStatement(delete_host_containers);
    dc.executeStatement(delete_host_template);
    dc.executeStatement(delete_host_folders);
    dc.executeStatement(delete_folder_folder);
    dc.executeStatement(delete_structure_containers);
    dc.executeStatement(delete_template_htmlpage);
  }
   
  private void containerTableChanges() throws DotDataException, SQLException {
    DotConnect dc = new DotConnect();
    String addStructure = "ALTER TABLE containers add structure_inode varchar(36)";
View Full Code Here
50
51
52
53
54
55
56
57
58
59
60
    if(DbConnectionFactory.isOracle())
        addStructure=addStructure.replaceAll("varchar\\(", "varchar2\\(");
    String addFK = "ALTER TABLE containers add constraint structure_fk foreign key (structure_inode) references structure(inode)";
    String containerQuery = "Select * from tree where child in(Select inode from inode where type='containers') and "
           + "parent in(select inode from structure)";
    dc.executeStatement(addStructure);
    dc.executeStatement(addFK);
   
    dc.setSQL(containerQuery);
    List<Map<String, String>> treeResults = dc.loadResults();
    for(Map<String,String> tree : treeResults){
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.