| Line 171... |
Line 171... |
| 171 |
my $DM;
|
171 |
my $DM;
|
| 172 |
connectDM( \$DM );
|
172 |
connectDM( \$DM );
|
| 173 |
|
173 |
|
| 174 |
my ($m_sqlstr ) = qq /
|
174 |
my ($m_sqlstr ) = qq /
|
| 175 |
SELECT oc.prod_id, pkg.pkg_name, pv.pkg_version, pv.pv_description, pv.v_ext, pv.is_patch
|
175 |
SELECT oc.prod_id, pkg.pkg_name, pv.pkg_version, pv.pv_description, pv.v_ext, pv.is_patch
|
| - |
|
176 |
FROM deployment_manager.dm_projects dm_,
|
| - |
|
177 |
deployment_manager.branches branches,
|
| - |
|
178 |
deployment_manager.boms boms,
|
| - |
|
179 |
deployment_manager.bom_names bom,
|
| 176 |
FROM dm_projects dm_, branches branches, boms boms, bom_names bom, network_nodes net,
|
180 |
deployment_manager.network_nodes net,
|
| - |
|
181 |
deployment_manager.bom_contents bomcont,
|
| 177 |
bom_contents bomcont, operating_systems ope, os_contents oc,
|
182 |
deployment_manager.operating_systems ope,
|
| - |
|
183 |
deployment_manager.os_contents oc,
|
| 178 |
release_manager.package_versions pv, release_manager.PACKAGES pkg
|
184 |
release_manager.package_versions pv,
|
| - |
|
185 |
release_manager.PACKAGES pkg
|
| 179 |
WHERE ( (dm_.proj_id = branches.proj_id) AND (branches.branch_id = boms.branch_id) AND
|
186 |
WHERE ( (dm_.proj_id = branches.proj_id) AND (branches.branch_id = boms.branch_id) AND
|
| 180 |
(bom.bom_name_id = boms.bom_name_id) AND (boms.bom_id = bomcont.bom_id) AND
|
187 |
(bom.bom_name_id = boms.bom_name_id) AND (boms.bom_id = bomcont.bom_id) AND
|
| 181 |
(net.node_id = bomcont.node_id) AND (net.node_id = ope.node_id) AND
|
188 |
(net.node_id = bomcont.node_id) AND (net.node_id = ope.node_id) AND
|
| 182 |
(ope.os_id = oc.os_id) AND (oc.prod_id = pv.pv_id) AND (pv.pkg_id = pkg.pkg_id) AND
|
189 |
(ope.os_id = oc.os_id) AND (oc.prod_id = pv.pv_id) AND (pv.pkg_id = pkg.pkg_id) AND
|
| 183 |
(dm_.proj_name = '$G_NodeDmInfo{ProjectName}') AND
|
190 |
(dm_.proj_name = '$G_NodeDmInfo{ProjectName}') AND
|