Hi Olivier, > - Looking at daemon.conf and TestDirector back-end code, it looks that > only one QC Project can be managed by the integration daemon. Is that > correct?
[Rob] Yes, that is correct - only one Project per ScmBug instance, otherwise you'd need some form of mapping file to record which repository maps to which Test Director/Quality Center DB. > - Without speaking of Test Director back-end, what is the recommended way > of integrating many SCM repositories with many defect tracking > repositories? Multiple daemons? [Rob] We currently have several Subversion Repositories pointing to one ScmBug install that points to one Test Director DB. - My feeling is that you would need multiple Daemons. > - VDD for QC: Rob (nice to meet you :) ) investigated this and I found a > thread about it: http://lists.mkgnu.net/pipermail/scmbug-users/2007- > July/001185.html, indicating that we are in a dead end. > It is actually possible to query all defects that have been modified > between two dates, using the OTA API "Command" object (the user account > will have to have QC TDAdmin credentials in some cases). It might be > possible to do it directly from OTA BugFactory + filters - but I think > "Command" will be faster. The query will have to look at the QC AUDIT_LOG > table, to find out which defects were modified between two dates > ("History" check box must be checked for the fields that need to be > monitored). Unfortunately, this is not so simple, as the query depends on > the Database Back-end used by QC (which can be queried as part of the > tdconnection COM object). An example for Oracle back-end to query all > defects modified between 2008-08-01, 1am and 2008-08-20, 11pm: > SELECT * FROM AUDIT_LOG, AUDIT_PROPERTIES WHERE AU_ENTITY_TYPE = > 'BUG' > AND AU_TIME > TO_DATE('2008-08-01 01:00:00', 'YYYY-MM-DD > HH24:MI:SS') > AND AU_TIME < TO_DATE('2008-08-20 23:00:00', 'YYYY-MM-DD > HH24:MI:SS') > AND AU_ACTION_ID = AP_ACTION_ID [Rob] Thanks for the suggestion but doesn't this require access to the underlying DB? - We currently use the OLE interface. (BTW: I don't claim to be a QC expert - just picked up the bare minimum to implement the integration). Also getting that a bug has been modified isn't enough - we need to check that a particular formatted comment has been added. If you are able to get this sort of thing working I'm sure that Kristis would be OK to integrate it. Thanks Rob _______________________________________________ scmbug-users mailing list [email protected] http://lists.mkgnu.net/cgi-bin/mailman/listinfo/scmbug-users
