Thanks Alot David. You Saved my Time.
A colleague of mine wrote a sql quicky based on your input and we achieved
select D.id,D.status,A.source_file from diffviewer_filediff A ,
diffviewer_diffset B , diffviewer_diffsethistory C,reviews_reviewrequest D
where A.diffset_id = B.id and B.history_id = C.ID and D.diffset_history_id
= C.id and D.id = 57; (57 is the review id)
On Thursday, May 5, 2016 at 5:59:06 AM UTC+5:30, David Trowbridge wrote:
> There are many different tables that have foreign key relations to each
> The FileDiff has a foreign key to DiffSet, which represents a single
> revision of a diff on a review request. DiffSet in turn has a foreign key
> to DiffSetHistory, which is all revisions. The ReviewRequest model has a
> foreign key to DiffSetHistory (a 1:1 relationship).
> Therefore, if you want to relate a FileDiff to its ReviewRequest, you'll
> have to join all the relevant tables together.
> On Wed, May 4, 2016 at 6:37 AM john levin <smart...@gmail.com
>> Could Someone answer my question please ?
>> On Wednesday, May 4, 2016 at 12:39:54 PM UTC+5:30, john levin wrote:
>>> I could see that diffviewer_filediff Table doesnt Holds the review id
>>> rather the id is incremental mode whenever the change is happens. So i'm
>>> Wondering how to Map the Filelist with particular review ID. Any Idea ?
>>> Note :- I dont have an idea about django, so connecting the DB directly
>>> to validate some informations.
>>> Thanks !
>> Supercharge your Review Board with Power Pack:
>> Want us to host Review Board for you? Check out RBCommons:
>> Happy user? Let us know! https://www.reviewboard.org/users/
>> You received this message because you are subscribed to the Google Groups
>> "reviewboard" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> For more options, visit https://groups.google.com/d/optout.
Supercharge your Review Board with Power Pack:
Want us to host Review Board for you? Check out RBCommons:
Happy user? Let us know! https://www.reviewboard.org/users/
You received this message because you are subscribed to the Google Groups
To unsubscribe from this group and stop receiving emails from it, send an email
For more options, visit https://groups.google.com/d/optout.