|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
|
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;
|