[jira] [Commented] (AIRAVATA-2701) GroupResourceProfile migration script

["Marcus Christie (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/AIRAVATA-2701?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16969364#comment-16969364 ] 

Marcus Christie commented on AIRAVATA-2701:
-------------------------------------------

One thing the migration script doesn't do is back populate GROUP_RESOURCE_PROFILE_ID. This was desired when trying to recover experiments from before the migration. Here are scripts I used:
{code:sql}
update PROCESS p
set GROUP_RESOURCE_PROFILE_ID = (
    select GROUP_RESOURCE_PROFILE_ID from app_catalog.GROUP_RESOURCE_PROFILE
    where GATEWAY_ID = (select GATEWAY_ID from EXPERIMENT where EXPERIMENT_ID = p.EXPERIMENT_ID)
    and GROUP_RESOURCE_PROFILE_NAME = 'Default'
)
where GROUP_RESOURCE_PROFILE_ID is null and exists (
    select 1
    from EXPERIMENT
    where EXPERIMENT_ID = p.EXPERIMENT_ID
    and CREATION_TIME between '2019-10-01' and '2019-11-04'
);


update USER_CONFIGURATION_DATA u
set GROUP_RESOURCE_PROFILE_ID = (
    select GROUP_RESOURCE_PROFILE_ID from app_catalog.GROUP_RESOURCE_PROFILE
    where GATEWAY_ID = (select GATEWAY_ID from EXPERIMENT where EXPERIMENT_ID = u.EXPERIMENT_ID)
    and GROUP_RESOURCE_PROFILE_NAME = 'Default'
)
where GROUP_RESOURCE_PROFILE_ID is null and exists (
    select 1
    from EXPERIMENT
    where EXPERIMENT_ID = u.EXPERIMENT_ID
    and CREATION_TIME between '2019-10-01' and '2019-11-04'
);
{code}

> GroupResourceProfile migration script
> -------------------------------------
>
>                 Key: AIRAVATA-2701
>                 URL: https://issues.apache.org/jira/browse/AIRAVATA-2701
>             Project: Airavata
>          Issue Type: Bug
>            Reporter: Marcus Christie
>            Assignee: Marcus Christie
>            Priority: Major
>
> Migrate the GatewayResourceProfile to a default GroupResourceProfile that is shared with the "everyone" group.
> We can add this to the AiravataDataMigrator class.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)