POTATO: Phase II Outer Tracker Analyzer of Test Outputs

Primary git repository

• https://gitlab.cern.ch/cms_tk_ph2/potato

To do items

• Ramon finishes the whole code and updates the Wiki

Related code repositories

• https://gitlab.cern.ch/smaier/dbwrapper/-/tree/master
• https://gitlab.cern.ch/kwei/Ph2_ACF_GUI/-/blob/master/Gui/database.py

How to access the Dummy DB from shell

• First run: =wget https://raw.githubusercontent.com/valdasraps/resthub/master/clients/python/src/main/python/rhapi.py =
  • Alternatively if you're using a GPN you can use /afs/cern.ch/user/v/valdo/public/rhapi.py
• This will download rhapi.py, which is needed to run the following commands
• Running python3 rhapi.py --url=http://dbloader-tracker:8113 will list both the real(cmsr) and dummy(int2r) databases. Not necessary, from here on I'll be using dummy
• To see available tables: python3 rhapi.py --url=http://dbloader-tracker:8113 trker_int2r , this is where everything is stored
• To list table metadata (Look inside the table) run python3 rhapi.py --url=http://dbloader-tracker:8113 trker_int2r.INSERTTABLENAME
  • Example: python3 rhapi.py --url=http://dbloader-tracker:8113 trker_int2r.kinds_of_part , you'll notice kinds_of_part is a table from the third command.
• If you need to do a more specific query you can use SQL command inside the parenthesis of this command: python3 rhapi.py --url=http://dbloader-tracker:8113 "select * from trker_int2r.kinds_of_part p"
  • Still unsure what the p does at the end but it doesn't work without it
  • Adding -c at the end of the query will give you the size of the table (Count the results)
• To give the output in xml format just add -f xml at the end
  • Example: python3 rhapi.py --url=http://dbloader-tracker:8113 "select * from trker_int2r.kinds_of_part p" -f xml
• There's also python3 rhapi.py --help for more info
• You can find the more complete twiki at https://twiki.cern.ch/twiki/bin/viewauth/CMS/ConstructionDB

How to ask query using curl on terminal

• kinit @CERN.CH
• Install authentication utilities from https://gitlab.cern.ch/authzsvc/tools/auth-get-sso-cookie
• Create cookie file using
  • auth-get-sso-cookie --nocertverify -u https://cmsdca.cern.ch -o cookies.txt
• Ask query and get query ID with
  • curl --insecure -b cookies.txt -L -v -X POST -d "select r.run_number from trker_int2r.trk_ot_test_nextrun_v r" https://cmsdca.cern.ch/trk_rhapi/query ; echo
• Get query data using the previous query ID
  • curl --insecure -b cookies.txt -L -v -G "https://cmsdca.cern.ch/trk_rhapi/query/<queryID>/data" --data-urlencode "" ; echo

-- JennetElizabethDickinson - 2022-03-08