Skip to content
Snippets Groups Projects

Update COOL.md

Merged Nurcan Ozturk requested to merge nozturk/crest-examples:master into master
+ 13
2
# Browsing COOL data (AtlCoolConsole)
This document provides instructions on how to setup and use the `AtlCoolConsole` tool in order to browse COOL data. The tool is a python package which is available in athena: [AtlCoolConsole.py](https://gitlab.cern.ch/atlas/athena/-/blob/main/Database/CoolConvUtilities/share/AtlCoolConsole.py?ref_type=heads).
There is also a TWiki page for [AtlCoolConsole](https://twiki.cern.ch/twiki/bin/viewauth/AtlasComputing/AtlCoolConsole).
This document provides instructions on how to setup and use the `AtlCoolConsole` tool in order to browse COOL data. The tool is a python package which is available in (athena)[https://gitlab.cern.ch/atlas/athena/-/blob/main/Database/CoolConvUtilities/share/AtlCoolConsole.py?ref_type=heads].
The ATLAS database group have also developed a couple of systems for dynamic browsing of ATLAS COOL folders and tags. These interfaces help to get an overview of ATLAS data in COOL as well as details of specific folders and relationship to COOL Global Tags.
- COMA ([ConditionsMetadata](https://twiki.cern.ch/twiki/bin/viewauth/AtlasComputing/ConditionsMetadata#COMA_Conditions_DB_Folder_Tag_Br)) collects COOL Folder and Tag metadata for the [COMA Conditions DB Browser](https://atlas-tagservices.cern.ch/RBR/rBR_CB_Report.php) (authentication: install grid certificate on your browser)
- [CoolR](https://atlas-muon-align-mon.web.cern.ch/alignui/cooltags) is a [COOLR REST API](https://gitlab.cern.ch/formica/coolR/-/blob/master/swagger_schemas/swagger/yaml/coolrapi_full.yaml?ref_type=heads)
# Table of contents
- [Setup AtlCoolConsole on lxplus](#setup-atlcoolconsole-on-lxplus)
@@ -31,6 +35,13 @@ AtlCoolConsole.py "COOLONL_GLOBAL/CONDBR2"
Connected to 'frontier://ATLF/();schema=ATLAS_COOLONL_GLOBAL;dbname=CONDBR2'
Welcome to AtlCoolConsole. Type 'help' for instructions.
>>> ls
Name Description
/GLOBAL
>>> quit
...
# To see Frontier server setup:
echo $FRONTIER_SERVER
(serverurl=http://atlasfrontier-local.cern.ch:8000/atlr)(serverurl=http://atlasfrontier-ai.cern.ch:8000/atlr)(proxyurl=http://ca-proxy-atlas.cern.ch:3128)(proxyurl=http://ca-proxy-meyrin.cern.ch:3128)(proxyurl=http://ca-proxy.cern.ch:3128)(proxyurl=http://atlasbpfrontier.cern.ch:3127)
...
# Full connection string (you need the have the reader password for the following)
AtlCoolConsole.py "oracle://ATONR_ADG;schema=ATLAS_COOLONL_LAR;dbname=CONDBR2;user=ATLAS_COOL_READER;password=${COOL_READER_PASSWORD}"
@@ -66,7 +77,7 @@ All recent conditions for data are then in CONDBR2, and in OFLP200 for MC campai
The first step you can do is to verify the folders inside the selected schema/db. When you are connected to (e.g.) `ATLAS_COOLONL_LAR`, you will get something like this:
```shell
AtlCoolConsole.py "COOLONL_LAR/CONDBR2"
Connected to 'oracle://ATONR_ADG;schema=ATLAS_COOLONL_LAR;dbname=CONDBR2;user=ATLAS_COOL_READER;password=********'
Connected to 'frontier://ATLF/();schema=ATLAS_COOLONL_LAR;dbname=CONDBR2'
Welcome to AtlCoolConsole. Type 'help' for instructions.
>>> ls
Name Description
Loading