Package com.dotmarketing.common.db

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

364
365
366
367
368
369
370
371
372
373
374
        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)");

    dc.executeStatement("ALTER TABLE workflow_history add  workflow_action_id varchar(36)");
View Full Code Here
365
366
367
368
369
370
371
372
373
374
375
        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)");

    dc.executeStatement("ALTER TABLE workflow_history add  workflow_action_id varchar(36)");
    dc.executeStatement("create index wf_histroy_action_idx on workflow_history(workflow_action_id)");
View Full Code Here
366
367
368
369
370
371
372
373
374
375
376
        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)");

    dc.executeStatement("ALTER TABLE workflow_history add  workflow_action_id varchar(36)");
    dc.executeStatement("create index wf_histroy_action_idx on workflow_history(workflow_action_id)");
    dc.executeStatement("ALTER TABLE workflow_history add  workflow_step_id varchar(36)");
View Full Code Here
367
368
369
370
371
372
373
374
375
376
377
        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)");

    dc.executeStatement("ALTER TABLE workflow_history add  workflow_action_id varchar(36)");
    dc.executeStatement("create index wf_histroy_action_idx on workflow_history(workflow_action_id)");
    dc.executeStatement("ALTER TABLE workflow_history add  workflow_step_id varchar(36)");
    dc.executeStatement("create index wf_histroy_step_idx on workflow_history(workflow_step_id)");
View Full Code Here
369
370
371
372
373
374
375
376
377
378
379
        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)");

    dc.executeStatement("ALTER TABLE workflow_history add  workflow_action_id varchar(36)");
    dc.executeStatement("create index wf_histroy_action_idx on workflow_history(workflow_action_id)");
    dc.executeStatement("ALTER TABLE workflow_history add  workflow_step_id varchar(36)");
    dc.executeStatement("create index wf_histroy_step_idx on workflow_history(workflow_step_id)");

    }
View Full Code Here
370
371
372
373
374
375
376
377
378
379
380
        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)");

    dc.executeStatement("ALTER TABLE workflow_history add  workflow_action_id varchar(36)");
    dc.executeStatement("create index wf_histroy_action_idx on workflow_history(workflow_action_id)");
    dc.executeStatement("ALTER TABLE workflow_history add  workflow_step_id varchar(36)");
    dc.executeStatement("create index wf_histroy_step_idx on workflow_history(workflow_step_id)");

    }
View Full Code Here
371
372
373
374
375
376
377
378
379
380
381
        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)");

    dc.executeStatement("ALTER TABLE workflow_history add  workflow_action_id varchar(36)");
    dc.executeStatement("create index wf_histroy_action_idx on workflow_history(workflow_action_id)");
    dc.executeStatement("ALTER TABLE workflow_history add  workflow_step_id varchar(36)");
    dc.executeStatement("create index wf_histroy_step_idx on workflow_history(workflow_step_id)");

    }

    public void executeUpgrade() throws DotDataException, DotRuntimeException {
View Full Code Here
372
373
374
375
376
377
378
379
380
381
382
        dc.executeStatement("alter table workflow_scheme add constraint FK_wf_scheme_action foreign key (entry_action_id) references workflow_action(id)");

    dc.executeStatement("ALTER TABLE workflow_history add  workflow_action_id varchar(36)");
    dc.executeStatement("create index wf_histroy_action_idx on workflow_history(workflow_action_id)");
    dc.executeStatement("ALTER TABLE workflow_history add  workflow_step_id varchar(36)");
    dc.executeStatement("create index wf_histroy_step_idx on workflow_history(workflow_step_id)");

    }

    public void executeUpgrade() throws DotDataException, DotRuntimeException {
        try {
View Full Code Here
37
38
39
40
41
42
43
44
45
46
47
public class Task00795LiveWorkingToIdentifier implements StartupTask {

    protected void dropOldTriggers() throws DotDataException, SQLException {
        if(DbConnectionFactory.isPostgres()) {
            DotConnect dc = new DotConnect();
            dc.executeStatement(
                "drop trigger if exists content_work_version_trigger ON contentlet");
            dc.executeStatement(
                "drop function if exists content_work_version_check()");
            dc.executeStatement(
                "drop trigger if exists file_asset_live_version_trigger ON file_asset");
View Full Code Here
39
40
41
42
43
44
45
46
47
48
49
    protected void dropOldTriggers() throws DotDataException, SQLException {
        if(DbConnectionFactory.isPostgres()) {
            DotConnect dc = new DotConnect();
            dc.executeStatement(
                "drop trigger if exists content_work_version_trigger ON contentlet");
            dc.executeStatement(
                "drop function if exists content_work_version_check()");
            dc.executeStatement(
                "drop trigger if exists file_asset_live_version_trigger ON file_asset");
            dc.executeStatement(
                "drop function if exists file_asset_live_version_check()");
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.