Sprint 18 Showcase

LT-1231 one-app, LT-547 db init script

LT-1231

Before

Simplification

After

Structure

la-parent

la-webparent

la-webcommonparent

la-parents

la-webcomon

user-mgr

curriculum-mgr

intervention-mgr

la-webcomon

LT-1231

Before

After

Project

LT-1231

Before

After

init project workflow

mkdir la && cd la
git clone la-parents
git clone la-common
git clone la-webcommon
git clone curriculum-mgr
git clone intervention-mgr
git clone user-mgr
cd la-parents/la-parent 
mvn clean install
cd ../la-webparent 
mvn clean install
cd ../la-webcommonparent 
mvn clean install
cd .. 
mvn clean install
git clone la-webcommon

cd la-webcommon

mvn clean install

LT-1231

Before

After

several modules changes workflow

LT-547

    create table cm_good_data_mufs (
        code varchar2(255 char) not null,
        mufs varchar2(255 char),
        primary key (code)
    );
    create table cm_good_data_profile (
        id number(19,0) not null,
        description varchar2(500 char),
        name varchar2(255 char),
        project_id varchar2(255 char),
        mufs varchar2(255 char),
        roles varchar2(255 char),
        primary key (id)
    );
    create table cm_good_data_roles (
        code varchar2(255 char) not null,
        role_names varchar2(255 char),
        primary key (code)
    );
    create table cm_permission (
        application_code varchar2(255 char) not null,
        code varchar2(255 char) not null,
        application_name varchar2(255 char),
        description varchar2(500 char),
        name varchar2(255 char),
        primary key (application_code, code)
    );
    create table cm_role (
        id number(19,0) not null,
        description varchar2(500 char),
        name varchar2(255 char) not null,
        primary key (id)
    );
    create table cm_role_permission (
        role_id number(19,0) not null,
        application_code varchar2(255 char) not null,
        permission_code varchar2(255 char) not null,
        primary key (role_id, application_code, permission_code)
    );
    create table cm_user (
        id number(10,0) not null,
        email varchar2(255 char) not null,
        enabled number(1,0),
        facilitator_key varchar2(255 char),
        first_name varchar2(255 char) not null,
        good_data_login varchar2(255 char),
        good_data_user_id varchar2(255 char),
        institution_code varchar2(255 char),
        last_name varchar2(255 char) not null,
        login varchar2(255 char) not null,
        password varchar2(255 char) not null,
        time_synced timestamp,
        user_institution_id varchar2(255 char),
        primary key (id)
    );
    create table cm_user_good_data_profile (
        user_id number(10,0) not null,
        profile_id number(19,0) not null,
        primary key (user_id, profile_id)
    );
    create table cm_user_role (
        user_id number(10,0) not null,
        role_id number(19,0) not null,
        primary key (user_id, role_id)
    );
    create table cmgr_curriculum (
        id number(10,0) not null,
        curriculum_institution_id varchar2(255 char),
        discarded number(1,0),
        institution_code varchar2(255 char),
        last_modified timestamp,
        outcome_mapping_state varchar2(255 char),
        term_institution_id varchar2(255 char),
        term_name varchar2(255 char),
        unit_code varchar2(255 char),
        unit_name varchar2(255 char),
        primary key (id)
    );
    create table cmgr_outcome (
        id number(10,0) not null,
        name varchar2(500 char),
        curriculum_id number(10,0) not null,
        primary key (id)
    );
    create table cmgr_outcome_mapping (
        id number(10,0) not null,
        activity_institution_id varchar2(255 char),
        activity_name varchar2(255 char),
        activity_sub_type varchar2(255 char),
        activity_type varchar2(255 char),
        institution_code varchar2(255 char),
        weight number(10,0) not null check (weight<=100 AND weight>=0),
        outcome_id number(10,0) not null,
        primary key (id)
    );
    create table imgr_data_source (
        id number(10,0) not null,
        batch_mode number(1,0),
        description varchar2(500 char),
        discarded number(1,0),
        institution_code varchar2(100 char),
        name varchar2(100 char) not null,
        primary key (id)
    );
    create table imgr_data_source_sql (
        id number(10,0) not null,
        code varchar2(50 char) not null,
        description varchar2(500 char),
        execution_order number(10,0),
        sql varchar2(3000 char),
        data_source_id number(10,0),
        primary key (id)
    );
    create table imgr_email_template (
        id number(10,0) not null,
        body clob not null,
        code varchar2(50 char) not null,
        institution_code varchar2(100 char),
        name varchar2(100 char) not null,
        subject varchar2(300 char) not null,
        primary key (id)
    );
    create table imgr_intervention (
        id number(10,0) not null,
        created timestamp,
        created_by varchar2(255 char),
        description varchar2(500 char),
        discarded number(1,0),
        enabled number(1,0),
        institution_code varchar2(100 char),
        last_modified timestamp,
        last_modified_by varchar2(255 char),
        name varchar2(200 char) not null,
        rules_id number(10,0) not null,
        primary key (id)
    );
    create table imgr_parameter_value (
        intervention_id number(10,0) not null,
        parameter_id number(10,0) not null,
        number_value raw(255),
        text_value varchar2(255 char),
        primary key (intervention_id, parameter_id)
    );
    create table imgr_rules (
        type varchar2(31 char) not null,
        id number(10,0) not null,
        description varchar2(500 char),
        discarded number(1,0),
        enabled number(1,0),
        institution_code varchar2(100 char),
        last_modified timestamp,
        name varchar2(500 char) not null,
        compilation_state varchar2(255 char),
        rules_content clob,
        when_condition clob,
        data_source_id number(10,0) not null,
        primary key (id)
    );
    create table imgr_rules_parameter (
        id number(10,0) not null,
        code varchar2(255 char),
        display_order number(10,0),
        label varchar2(255 char),
        type varchar2(255 char),
        rules_id number(10,0),
        primary key (id)
    );
    create table imgr_rules_run_history (
        id number(10,0) not null,
        finish_time timestamp,
        run_state varchar2(255 char),
        run_type varchar2(255 char),
        start_time timestamp not null,
        intervention_id number(10,0),
        rules_id number(10,0),
        primary key (id)
    );
    create table imgr_rules_run_log (
        id number(10,0) not null,
        message varchar2(3000 char),
        system_message number(1,0),
        time timestamp,
        run_history_id number(10,0),
        primary key (id)
    );
    create table imgr_rules_run_output (
        id number(10,0) not null,
        approval_state varchar2(255 char) not null,
        curriculum_code varchar2(255 char),
        curriculum_institution_id varchar2(255 char),
        curriculum_institution_type varchar2(255 char),
        curriculum_key number(19,0),
        curriculum_name varchar2(255 char),
        curriculum_type varchar2(255 char),
        enrolment_institution_id varchar2(255 char),
        enrolment_key number(19,0),
        facilitator_institution_id varchar2(255 char),
        facilitator_key number(19,0),
        institution_code varchar2(255 char),
        last_approval_state_change timestamp,
        offering_institution_id varchar2(255 char),
        offering_key number(19,0),
        other_details clob,
        product_institution_id varchar2(255 char),
        product_key number(19,0),
        student_institution_id varchar2(255 char),
        student_key number(19,0),
        term_code varchar2(255 char),
        term_institution_id varchar2(255 char),
        term_key number(19,0),
        term_name varchar2(255 char),
        run_history_id number(10,0),
        primary key (id)
    );
    create table imgr_rules_variable (
        id number(10,0) not null,
        code varchar2(255 char),
        display_order number(10,0),
        label varchar2(255 char),
        type varchar2(255 char),
        rules_id number(10,0),
        primary key (id)
    );
    create table test_table (
        id number(10,0) not null,
        full_name varchar2(300 char),
        name varchar2(255 char) not null,
        primary key (id)
    );
    create table umgr_dashboard_config (
        id number(10,0) not null,
        height varchar2(255 char) not null check (height<=9999 AND height>=200),
        name varchar2(255 char) not null,
        position number(19,0),
        sso_session_id varchar2(255 char),
        url varchar2(255 char) not null,
        width varchar2(255 char) not null check (width<=9999 AND width>=200),
        primary key (id)
    );
    create table umgr_student (
        id number(10,0) not null,
        api_id varchar2(255 char),
        created timestamp,
        institution_code varchar2(255 char),
        student_institution_id varchar2(255 char),
        time_synced timestamp,
        updated timestamp,
        primary key (id)
    );
    alter table cm_good_data_profile
        add constraint UK_t1yxmg7q94mqds0qquiepq5l  unique (name);
    alter table cm_permission
        add constraint UK_fqiv28eaub0rv46w9yb82oa70  unique (application_name, name);
    alter table cm_role
        add constraint UK_4iqc2wojoqyb2xpkx776fpafn  unique (name);
    alter table cm_user
        add constraint UK_236aff4grxii6gjn5lmukysaf  unique (login);
    create index UK_kw7g44lcur8vf7tpr7m30vbgx on cm_user (good_data_login);
    create index UK_2gdsqhq618ub46ey2gq4mqaji on cm_user (institution_code, user_institution_id);
    create index UK_1akxes1plffcitbbrk5rry38h on cm_user (time_synced);
    alter table cmgr_curriculum
        add constraint UK_qdsfdherkk6w3pgw3fxha9i9o  unique (curriculum_institution_id, institution_code, term_institution_id);
    create index UK_16glc4xc75gow2etfsqo4gjl on cmgr_outcome_mapping (institution_code, activity_institution_id);
    alter table imgr_data_source
        add constraint UK_ouw98k9y63takhp5a084sjv2t  unique (name, institution_code);
    alter table imgr_data_source_sql
        add constraint UK_5lk8ak0cp46345moy66gw9ru2  unique (code, data_source_id);
    alter table imgr_email_template
        add constraint UK_6cv54twci4n1womvl916r8nmo  unique (name, institution_code);
    alter table imgr_email_template
        add constraint UK_ie85pvpsb7m982p6bgry5kev0  unique (code, institution_code);
    alter table imgr_intervention
        add constraint UK_gtx5jngs4bkhquioiqpu6a9gc  unique (name, institution_code);
    alter table imgr_rules
        add constraint UK_tbk927bxbpvvbtsa6hmf2xbi2  unique (name, institution_code);
    alter table umgr_student
        add constraint UK_7i2f4vhpfhuhmwfkm8f1givxj  unique (institution_code, student_institution_id);
    alter table cm_good_data_profile
        add constraint FK_c1eoy3kegxpmqjw165leh09r2 
        foreign key (mufs) 
        references cm_good_data_mufs;
    alter table cm_good_data_profile
        add constraint FK_54im02eekr7lhpljemf4ourjn 
        foreign key (roles) 
        references cm_good_data_roles;
    alter table cm_role_permission
        add constraint FK_94f84a7byunaytpxekfj3n2y2 
        foreign key (application_code, permission_code) 
        references cm_permission;
    alter table cm_role_permission
        add constraint FK_jaec1bxrpd9it6rj6w4bitsxl 
        foreign key (role_id) 
        references cm_role;
    alter table cm_user_good_data_profile
        add constraint FK_44el033xrasi7vqkijl8la98u 
        foreign key (profile_id) 
        references cm_good_data_profile;
    alter table cm_user_good_data_profile
        add constraint FK_pkqag83f3h9jgmf57jhv8bc6h 
        foreign key (user_id) 
        references cm_user;
    alter table cm_user_role
        add constraint FK_at3upse1a7g77gs4uruu4p3j0 
        foreign key (role_id) 
        references cm_role;
    alter table cm_user_role
        add constraint FK_i12sbw2s871nbrhmw3ic60s1j 
        foreign key (user_id) 
        references cm_user;
    alter table cmgr_outcome
        add constraint FK_26krgqd1d5klayuas1x1ogvov 
        foreign key (curriculum_id) 
        references cmgr_curriculum;
    alter table cmgr_outcome_mapping
        add constraint FK_7rndhxs8p6q5xjasuyu67sdjm 
        foreign key (outcome_id) 
        references cmgr_outcome;
    alter table imgr_data_source_sql
        add constraint FK_j37himw5a2y64yswkuuetui2j 
        foreign key (data_source_id) 
        references imgr_data_source;
    alter table imgr_intervention
        add constraint FK_ewwk2gpjaj5u4vn51uf9fd2lc 
        foreign key (rules_id) 
        references imgr_rules;
    alter table imgr_parameter_value
        add constraint FK_e85cwi61tfw06yik78ux2ox31 
        foreign key (intervention_id) 
        references imgr_intervention;
    alter table imgr_parameter_value
        add constraint FK_o1a1t99phbbr13ph93bg4mtwu 
        foreign key (parameter_id) 
        references imgr_rules_parameter;
    alter table imgr_rules
        add constraint FK_hmcv6l8286kaxujidgmoi6icq 
        foreign key (data_source_id) 
        references imgr_data_source;
    alter table imgr_rules_parameter
        add constraint FK_sk72b954ae5j73ejccc20d5eu 
        foreign key (rules_id) 
        references imgr_rules;
    alter table imgr_rules_run_history
        add constraint FK_8xhr4ngmgxs8w0w5enk0jodpl 
        foreign key (intervention_id) 
        references imgr_intervention;
    alter table imgr_rules_run_history
        add constraint FK_k2k0nsjx9mfdw4sm3idslw9q7 
        foreign key (rules_id) 
        references imgr_rules;
    alter table imgr_rules_run_log
        add constraint FK_jmp3y3529vxomu1arytp15h32 
        foreign key (run_history_id) 
        references imgr_rules_run_history;
    alter table imgr_rules_run_output
        add constraint FK_glth57o0omuyyc6q9ui0jx2tk 
        foreign key (run_history_id) 
        references imgr_rules_run_history;
    alter table imgr_rules_variable
        add constraint FK_g90rw6s5me2hd08b0t786fdo 
        foreign key (rules_id) 
        references imgr_rules;
    create sequence CMGR_CURRICULUM_SEQ;
    create sequence CMGR_OUTCOME_MAPPING_SEQ;
    create sequence CMGR_OUTCOME_SEQ;
    create sequence CM_GOOD_DATA_PROFILE_SEQ;
    create sequence CM_ROLE_SEQ;
    create sequence CM_USER_SEQ;
    create sequence IMGR_DATA_SOURCE_SEQ;
    create sequence IMGR_DATA_SOURCE_SQL_SEQ;
    create sequence IMGR_EMAIL_TEMPLATE_SEQ;
    create sequence IMGR_INTERVENTION_SEQ;
    create sequence IMGR_RULES_PARAMETER_SEQ;
    create sequence IMGR_RULES_RUN_HISTORY_SEQ;
    create sequence IMGR_RULES_RUN_LOG_SEQ;
    create sequence IMGR_RULES_RUN_OUTPUT_SEQ;
    create sequence IMGR_RULES_SEQ;
    create sequence IMGR_RULES_VARIABLE_SEQ;
    create sequence UMGR_DASHBOARD_CONFIG_SEQ;
    create sequence UMGR_STUDENT_SEQ;

DB "golden image" script

Made with Slides.com