CondTools/DT/sql/o2o.sql - master - githubmirror/cmssw

CondTools/DT/sql/o2o.sql
74 строки4 KB
Giulio Eulisse
Snapshot of CMSSW_6_2_0_pre8.
26 июн 2013, 18:12
26 июн 2013, 18:12214ab73
insert into dtreadoutmapping
            (iov_value_id,cell_map_version,rob_map_version)
     values ( (select max(iov_value_id)+1 from dtreadoutmapping),
              'CMSSW_CELL','CMSSW_ROS';

insert into dtreadoutconnection
            (wheel,station,sector,superlayer,layer,cell,
             ddu,ros,rob,tdc,channel,
             connection_id,iov_value_id)
select dt_wheel_numbering.object_number,
       dt_chamber_numbering.station_number,
       dt_chamber_numbering.sector_number,
       dt_superlayer_numbering.object_number,
       dt_layer_numbering.object_number,
       dt_cell_numbering.object_number,
       dt_ddu.read_out_number,
       dt_ros.read_out_number,
       dt_ros_channel.read_out_number,
       dt_tdc.read_out_number,
       dt_tdc_channel.read_out_number,
       rownum,(select max(iov_value_id) from dtreadoutmapping)
  from dt_wheel_numbering@cmsomds       dt_wheel_numbering,
       dt_chamber_numbering@cmsomds     dt_chamber_numbering,    
       dt_superlayer_numbering@cmsomds  dt_superlayer_numbering, 
       dt_layer_numbering@cmsomds       dt_layer_numbering,      
       dt_cell_numbering@cmsomds        dt_cell_numbering,       
       dt_wheel@cmsomds                 dt_wheel,                
       dt_sector@cmsomds                dt_sector,               
       dt_chamber@cmsomds               dt_chamber,              
       dt_superlayer@cmsomds            dt_superlayer,           
       dt_layer@cmsomds                 dt_layer,                
       dt_cell@cmsomds                  dt_cell,                 
       dt_cell_readout_map@cmsomds      dt_cell_readout_map,     
       dt_tdc_channel@cmsomds           dt_tdc_channel,          
       dt_tdc@cmsomds                   dt_tdc,                  
       dt_rob@cmsomds                   dt_rob,                  
       dt_rob_ros_connection@cmsomds    dt_rob_ros_connection,   
       dt_ros_channel@cmsomds           dt_ros_channel,          
       dt_ros@cmsomds                   dt_ros,                  
       dt_ddu@cmsomds                   dt_ddu,                  
       (select numbering_id from dt_numbering_master@cmsomds
         where numbering_version='CMSSW_NUMBERING') dt_num,
       (select connection_id from dt_connection_master@cmsomds
         where connection_type='DT_CELL_READOUT_CONNECTION'
           and
        mapping_version='CMSSW_CELL') rob_con,
       (select connection_id from dt_connection_master@cmsomds
         where connection_type='DT_ROB_ROS_CONNECTION'
           and mapping_version='CMSSW_ROS') ros_con
  where dt_cell_readout_map.cell_id=dt_cell.cell_id
    and dt_cell.layer_id=dt_layer.layer_id
    and dt_layer.sl_id=dt_superlayer.sl_id
    and dt_superlayer.chamber_id=dt_chamber.chamber_id
    and dt_chamber.sector_id=dt_sector.sector_id
    and dt_sector.wheel_id=dt_wheel.wheel_id
    and dt_wheel_numbering.wheel_id=dt_wheel.wheel_id
    and dt_chamber_numbering.chamber_id=dt_chamber.chamber_id
    and dt_superlayer_numbering.sl_id=dt_superlayer.sl_id
    and dt_layer_numbering.layer_id=dt_layer.layer_id
    and dt_cell_numbering.cell_id=dt_cell.cell_id
    and dt_cell_readout_map.tdc_channel_id=dt_tdc_channel.tdc_channel_id
    and dt_tdc_channel.tdc_id=dt_tdc.tdc_id
    and dt_tdc.rob_id=dt_rob.rob_id
    and dt_rob.rob_id=dt_rob_ros_connection.rob_id
    and dt_ros_channel.ros_channel_id=dt_rob_ros_connection.ros_channel_id
    and dt_ros_channel.ros_id=dt_ros.ros_id
    and dt_ros.ddu_id=dt_ddu.ddu_id
    and dt_cell_readout_map.connection_id=rob_con.connection_id
    and dt_rob_ros_connection.connection_id=ros_con.connection_id
    and dt_wheel_numbering.numbering_id=dt_num.numbering_id
    and dt_chamber_numbering.numbering_id=dt_num.numbering_id
    and dt_superlayer_numbering.numbering_id=dt_num.numbering_id
    and dt_layer_numbering.numbering_id=dt_num.numbering_id
    and dt_cell_numbering.numbering_id=dt_num.numbering_id;