FTPC Offline Database macros



Ftpc Offline Database macros

In $STAR/StRoot/StFtpcCalibMaker/macros, there is a set of macros for printing or downloading the FTPC tables from and uploading the FTPC tables to the STAR MySQL offline database. To use these macros, add $(STAR)/StRoot/StFtpcCalibMaker/macros to the 'Root.MacroPath' in your .rootrc file. Before you can upload to the database for the first time, you must ask Dmitry Arkhipkin to grant you permission. Db_PrintTable.C prints out the contents of the specified table for the specified timestamp Db_ReadTable.C Use this macro to read an FTPC table for a specified time from either the Calibrations_ftpc database or the Geometry_ftpc database and write it out into your working directory Don't forget to first setenv DB_ACCESS_MODE read For example: root4star -b -q 'Db_ReadTable.C("Calibrations_ftpc","ftpcGas","2008-05-01 00:00:00")' will create an ftpcGas.C file in your working directory. This file will contain the Calibrations_ftpc/ftpcGas table values which are valid for 2008-05-01 00:00:00, the selected timestamp. Db_LoadTable.C Use this macro to upload an FTPC "tableName".C file from your working directory into the database with the beginTime you specify. Don't forget to first setenv DB_ACCESS_MODE write For example: With this macro, you can load the ftpcGas.C file with new values into the database for the beginTime you specify. root4star -b -q 'Db_LoadTable.C("Calibrations_ftpc","ftpcGas","2008-05-01 00:00:00")' Db_ReadDriftMaps.C Use this macro to read the FTPC drift map tables (ftpcDeflection,ftpcVDrift,ftpcdDeflectiondP,ftpcdVDriftdP) from the Calibrations_ftpc database and to write them out into the directory dirname The FTPC drift map tables are "flavored" tables Before running this macro, create a sub-directory in your working directory for each of the 5 flavors: flavor sub-directory ------ ------------- ffp10kv FullFieldPositive hfp10kv HalfFieldPositive zf10kv ZeroField hfn10kv HalfFieldNegative ffn10kv FullFieldNegative Don't forget to setenv DB_ACCESS_MODE read To dump the complete set of drift maps for a specific timestamp run the following 5 jobs. The timestamp in this example is for the 50% Ar,50% CO2 drift maps The timestamp for the 50.3% Ar, 49.7% CO2 drift maps is "2005-11-01 00:00:00": root4star -b -q 'Db_ReadDriftMaps.C("FullFieldPositive","2001-11-04 00:00:00","ffp10kv")' root4star -b -q 'Db_ReadDriftMaps.C("HalfFieldPositive","2001-11-04 00:00:00","hfp10kv")' root4star -b -q 'Db_ReadDriftMaps.C("ZeroFieldPositive","2001-11-04 00:00:00","zf10kv")' root4star -b -q 'Db_ReadDriftMaps.C("HalfFieldNegative","2001-11-04 00:00:00","hfn10kv")' root4star -b -q 'Db_ReadDriftMaps.C("FullFieldNegative","2001-11-04 00:00:00","ffn10kv")' Db_LoadDriftMaps.C Use this macro to load the 5 sets of the 4 FTPC "flavored" drift map tables (ftpcDeflection,ftpcVDrift,ftpcdDeflectiondP,ftpcdVDriftdP) to the Calibrations_ftpc database There should be 5 sub-directories in your working directory, one for each of the 5 flavors. The drift map tables are produced by the StFtpcDriftMapMaker flavor sub-directory ------ ------------- ffp10kv FullFieldPositive hfp10kv HalfFieldPositive zf10kv ZeroField hfn10kv HalfFieldNegative ffn10kv FullFieldNegative Don't forget to setenv DB_ACCESS_MODE write To load the complete set of drift maps for a specific timestamp run the following 5 jobs. The timestamp in this example is for the 50% Ar,50% CO2 drift maps which should be used again starting with the 2007/2008 dAu run The timestamp used here is "2007-11-01 00:00:00" root4star -b -q 'Db_LoadDriftMaps.C("FullFieldPositive","2007-11-01 00:00:00","ffp10kv")' root4star -b -q 'Db_LoadDriftMaps.C("HalfFieldPositive","2007-11-01 00:00:00","hfp10kv")' root4star -b -q 'Db_LoadDriftMaps.C("ZeroFieldPositive","2007-11-01 00:00:00","zf10kv")' root4star -b -q 'Db_LoadDriftMaps.C("HalfFieldNegative","2007-11-01 00:00:00","hfn10kv")' root4star -b -q 'Db_LoadDriftMaps.C("FullFieldNegative","2007-11-01 00:00:00","ffn10kv")'

This page was update by Janet Seyboth on Aug 19, 2009