POTATO: Phase II Outer Tracker Analyzer of Test Outputs


Primary git repository

To do items

  • Ramon finishes the whole code and updates the Wiki smile

Related code repositories

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

-- JennetElizabethDickinson - 2022-03-08

Topic attachments
I Attachment History Action Size Date Who Comment
PDFpdf 2022_06_PotatoCodeExplanation.pdf r1 manage 374.4 K 2022-06-14 - 17:41 RamonOgaz This is a brief explanation of the main classes used in the POTATO code, with examples.
JPEGjpg bp-potato-or-potaNO-quiz.jpg r1 manage 42.3 K 2022-01-20 - 00:35 FabioRavera  
Edit | Attach | Watch | Print version | History: r13 < r12 < r11 < r10 < r9 | Backlinks | Raw View | WYSIWYG | More topic actions
Topic revision: r13 - 2022-07-15 - FabioRavera
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    Sandbox All webs login

This site is powered by the TWiki collaboration platform Powered by PerlCopyright & 2008-2023 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
or Ideas, requests, problems regarding TWiki? use Discourse or Send feedback