[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





------- Additional Comments From arthur.van.dongen at tsolve.com  2007-03-09 16:08 -------
Created an attachment (id=32)
 --> (http://bugs.wpkg.org/attachment.cgi?id=32&action=view)
saveMySQL function, to be included from end of main()

The function attached writes the installed packages and versions to a database
table.

Dependencies:
* config parameters mySqlHostName, mySqlUserName and mySqlPassWord;
* SQL to create table:
CREATE TABLE IF NOT EXISTS `installed_packs` (
  `hostname` varchar(100) character set utf8 NOT NULL,
  `package_idtxt` varchar(100) character set utf8 NOT NULL,
  `version` int(10) unsigned NOT NULL,
  KEY `package_idtxt` (`package_idtxt`),
  KEY `hostname` (`hostname`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
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