Re: diffviewer_filediff Table in DB

2016-05-06 Thread john levin
Thanks Alot David. You Saved my Time.

A colleague of mine wrote a sql quicky based on your input and we achieved 
the result.

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 
> other.
>
> 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.
>
> -David
>
> On Wed, May 4, 2016 at 6:37 AM john levin  > wrote:
>
>> Could Someone answer my question please ?
>>
>>
>> On Wednesday, May 4, 2016 at 12:39:54 PM UTC+5:30, john levin wrote:
>>>
>>> Hi,
>>>
>>> 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 !
>>>
>>> /BR
>>> John
>>>
>> -- 
>> Supercharge your Review Board with Power Pack: 
>> https://www.reviewboard.org/powerpack/
>> Want us to host Review Board for you? Check out RBCommons: 
>> https://rbcommons.com/
>> 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 
>> email to reviewboard...@googlegroups.com .
>> For more options, visit https://groups.google.com/d/optout.
>>
>

-- 
Supercharge your Review Board with Power Pack: 
https://www.reviewboard.org/powerpack/
Want us to host Review Board for you? Check out RBCommons: 
https://rbcommons.com/
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 email 
to reviewboard+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: diffviewer_filediff Table in DB

2016-05-04 Thread David Trowbridge
There are many different tables that have foreign key relations to each
other.

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.

-David

On Wed, May 4, 2016 at 6:37 AM john levin  wrote:

> Could Someone answer my question please ?
>
>
> On Wednesday, May 4, 2016 at 12:39:54 PM UTC+5:30, john levin wrote:
>>
>> Hi,
>>
>> 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 !
>>
>> /BR
>> John
>>
> --
> Supercharge your Review Board with Power Pack:
> https://www.reviewboard.org/powerpack/
> Want us to host Review Board for you? Check out RBCommons:
> https://rbcommons.com/
> 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
> email to reviewboard+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Supercharge your Review Board with Power Pack: 
https://www.reviewboard.org/powerpack/
Want us to host Review Board for you? Check out RBCommons: 
https://rbcommons.com/
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 email 
to reviewboard+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: diffviewer_filediff Table in DB

2016-05-04 Thread john levin
Could Someone answer my question please ?

On Wednesday, May 4, 2016 at 12:39:54 PM UTC+5:30, john levin wrote:
>
> Hi,
>
> 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 !
>
> /BR
> John
>

-- 
Supercharge your Review Board with Power Pack: 
https://www.reviewboard.org/powerpack/
Want us to host Review Board for you? Check out RBCommons: 
https://rbcommons.com/
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 email 
to reviewboard+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


diffviewer_filediff Table in DB

2016-05-04 Thread john levin
Hi,

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 !

/BR
John

-- 
Supercharge your Review Board with Power Pack: 
https://www.reviewboard.org/powerpack/
Want us to host Review Board for you? Check out RBCommons: 
https://rbcommons.com/
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 email 
to reviewboard+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.