Create a function-job-collection to be used in the MM SuMo tutorial and turn it read-only for all

[wvangeit]

• In staging (aws)
  Function ID: uid: eea21c0d-6c2b-4cf4-91d1-116e6550cb22
  ​JobCollection ID: c2600fb9-96ac-43e7-b3b8-73f5c4b7de80
  Project ID: 47c5e038-4a0c-11f0-84b9-0242ac1718f3

• In production (sim4life.io)

• In production (sim4life.science) - Werner already on it

• In production (osparc.io) - Antonino already on it

• On osparc.io, rerun failed jobs (17), needs to be done manually (Werner)

• On sim4life.science, rerun failed jobs, needs to be done manually (Werner)

[wvangeit]

For the record, the steps are:

• Add row in funcapi_function_job_collections_access_rights to give group 1 read access to job collection
• Add row in funcapi_functions_access_rights to give group 1 read access to function
• And:
  I used this query to give read access to all the function jobs in the collection:

INSERT INTO "funcapi_function_jobs_access_rights" (
  function_job_uuid,
  group_id,
  read,
  write,
  execute,
  created,
  modified,
  product_name
)
SELECT
  function_job_uuid,
  1 AS group_id,
  TRUE AS read,
  FALSE AS write,
  FALSE AS execute,
  NOW() AS created,
  NOW() AS modified,
  's4l' AS product_name
FROM "funcapi_function_job_collections_to_function_jobs"
WHERE function_job_collection_uuid = 'c2600fb9-96ac-43e7-b3b8-73f5c4b7de80';

and to give read access to the project (although this is preferable done in the frontend ...):

INSERT INTO project_to_groups (
    project_uuid,
    gid,
    read,
    write,
    delete,
    created,
    modified
)
SELECT
    fj.class_specific_data->>'project_job_id'  AS project_uuid,
    1                                          AS gid,
    TRUE                                       AS read,
    FALSE                                      AS write,
    FALSE                                      AS delete,
    NOW(),
    NOW()
FROM funcapi_function_jobs                         fj
JOIN funcapi_function_job_collections_to_function_jobs m
      ON m.function_job_uuid = fj.uuid
WHERE m.function_job_collection_uuid = 'c2600fb9-96ac-43e7-b3b8-73f5c4b7de80'

[wvangeit]

@JavierGOrdonnez Just to know for next week, so we need to redo this for production. How long does it take to run this? You mentioned something about running it overnight?

[wvangeit]

@JavierGOrdonnez created/ran the following on sim4life for the tutorial:
function: fe0eef26-56aa-46bb-926a-1b9b7ea18cfa
function job collection: 78cabb20-e088-4e89-b004-53695dd89f54

I will now change the permissions for these

[wvangeit]

Ok, read permissions have been added on sim4life.io for function job collection: 78cabb20-e088-4e89-b004-53695dd89f54
For me it works in the MM Services