JSPGui (L1 trigger key configurator)

• production system: runs at http://cmsrc-trigger.cms:19000/jspgui/
• tomcat's webapp dir (on cmsrc-trigger.cms): /opt/rcms/triggerpro/tomcat/webapps
• Tomcat manager: here (login required)

Runregistry

• YUI table example in CMS: http://cmsmon.cern.ch/runregistry/ (uses yui 2.5.2 at the time of the writing)
• Example XML data transfer to fill the table

YUI

• YUI datatable documentation
• DataTable Control (beta): Showing, Hiding, and Reordering Columns
• XML data example

ORACLE database

• import/export FAQ
• LHCb notes on database dumps
• To create a tunnel for squirrelsql, see here
• main table: CMS_TRG_L1_CONF.TRIGGERSUP_CONF.
• creating the sequence for global trigger key numbers:

CREATE SEQUENCE global_key_seq
        MINVALUE 1
        START WITH 1
        INCREMENT BY 1
        NOCACHE
        ;

• creating the data taking period table:

CREATE TABLE RUNTYPE
(
   NAME varchar2(128) PRIMARY KEY NOT NULL
);

• adding the data taking period into the global TS configuration table:

ALTER TABLE CMS_TRG_L1_CONF.TRIGGERSUP_CONF ADD RUNTYPE varchar2(128);

ALTER TABLE CMS_TRG_L1_CONF.TRIGGERSUP_CONF
ADD CONSTRAINT FK_RUNTYPE
FOREIGN KEY (RUNTYPE)
REFERENCES RUNTYPE(NAME) ;

• adding the column LAST_MADE_CURRENT_DATE:

ALTER TABLE CMS_TRG_L1_CONF.TRIGGERSUP_CONF ADD  (LAST_MADE_CURRENT_DATE timestamp default NULL);

-- AndreHolzner - 12 Jul 2008