Package com.dotmarketing.common.db

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

48
49
50
51
52
53
54
55
56
57
58
        }
        else if(DbConnectionFactory.isPostgres()) {
          dc.executeStatement("ALTER TABLE TEMPLATE ADD DRAWED  bool");
            dc.executeStatement("ALTER TABLE TEMPLATE ADD DRAWED_BODY text");
            dc.executeStatement("ALTER TABLE TEMPLATE ADD ADD_CONTAINER_LINKS int4");
            dc.executeStatement("ALTER TABLE TEMPLATE ADD CONTAINERS_ADDED int4");
            dc.executeStatement("ALTER TABLE TEMPLATE ADD HEAD_CODE text");
            dc.executeStatement("ALTER TABLE CONTAINERS ADD FOR_METADATA bool");
        }
    }
View Full Code Here
49
50
51
52
53
54
55
56
57
58
59
        else if(DbConnectionFactory.isPostgres()) {
          dc.executeStatement("ALTER TABLE TEMPLATE ADD DRAWED  bool");
            dc.executeStatement("ALTER TABLE TEMPLATE ADD DRAWED_BODY text");
            dc.executeStatement("ALTER TABLE TEMPLATE ADD ADD_CONTAINER_LINKS int4");
            dc.executeStatement("ALTER TABLE TEMPLATE ADD CONTAINERS_ADDED int4");
            dc.executeStatement("ALTER TABLE TEMPLATE ADD HEAD_CODE text");
            dc.executeStatement("ALTER TABLE CONTAINERS ADD FOR_METADATA bool");
        }
    }

View Full Code Here
50
51
52
53
54
55
56
57
58
59
60
          dc.executeStatement("ALTER TABLE TEMPLATE ADD DRAWED  bool");
            dc.executeStatement("ALTER TABLE TEMPLATE ADD DRAWED_BODY text");
            dc.executeStatement("ALTER TABLE TEMPLATE ADD ADD_CONTAINER_LINKS int4");
            dc.executeStatement("ALTER TABLE TEMPLATE ADD CONTAINERS_ADDED int4");
            dc.executeStatement("ALTER TABLE TEMPLATE ADD HEAD_CODE text");
            dc.executeStatement("ALTER TABLE CONTAINERS ADD FOR_METADATA bool");
        }
    }


    public void executeUpgrade() throws DotDataException, DotRuntimeException {
View Full Code Here
355
356
357
358
359
360
361
362
363
364
365
            "structure_id varchar(36) not null references structure(inode))"+createTableSufix);

        dc.executeStatement("create index wf_idx_scheme_structure_1 on " +
            "workflow_scheme_x_structure(structure_id);");

        dc.executeStatement("create unique index workflow_idx_scheme_structure_2 on " +
            "workflow_scheme_x_structure(structure_id);");

        dc.executeStatement("delete from workflow_history;  ");
        dc.executeStatement("delete from workflow_comment;  ");
        dc.executeStatement("delete from workflowtask_files;  ");
View Full Code Here
358
359
360
361
362
363
364
365
366
367
368
            "workflow_scheme_x_structure(structure_id);");

        dc.executeStatement("create unique index workflow_idx_scheme_structure_2 on " +
            "workflow_scheme_x_structure(structure_id);");

        dc.executeStatement("delete from workflow_history;  ");
        dc.executeStatement("delete from workflow_comment;  ");
        dc.executeStatement("delete from workflowtask_files;  ");
        dc.executeStatement("delete from workflow_task; ");
        dc.executeStatement("alter table workflow_task add constraint FK_workflow_task_asset foreign key (webasset) references identifier(id)");
        dc.executeStatement("ALTER TABLE workflow_task MODIFY status varchar(36)");
View Full Code Here
359
360
361
362
363
364
365
366
367
368
369
        dc.executeStatement("create unique index workflow_idx_scheme_structure_2 on " +
            "workflow_scheme_x_structure(structure_id);");

        dc.executeStatement("delete from workflow_history;  ");
        dc.executeStatement("delete from workflow_comment;  ");
        dc.executeStatement("delete from workflowtask_files;  ");
        dc.executeStatement("delete from workflow_task; ");
        dc.executeStatement("alter table workflow_task add constraint FK_workflow_task_asset foreign key (webasset) references identifier(id)");
        dc.executeStatement("ALTER TABLE workflow_task MODIFY status varchar(36)");
        dc.executeStatement("ALTER TABLE workflow_task MODIFY assigned_to varchar(36)");
View Full Code Here
360
361
362
363
364
365
366
367
368
369
370
        dc.executeStatement("create unique index workflow_idx_scheme_structure_2 on " +
            "workflow_scheme_x_structure(structure_id);");

        dc.executeStatement("delete from workflow_history;  ");
        dc.executeStatement("delete from workflow_comment;  ");
        dc.executeStatement("delete from workflowtask_files;  ");
        dc.executeStatement("delete from workflow_task; ");
        dc.executeStatement("alter table workflow_task add constraint FK_workflow_task_asset foreign key (webasset) references identifier(id)");
        dc.executeStatement("ALTER TABLE workflow_task MODIFY status varchar(36)");
        dc.executeStatement("ALTER TABLE workflow_task MODIFY assigned_to varchar(36)");
        dc.executeStatement("alter table workflow_task add constraint FK_workflow_assign foreign key (assigned_to) references cms_role(id)");
View Full Code Here
361
362
363
364
365
366
367
368
369
370
371
            "workflow_scheme_x_structure(structure_id);");

        dc.executeStatement("delete from workflow_history;  ");
        dc.executeStatement("delete from workflow_comment;  ");
        dc.executeStatement("delete from workflowtask_files;  ");
        dc.executeStatement("delete from workflow_task; ");
        dc.executeStatement("alter table workflow_task add constraint FK_workflow_task_asset foreign key (webasset) references identifier(id)");
        dc.executeStatement("ALTER TABLE workflow_task MODIFY status varchar(36)");
        dc.executeStatement("ALTER TABLE workflow_task MODIFY assigned_to varchar(36)");
        dc.executeStatement("alter table workflow_task add constraint FK_workflow_assign foreign key (assigned_to) references cms_role(id)");
        dc.executeStatement("alter table workflow_task add constraint FK_workflow_step foreign key (status) references workflow_step(id)");
View Full Code Here
362
363
364
365
366
367
368
369
370
371
372
        dc.executeStatement("delete from workflow_history;  ");
        dc.executeStatement("delete from workflow_comment;  ");
        dc.executeStatement("delete from workflowtask_files;  ");
        dc.executeStatement("delete from workflow_task; ");
        dc.executeStatement("alter table workflow_task add constraint FK_workflow_task_asset foreign key (webasset) references identifier(id)");
        dc.executeStatement("ALTER TABLE workflow_task MODIFY status varchar(36)");
        dc.executeStatement("ALTER TABLE workflow_task MODIFY assigned_to varchar(36)");
        dc.executeStatement("alter table workflow_task add constraint FK_workflow_assign foreign key (assigned_to) references cms_role(id)");
        dc.executeStatement("alter table workflow_task add constraint FK_workflow_step foreign key (status) references workflow_step(id)");
        dc.executeStatement("alter table workflow_scheme add constraint FK_wf_scheme_action foreign key (entry_action_id) references workflow_action(id)");
View Full Code Here
363
364
365
366
367
368
369
370
371
372
373
        dc.executeStatement("delete from workflow_history;  ");
        dc.executeStatement("delete from workflow_comment;  ");
        dc.executeStatement("delete from workflowtask_files;  ");
        dc.executeStatement("delete from workflow_task; ");
        dc.executeStatement("alter table workflow_task add constraint FK_workflow_task_asset foreign key (webasset) references identifier(id)");
        dc.executeStatement("ALTER TABLE workflow_task MODIFY status varchar(36)");
        dc.executeStatement("ALTER TABLE workflow_task MODIFY assigned_to varchar(36)");
        dc.executeStatement("alter table workflow_task add constraint FK_workflow_assign foreign key (assigned_to) references cms_role(id)");
        dc.executeStatement("alter table workflow_task add constraint FK_workflow_step foreign key (status) references workflow_step(id)");
        dc.executeStatement("alter table workflow_scheme add constraint FK_wf_scheme_action foreign key (entry_action_id) references workflow_action(id)");
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.