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

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

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

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