GrASP

Webpage for easy sample tagging in McM

Database

Table: existing_campaigns

Description:

List of campaigns in McM for monitoring. This is only a list of campaigns, entries are saved in existing_campaign_entries

Columns:

1. uid (PRIMARY KEY AUTOINCREMENT) - unique identifier
2. name - campaign name, may include wildcards

Table: existing_campaign_entries

Description:

Entries for existing campaigns.

Columns:

1. uid (PRIMARY KEY AUTOINCREMENT) - unique identifier
2. updated - show whether entry was updated in currently running update
3. campaign_uid - uid of campaign (FOREIGN KEY to uid in existing_campaigns)
4. chained_request - chained request prepid
5. dataset - dataset name of root request
6. root_request - root request prepid
7. root_request_priority - priority of root request (from McM)
8. root_request_total_events - total events of root request (from McM)
9. root_request_done_events - done events of root request (from McM)
10. root_request_status - root request status in McM
11. root_request_output - root request name of output dataset
12. miniaod - MiniAOD request prepid (if it exists in chained request)
13. miniaod_priority - priority of MiniAOD request (from McM)
14. miniaod_total_events - total events of MiniAOD request (from McM)
15. miniaod_done_events - done events of MiniAOD request (from McM)
16. miniaod_status - MiniAOD request status in McM
17. miniaod_output - MiniAOD request name of output dataset
18. nanoaod - NanoAOD request prepid (if it exists in chained request)
19. nanoaod_priority - priority of NanoAOD request (from McM)
20. nanoaod_total_events - total events of NanoAOD request (from McM)
21. nanoaod_done_events - done events of NanoAOD request (from McM)
22. nanoaod_status - NanoAOD request status in McM
23. nanoaod_output - NanoAOD request name of output dataset
24. interested_pwgs - comma separated list of interested PWGs of MiniAOD request if it exists, root request otherwise. This list is edited from Samples page
25. ref_interested_pwgs - comma separated list of interested PWGs of MiniAOD request if it exists, root request otherwise. This list is updated from McM during each update and not touched until next update. It is used to know which PWGs were added and which ones were removed in Samples page and McM

Table: mcm_users

Description:

Copy of McM users and their roles list.

Columns:

1. username (PRIMARY KEY NOT NULL) - username (CERN login)
2. name - user name and last name
3. role - role in McM