Project CMSSW displayed by LXR CMSSW_15_1_X_2025-04-21-2300/​CondTools/​L1Trigger/​scripts/​getNextTscKeyByID.sh	Source navigation Diff markup Identifier search General search
	Version: CMSSW_15_1_X_2025-04-21-2300 CMSSW_15_1_X_2025-04-20-2300 CMSSW_15_1_X_2025-04-18-2300 CMSSW_15_1_X_2025-04-17-2300 CMSSW_15_1_X_2025-04-16-2300 CMSSW_15_1_X_2025-04-15-2300 CMSSW_15_0_4 CMSSW_15_0_3_patch1 CMSSW_14_0_21_patch1 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
 
 lastID=$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 ID, TSC_KEY
 FROM
 (
  SELECT ID, TSC_KEY
  FROM CMS_TRG_L1_CONF.L1_CONF
  WHERE ID > '${lastID}'
  AND TSC_KEY IS NOT NULL
  AND TSC_KEY NOT IN
  (
   SELECT DISTINCT TSC_KEY
   FROM CMS_TRG_L1_CONF.L1_CONF
   WHERE ID <= '${lastID}'
   AND TSC_KEY IS NOT NULL
  )
  ORDER BY ID
 )
 WHERE ROWNUM = 1
 ;
 EOF
 
 exit

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