File indexing completed on 2023-03-17 10:47:47
0001 insert into dtreadoutmapping
0002 (iov_value_id,cell_map_version,rob_map_version)
0003 values ( (select max(iov_value_id)+1 from dtreadoutmapping),
0004 'CMSSW_CELL','CMSSW_ROS';
0005
0006 insert into dtreadoutconnection
0007 (wheel,station,sector,superlayer,layer,cell,
0008 ddu,ros,rob,tdc,channel,
0009 connection_id,iov_value_id)
0010 select dt_wheel_numbering.object_number,
0011 dt_chamber_numbering.station_number,
0012 dt_chamber_numbering.sector_number,
0013 dt_superlayer_numbering.object_number,
0014 dt_layer_numbering.object_number,
0015 dt_cell_numbering.object_number,
0016 dt_ddu.read_out_number,
0017 dt_ros.read_out_number,
0018 dt_ros_channel.read_out_number,
0019 dt_tdc.read_out_number,
0020 dt_tdc_channel.read_out_number,
0021 rownum,(select max(iov_value_id) from dtreadoutmapping)
0022 from dt_wheel_numbering@cmsomds dt_wheel_numbering,
0023 dt_chamber_numbering@cmsomds dt_chamber_numbering,
0024 dt_superlayer_numbering@cmsomds dt_superlayer_numbering,
0025 dt_layer_numbering@cmsomds dt_layer_numbering,
0026 dt_cell_numbering@cmsomds dt_cell_numbering,
0027 dt_wheel@cmsomds dt_wheel,
0028 dt_sector@cmsomds dt_sector,
0029 dt_chamber@cmsomds dt_chamber,
0030 dt_superlayer@cmsomds dt_superlayer,
0031 dt_layer@cmsomds dt_layer,
0032 dt_cell@cmsomds dt_cell,
0033 dt_cell_readout_map@cmsomds dt_cell_readout_map,
0034 dt_tdc_channel@cmsomds dt_tdc_channel,
0035 dt_tdc@cmsomds dt_tdc,
0036 dt_rob@cmsomds dt_rob,
0037 dt_rob_ros_connection@cmsomds dt_rob_ros_connection,
0038 dt_ros_channel@cmsomds dt_ros_channel,
0039 dt_ros@cmsomds dt_ros,
0040 dt_ddu@cmsomds dt_ddu,
0041 (select numbering_id from dt_numbering_master@cmsomds
0042 where numbering_version='CMSSW_NUMBERING') dt_num,
0043 (select connection_id from dt_connection_master@cmsomds
0044 where connection_type='DT_CELL_READOUT_CONNECTION'
0045 and
0046 mapping_version='CMSSW_CELL') rob_con,
0047 (select connection_id from dt_connection_master@cmsomds
0048 where connection_type='DT_ROB_ROS_CONNECTION'
0049 and mapping_version='CMSSW_ROS') ros_con
0050 where dt_cell_readout_map.cell_id=dt_cell.cell_id
0051 and dt_cell.layer_id=dt_layer.layer_id
0052 and dt_layer.sl_id=dt_superlayer.sl_id
0053 and dt_superlayer.chamber_id=dt_chamber.chamber_id
0054 and dt_chamber.sector_id=dt_sector.sector_id
0055 and dt_sector.wheel_id=dt_wheel.wheel_id
0056 and dt_wheel_numbering.wheel_id=dt_wheel.wheel_id
0057 and dt_chamber_numbering.chamber_id=dt_chamber.chamber_id
0058 and dt_superlayer_numbering.sl_id=dt_superlayer.sl_id
0059 and dt_layer_numbering.layer_id=dt_layer.layer_id
0060 and dt_cell_numbering.cell_id=dt_cell.cell_id
0061 and dt_cell_readout_map.tdc_channel_id=dt_tdc_channel.tdc_channel_id
0062 and dt_tdc_channel.tdc_id=dt_tdc.tdc_id
0063 and dt_tdc.rob_id=dt_rob.rob_id
0064 and dt_rob.rob_id=dt_rob_ros_connection.rob_id
0065 and dt_ros_channel.ros_channel_id=dt_rob_ros_connection.ros_channel_id
0066 and dt_ros_channel.ros_id=dt_ros.ros_id
0067 and dt_ros.ddu_id=dt_ddu.ddu_id
0068 and dt_cell_readout_map.connection_id=rob_con.connection_id
0069 and dt_rob_ros_connection.connection_id=ros_con.connection_id
0070 and dt_wheel_numbering.numbering_id=dt_num.numbering_id
0071 and dt_chamber_numbering.numbering_id=dt_num.numbering_id
0072 and dt_superlayer_numbering.numbering_id=dt_num.numbering_id
0073 and dt_layer_numbering.numbering_id=dt_num.numbering_id
0074 and dt_cell_numbering.numbering_id=dt_num.numbering_id;
