/
githubmirror
/
cmssw
Обзор
Документация
Войти
/
githubmirror
/
cmssw
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
CondTools/L1Trigger/scripts/getNextTscKeyByID.sh
39 строк
694 B
Giulio Eulisse
Snapshot of CMSSW_6_2_0_pre8.
26 июн 2013, 18:12
26 июн 2013, 18:12
214ab73
Код
Авторство
О чём код?
#!/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