Project CMSSW displayed by LXR CMSSW_15_0_X_2024-12-03-2300/​CondTools/​L1Trigger/​scripts/​getNextTscKeyByRun.sh	Source navigation Diff markup Identifier search General search
	Version: CMSSW_15_0_X_2024-12-03-2300 CMSSW_15_0_X_2024-12-02-2300 CMSSW_15_0_X_2024-12-01-2300 CMSSW_15_0_X_2024-11-28-2300 CMSSW_15_0_X_2024-11-27-2300 Revert   Change

File indexing completed on 2024-04-06 12:03:13

 #!/bin/sh
 
 # Look for the first of the next new L1 keys which has not been validated.
 # Reference ~l1emulator/o2o/scripts/getRecentKeys.sh
 
 lastRun=$1
 
 DB="cms_omds_lb"
 USER="cms_trg_r"
 PASSWORD_FILE=/nfshome0/centraltspro/secure/$USER.txt
 PASSWORD=`cat $PASSWORD_FILE`
 
 sqlplus -S ${USER}/${PASSWORD}@${DB} <<EOF
 set linesize 500
 set wrap on
 set heading off
 set pagesize 0
 set feedback off
 SELECT *
 FROM
 (
  SELECT MAX(RUNNUMBER) RUNNUMBER, TSCKEY
  FROM CMS_WBM.RUNSUMMARY
  WHERE RUNNUMBER > ${lastRun}
  AND TSCKEY IS NOT NULL
  AND TSCKEY NOT IN
  (
   SELECT DISTINCT TSCKEY
   FROM CMS_WBM.RUNSUMMARY
   WHERE RUNNUMBER <= ${lastRun}
   AND TSCKEY IS NOT NULL
  )
  GROUP BY TSCKEY
  ORDER BY RUNNUMBER
 )
 WHERE ROWNUM = 1
 ;
 EOF
 
 exit

This page was automatically generated by the 2.2.1 LXR engine. The LXR team