[wpkg-users] [Bug 61] Feed back wpkg.xml into database so overview of installed packages can be generated

[bugzilla-daemon at wpkg.org]

Please reply using this URL only: http://bugs.wpkg.org/show_bug.cgi?id=61


arthur.van.dongen at tsolve.com changed:

           What    |Removed                     |Added

             Status|RESOLVED                    |REOPENED
         Resolution|LATER                       |




------- Additional Comments From arthur.van.dongen at tsolve.com  2007-03-09 17:20 -------
Getting the information into the wpkg_web looks feasible. 
This is the query to get the information into the hosts list:

select hosts.id as id,priority,regex,prof_id,profiles.name as name,
count(installed_packs.package_idtxt) as pack_cnt from hosts left join profiles
on ( hosts.prof_id=profiles.id ) left join installed_packs on
(installed_packs.hostname like replace(hosts.regex, '.*', '%')) group by
hosts.id order by priority

, making use of the regular expressions in MySQL to match host regex to the
installed hosts.

This is what I intend to do: 
- Add columns with the number of installed packages in the hosts, profiles and
packages overviews, using queries similar to the one above;
- When you click the count, you get a list of hosts, packages and versions
filtered on the view you had before.

-- 
Configure bugmail: http://bugs.wpkg.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA contact for the bug, or are watching the QA contact.






_______________________________________________
wpkg-users mailing list
wpkg-users at lists.wpkg.org
http://lists.wpkg.org/mailman/listinfo/wpkg-users