Agreed. As long as all this is added as a comment to bug 895. Perhaps
you could email the Test Director people to let them know of the
substandard database schema. Only if they fix their schema would you be
able to implement the VDD functionality.

Nothing is easy for you Robert with TestDirector, huh ?

On Thu, 2007-07-19 at 01:00 -0700, Robert Hudson wrote:
> > >
> > > I’m guessing that it is doing a select between two dates when comments
> > > were added to a Bugzilla Bug?
> > >
> > >
> > >
> > > Is this correct?
> > 
> > Yes, this is correct.
> 
> That is what I thought.  I don't think we can implement this for Test 
> Director.  In order to add support for Test Director we could only append to 
> an existing field (Test Director does not store each comment in a separate 
> row, it's all in one block).  Added to this the date format that Test 
> Director uses:
> 
> ----- snip -------
> rhudson (Wed Jul 18 17:20:17 2007) : Pre Course 3 Commit
> 
> 
> Branch:        trunk
> Affected files:
> ---------------
> 77972 --> 77974 none:trunk/wqs/ccacherec.cpp
> ----- snip -------
> 
> I don't think there is a sensible search that we can do without parsing all 
> the Bugs (Of which there are over 30,000)
> 
> Please can we add something along the lines of the following to the 
> TestDirector.pm integration_get_vdd function body:
> 
> ----- snip -------
> # VDD is generated using a start and end date.
> # Unfortunately Test Director stores all the file history in
> # one memo field and stores the date within this text in the
> # format:
> #   username (Wed Jul 18 17:20:17 2007) :
> # This means to generate the VDD information it would be required
> # to retrieve every bug, split the file history memo field up into
> # commit segments and then parse each segment trying to match the
> # date. (Note: the Test Director interface does not have direct
> # access to the database)
> #
> # This will take a very long time even if there were a small number
> # of bugs to process, and by the time you start getting into the
> # thousands it will be unmanageable.
> #
> # It is for this reason that VDD has not been implemented for the
> # Test Director system.
> ----- snip -------
> 
> I think this will clarify the problems and explain to anyone using the 
> interface why it hasn't been supported. (and remind me so I don't investigate 
> it again)
> 
> Thanks
> 
> Rob
> 

Attachment: signature.asc
Description: This is a digitally signed message part

_______________________________________________
scmbug-users mailing list
[email protected]
http://lists.mkgnu.net/cgi-bin/mailman/listinfo/scmbug-users

Reply via email to