CondDBNotes < CMS

CMS Web>NewPhysics>CmsSusy>Diaries>CondDBNotes (2016-02-28, TamasVami) (raw view)

<style type="text/css" media="all"> pre { text-align: left; padding: 10px;margin-left: 20px; color: black; } pre.command {background-color: lightgrey;} pre.cfg {background-color: lightblue;} pre.code {background-color: lightpink;} pre.output {background-color: lightgreen;} pre.tofix {background-color: thistle;} </style>

---+ Notes on the CondDB service

---++ Upload a file
https://twiki.cern.ch/twiki/bin/view/CMS/DropBox

---++ Importing a file

<pre class="command">
conddb_import -f frontier://FrontierProd/CMS_CONDITIONS -i 'SiPixelGenErrorDBObject_38T_v1_offline[cms_orcon_prod/CMS_COND_PIXEL_000]' -c sqlite:SiPixelGenErrorDBObject_38T_v2_offline.db -t &#8216;SiPixelGenErrorDBObject_38T_v2_offline&#8217;
-b '197749' -e '200960'
</pre>

Description:
   * -f for the frontier, it could be FrontierProd/CMS_CONDITIONS  or FrontierPrep/CMS_CONDITIONS 
   * -i for the tagname
   * -c for the name of the now creatable sqlite file
   * -t for the tagname in the now created sqlite file
   * -b starting run number in the tag given by the -t option
   * -e ending run number

---++ Read a local sqlite file

<pre class="command">
conddb --db yourfile.db listTags 
</pre>

-- Main.TamasVami - 2016-02-28

Topic revision: r1 - 2016-02-28 - TamasVami

CMS (CERN)

Copyright &© by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback