User Tools

Site Tools


database:database

This is an old revision of the document!


Databases

How to make a snapshot of the online database

On lxplus, do:

SetupProject LHCb --dev --use-grid
lhcb-proxy-init

Now create a folder where your database should be, like ~/mydatabase. Set this path to $SQLITEDBPATH Then do:

CondDBAdmin_MakeSnapshot.py --options $SQLDDDBROOT/options/SQLDDDB-Oracle.py -s 2010-02-01UTC -u yyyy-mm-ddUTC ONLINE sqlite_file:myFileName.db/ONLINE

where yyyy-mm-dd is the date in year-month-day which it should cover.

How to access the database in the options file

Do

from Configurables import CondDB, CondDBAccessSvc
CondDB(UseOracle = False)
connection="sqlite_file:/afs/cern.ch/user/initial/name/mydatabase/myFileName.db/ONLINE"
CondDB().addLayer(CondDBAccessSvc("DB",ConnectionString=connection))

How to use the latest tag

Do

CondDB().UseLatestTags = ["2011"] 

if you want to use the latest tag for 2011 data. For *real data* it should always be safe to use the latest tag (this is *not* the case for MC)

Where to find the description of the official tags

database/database.1304409290.txt.gz · Last modified: 2011/05/03 09:54 by decianm