java/code/src/com/redhat/rhn/common/db/datasource/xml/System_queries.xml | 13 ---------- 1 file changed, 13 deletions(-)
New commits: commit 0578253e95c488928e5d486e665eead2a7aaf034 Author: Stephen Herr sherr@redhat.com Date: Wed Sep 19 15:06:55 2012 -0400
790120 - removing the config elaborator from a few queries where it's not needed
diff --git a/java/code/src/com/redhat/rhn/common/db/datasource/xml/System_queries.xml b/java/code/src/com/redhat/rhn/common/db/datasource/xml/System_queries.xml index a8de219..9914d3e 100644 --- a/java/code/src/com/redhat/rhn/common/db/datasource/xml/System_queries.xml +++ b/java/code/src/com/redhat/rhn/common/db/datasource/xml/System_queries.xml @@ -37,7 +37,6 @@ select * from ( ORDER BY UPPER(COALESCE(X.name, '(none)')), X.id </query> <elaborator name="system_overview" /> - <elaborator name="system_config_files_with_diffs" /> </mode>
<mode name="find_by_name" class="com.redhat.rhn.frontend.dto.SystemOverview"> @@ -52,7 +51,6 @@ ORDER BY UPPER(COALESCE(X.name, '(none)')), X.id and S.name = :name </query> <elaborator name="system_overview" /> - <elaborator name="system_config_files_with_diffs" /> </mode>
@@ -72,7 +70,6 @@ SELECT S.id, ORDER BY UPPER(COALESCE(S.NAME, '(none)')), S.ID </query> <elaborator name="system_overview" /> - <elaborator name="system_config_files_with_diffs" /> <elaborator name="is_virtual_guest" /> <elaborator name="is_virtual_host" /> </mode> @@ -101,7 +98,6 @@ SELECT DISTINCT S.id, ORDER BY UPPER(COALESCE(X.server_name, '(none)')), X.id </query> <elaborator name="system_overview" /> - <elaborator name="system_config_files_with_diffs" /> </mode>
<mode name="custom_vals"> @@ -215,7 +211,6 @@ SELECT S.id as id, ORDER BY UPPER(COALESCE(S.NAME, '(none)')), S.ID </query> <elaborator name="system_overview" /> - <elaborator name="system_config_files_with_diffs" /> </mode>
<mode name="count_systems_subscribed_to_channel"> @@ -259,7 +254,6 @@ SELECT ORDER BY UPPER(COALESCE(S.NAME, '(none)')), S.ID </query> <elaborator name="system_overview" /> - <elaborator name="system_config_files_with_diffs" /> <elaborator name="entitlements"/> </mode>
@@ -350,7 +344,6 @@ SELECT SGM.server_id AS ID, S.name AS NAME, ORDER BY UPPER(COALESCE(S.NAME, '(none)')), S.ID </query> <elaborator name="system_overview" /> - <elaborator name="system_config_files_with_diffs" /> <elaborator name="entitlements"/> </mode>
@@ -368,7 +361,6 @@ SELECT S.id, S.name, ORDER BY UPPER(COALESCE(S.NAME, '(none)')), S.ID </query> <elaborator name="system_overview" /> - <elaborator name="system_config_files_with_diffs" /> <elaborator name="entitlements"/> </mode>
@@ -386,7 +378,6 @@ SELECT S.id, S.name ORDER BY UPPER(COALESCE(S.NAME, '(none)')), S.ID </query> <elaborator name="system_overview" /> - <elaborator name="system_config_files_with_diffs" /> </mode>
<mode name="systems_with_needed_package" class="com.redhat.rhn.frontend.dto.SystemOverview"> @@ -400,7 +391,6 @@ SELECT S.ID ORDER BY UPPER(COALESCE(S.NAME, '(none)')), S.ID </query> <elaborator name="system_overview" /> - <elaborator name="system_config_files_with_diffs" /> </mode>
<mode name="target_systems_for_channel" class="com.redhat.rhn.frontend.dto.SystemOverview"> @@ -419,7 +409,6 @@ SELECT ES.id, S.name, 1 as selectable AND EXISTS (SELECT 1 FROM rhnUserServerPerms USP WHERE USP.user_id = :user_id AND USP.server_id = ES.id) </query> <elaborator name="system_overview" /> - <elaborator name="system_config_files_with_diffs" /> <elaborator name="entitlements"/> </mode>
@@ -581,7 +570,6 @@ where a.user_id = :formvar_uid ORDER BY UPPER(COALESCE(S.name, '(none)')), S.id </query> <elaborator name="system_overview" /> - <elaborator name="system_config_files_with_diffs" /> <elaborator name="entitlements" /> </mode>
@@ -636,7 +624,6 @@ SELECT SA.server_id as id, WHERE errata_id = :eid) </elaborator> <elaborator name="system_overview" /> - <elaborator name="system_config_files_with_diffs" /> <elaborator name="entitlements" /> </mode>
spacewalk-commits@lists.fedorahosted.org