[Buildbot-commits] [Buildbot] #1037: Refactor builds/build_requests tables to remove duplicate rows in builds table.

[Buildbot]

#1037: Refactor builds/build_requests tables to remove duplicate rows in builds
table.
------------------------+---------------------------------------------------
Reporter:  catlee       |       Owner:       
    Type:  enhancement  |      Status:  new  
Priority:  minor        |   Milestone:  0.8.3
 Version:  0.8.1        |    Keywords:       
------------------------+---------------------------------------------------
 If you have a build that has merged more than one build request, you'll
 have one row in the builds table per build request.  Each row will be
 identical, except for the column linking back to the build request.

 This makes writing tools a bit complicated since you have to cope with the
 fact that more than one row in builds can correspond to the same single
 build on a slave.

 I think we need another table that maps builds to build requests, e.g. a
 list of (build request id, build id) tuples.  We could then drop the
 'brid' column from the builds table.

-- 
Ticket URL: <http://buildbot.net/trac/ticket/1037>
Buildbot <http://buildbot.net/>
Buildbot: build/test automation