Help on Command Line interface

Help on Command Line interface

Postby lordneeko » Fri 19 Dec 2014 17:09

We are evaluating this tool for organizational wide deployment.

We have organizational tools which we are required to populate with Peer Review data (for CMMI Level 5).

I want to be able to produce some of that data simply by querying the reviewassistant database, extracting it to XML, and then uploading it to the Org's tools.

Basically I want to be able to extract the data that is available in the reports, but that doesn't seem possible.

Please help with this.

Also, CMMI requires you to track the time spent by each reviewer performing the review, the time it took an author to make corrections, and other metrics like that.

Does Review Assistant capture any of this data? Even if it doesn't capture elapsed time, if I can extract through query Time Stamps of when events happen (Like time stamp when the Reviewer marks the review as "Complete") then I could generate this data myself.

Thanks.
lordneeko
 
Posts: 26
Joined: Fri 19 Dec 2014 16:58

Re: Help on Command Line interface

Postby AlexeyN » Mon 22 Dec 2014 12:19

I suggest you to use Review Assistant command line.

For example, you can query every minute for all changed reviews. So, you will have data to start tracking reviews. The command string shluld look like this:

Code: Select all
ra reviews /l=Admin /pw=password /s=http://reviewassistant.local:85/ReviewAssistant ms=1m /verbose


Read here about 'reviews' command.

As an alternative, you may look at the 'LogEntries' table at the Review Assistant database, which stores all review changes. That feature is undocumented, syntax is complicated and I can't guarantee, that syntax will stay invariable at the future.

Please review and vote for the following topics at our Uservoice or create your own:
http://devart.uservoice.com/forums/145340-review-assistant/suggestions/4761646-ability-to-export-get-a-report-on-a-code-review
http://devart.uservoice.com/forums/145340-review-assistant/suggestions/6425062-create-an-api-to-view-statistics-reviews-issues
AlexeyN
Devart Team
 
Posts: 244
Joined: Wed 12 Sep 2012 12:09

Re: Help on Command Line interface

Postby lordneeko » Thu 25 Dec 2014 21:35

This doesn't really help though. The returned information doesn't even show the comments that are in the database, just the number of comments on a particular review. We need to be able to pull all this information out for audits. There is currently not way to extract all the date about a review to give to QA.

All this data should be available and able to be queried... It's just a MySQL database right?
lordneeko
 
Posts: 26
Joined: Fri 19 Dec 2014 16:58

Re: Help on Command Line interface

Postby AlexeyN » Fri 26 Dec 2014 11:02

Now we are working at that feature. We want to do some kind of printable reports that will look like http://1drv.ms/1AaOnJj. Please send to us your thoughts about that feature.

Review Assistant uses SQLite database.
AlexeyN
Devart Team
 
Posts: 244
Joined: Wed 12 Sep 2012 12:09

Re: Help on Command Line interface

Postby lordneeko » Sat 27 Dec 2014 02:45

That looks great! And is acceptable. I'd still like the ability to query it out of the database in XML like is already available so we can format the date as we want. But I'll gladly take your solution.

Thanks! Time frame?
lordneeko
 
Posts: 26
Joined: Fri 19 Dec 2014 16:58

Re: Help on Command Line interface

Postby AlexeyN » Tue 30 Dec 2014 11:56

We plan to release Review Assistant with that feature in next two months.
AlexeyN
Devart Team
 
Posts: 244
Joined: Wed 12 Sep 2012 12:09

Re: Help on Command Line interface

Postby lordneeko » Tue 03 Mar 2015 16:22

Was this implemented?
lordneeko
 
Posts: 26
Joined: Fri 19 Dec 2014 16:58

Re: Help on Command Line interface

Postby AlexeyN » Wed 04 Mar 2015 12:56

Yes, it was implemented. The release was scheduled for the middle of this month.
AlexeyN
Devart Team
 
Posts: 244
Joined: Wed 12 Sep 2012 12:09

Re: Help on Command Line interface

Postby lordneeko » Wed 04 Mar 2015 16:04

Excellent Thank you,.
lordneeko
 
Posts: 26
Joined: Fri 19 Dec 2014 16:58


Return to Review Assistant