def test_getBuildslave_multiple_connections(self):
yield self.insertTestData(self.baseRows + [
# the slave is connected to two masters at once.
# weird, but the DB should represent it.
fakedb.Buildslave(id=32, name='two'),
fakedb.ConnectedBuildslave(buildslaveid=32, masterid=10),
fakedb.ConnectedBuildslave(buildslaveid=32, masterid=11),
fakedb.BuilderMaster(id=24, builderid=20, masterid=10),
fakedb.BuilderMaster(id=25, builderid=20, masterid=11),
fakedb.ConfiguredBuildslave(buildslaveid=32, buildermasterid=24),
fakedb.ConfiguredBuildslave(buildslaveid=32, buildermasterid=25),
])
slavedict = yield self.db.buildslaves.getBuildslave(buildslaveid=32)
validation.verifyDbDict(self, 'buildslavedict', slavedict)
self.assertEqual(
slavedict,
dict(id=32,
name='two',
slaveinfo={'a': 'b'},
connected_to=[10, 11],
configured_on=[
{
'builderid': 20,
'masterid': 10
},
{
'builderid': 20,
'masterid': 11
},
]))
def test_buildslaveDisconnected(self):
yield self.insertTestData(self.baseRows + self.buildslave1_rows + [
fakedb.ConnectedBuildslave(id=888,
buildslaveid=self.BS1_ID, masterid=10),
fakedb.ConnectedBuildslave(id=889,
buildslaveid=self.BS1_ID, masterid=11),
])
yield self.db.buildslaves.buildslaveDisconnected(
buildslaveid=self.BS1_ID, masterid=11)
bs = yield self.db.buildslaves.getBuildslave(self.BS1_ID)
self.assertEqual(bs['connected_to'], [10])
def test_buildslaveConnected_already_connected(self):
yield self.insertTestData(self.baseRows + self.buildslave1_rows + [
fakedb.ConnectedBuildslave(id=888,
buildslaveid=self.BS1_ID, masterid=11),
])
yield self.db.buildslaves.buildslaveConnected(
buildslaveid=self.BS1_ID, masterid=11, slaveinfo={})
bs = yield self.db.buildslaves.getBuildslave(self.BS1_ID)
self.assertEqual(bs['connected_to'], [11])
def test_command_list_builders_connected(self):
self.setup_multi_builders()
# Also set the connectedness:
self.master.db.insertTestData(
[fakedb.ConnectedBuildslave(id=113, masterid=13, buildslaveid=1)])
yield self.do_test_command('list', args='builders')
self.assertEqual(len(self.sent), 1)
self.assertIn('%s [offline]' % self.BUILDER_NAMES[0], self.sent[0])
self.assertNotIn('%s [offline]' % self.BUILDER_NAMES[1], self.sent[0])
def test_getBuildslave_connected_not_configured(self):
yield self.insertTestData(self.baseRows + [
# the slave is connected to this master, but not configured.
# weird, but the DB should represent it.
fakedb.Buildslave(id=32, name='two'),
fakedb.ConnectedBuildslave(buildslaveid=32, masterid=11),
])
slavedict = yield self.db.buildslaves.getBuildslave(buildslaveid=32)
validation.verifyDbDict(self, 'buildslavedict', slavedict)
self.assertEqual(slavedict,
dict(id=32, name='two', slaveinfo={'a': 'b'},
connected_to=[11], configured_on=[]))
def test_getBuildslave_connected(self):
yield self.insertTestData(self.baseRows + [
fakedb.BuilderMaster(id=12, builderid=20, masterid=10),
fakedb.ConfiguredBuildslave(buildslaveid=30, buildermasterid=12),
fakedb.ConnectedBuildslave(buildslaveid=30, masterid=10),
])
slavedict = yield self.db.buildslaves.getBuildslave(buildslaveid=30)
validation.verifyDbDict(self, 'buildslavedict', slavedict)
self.assertEqual(slavedict,
dict(id=30, name='zero', slaveinfo={'a': 'b'},
configured_on=[
{'masterid': 10, 'builderid': 20}],
connected_to=[10]))
class Tests(interfaces.InterfaceTests):
# common sample data
baseRows = [
fakedb.Master(id=10, name='m10'),
fakedb.Master(id=11, name='m11'),
fakedb.Builder(id=20, name=u'a'),
fakedb.Builder(id=21, name=u'b'),
fakedb.Builder(id=22, name=u'c'),
fakedb.Buildslave(id=30, name='zero'),
fakedb.Buildslave(id=31, name='one'),
]
multipleMasters = [
fakedb.BuilderMaster(id=12, builderid=20, masterid=10),
fakedb.BuilderMaster(id=13, builderid=21, masterid=10),
fakedb.BuilderMaster(id=14, builderid=20, masterid=11),
fakedb.BuilderMaster(id=15, builderid=22, masterid=11),
fakedb.BuilderMaster(id=16, builderid=22, masterid=10),
fakedb.ConfiguredBuildslave(
id=3012, buildslaveid=30, buildermasterid=12),
fakedb.ConfiguredBuildslave(
id=3013, buildslaveid=30, buildermasterid=13),
fakedb.ConfiguredBuildslave(
id=3014, buildslaveid=30, buildermasterid=14),
fakedb.ConfiguredBuildslave(
id=3114, buildslaveid=31, buildermasterid=14),
fakedb.ConfiguredBuildslave(
id=3115, buildslaveid=31, buildermasterid=15),
fakedb.ConnectedBuildslave(id=3010, buildslaveid=30, masterid=10),
fakedb.ConnectedBuildslave(id=3111, buildslaveid=31, masterid=11),
]
# sample buildslave data, with id's avoiding the postgres id sequence
BOGUS_NAME = 'bogus'
BS1_NAME, BS1_ID, BS1_INFO = 'bs1', 100, {'a': 1}
buildslave1_rows = [
fakedb.Buildslave(id=BS1_ID, name=BS1_NAME, info=BS1_INFO),
]
BS2_NAME, BS2_ID, BS2_INFO = 'bs2', 200, {'a': 1, 'b': 2}
buildslave2_rows = [
fakedb.Buildslave(id=BS2_ID, name=BS2_NAME, info=BS2_INFO),
]
# tests
def test_signature_findBuildslaveId(self):
@self.assertArgSpecMatches(self.db.buildslaves.findBuildslaveId)
def findBuildslaveId(self, name):
pass
def test_signature_getBuildslave(self):
@self.assertArgSpecMatches(self.db.buildslaves.getBuildslave)
def getBuildslave(self, buildslaveid=None, name=None,
masterid=None, builderid=None):
pass
def test_signature_getBuildslaves(self):
@self.assertArgSpecMatches(self.db.buildslaves.getBuildslaves)
def getBuildslaves(self, masterid=None, builderid=None):
pass
def test_signature_buildslaveConnected(self):
@self.assertArgSpecMatches(self.db.buildslaves.buildslaveConnected)
def buildslaveConnected(self, buildslaveid, masterid, slaveinfo):
pass
def test_signature_buildslaveDisconnected(self):
@self.assertArgSpecMatches(self.db.buildslaves.buildslaveDisconnected)
def buildslaveDisconnected(self, buildslaveid, masterid):
pass
def test_signature_buildslaveConfigured(self):
@self.assertArgSpecMatches(self.db.buildslaves.buildslaveConfigured)
def buildslaveConfigured(self, buildslaveid, masterid, builderids):
pass
def test_signature_deconfigureAllBuidslavesForMaster(self):
@self.assertArgSpecMatches(self.db.buildslaves.deconfigureAllBuidslavesForMaster)
def deconfigureAllBuidslavesForMaster(self, masterid):
pass
@defer.inlineCallbacks
def test_findBuildslaveId_insert(self):
id = yield self.db.buildslaves.findBuildslaveId(name=u"xyz")
bslave = yield self.db.buildslaves.getBuildslave(buildslaveid=id)
self.assertEqual(bslave['name'], 'xyz')
self.assertEqual(bslave['slaveinfo'], {})
@defer.inlineCallbacks
def test_findBuildslaveId_existing(self):
yield self.insertTestData(self.baseRows)
id = yield self.db.buildslaves.findBuildslaveId(name=u"one")
self.assertEqual(id, 31)
@defer.inlineCallbacks
def test_getBuildslave_no_such(self):
yield self.insertTestData(self.baseRows)
slavedict = yield self.db.buildslaves.getBuildslave(buildslaveid=99)
self.assertEqual(slavedict, None)
@defer.inlineCallbacks
def test_getBuildslave_by_name_no_such(self):
yield self.insertTestData(self.baseRows)
slavedict = yield self.db.buildslaves.getBuildslave(name='NOSUCH')
self.assertEqual(slavedict, None)
@defer.inlineCallbacks
def test_getBuildslave_not_configured(self):
yield self.insertTestData(self.baseRows)
slavedict = yield self.db.buildslaves.getBuildslave(buildslaveid=30)
validation.verifyDbDict(self, 'buildslavedict', slavedict)
self.assertEqual(slavedict,
dict(id=30, name='zero', slaveinfo={'a': 'b'},
connected_to=[], configured_on=[]))
@defer.inlineCallbacks
def test_getBuildslave_connected_not_configured(self):
yield self.insertTestData(self.baseRows + [
# the slave is connected to this master, but not configured.
# weird, but the DB should represent it.
fakedb.Buildslave(id=32, name='two'),
fakedb.ConnectedBuildslave(buildslaveid=32, masterid=11),
])
slavedict = yield self.db.buildslaves.getBuildslave(buildslaveid=32)
validation.verifyDbDict(self, 'buildslavedict', slavedict)
self.assertEqual(slavedict,
dict(id=32, name='two', slaveinfo={'a': 'b'},
connected_to=[11], configured_on=[]))
@defer.inlineCallbacks
def test_getBuildslave_multiple_connections(self):
yield self.insertTestData(self.baseRows + [
# the slave is connected to two masters at once.
# weird, but the DB should represent it.
fakedb.Buildslave(id=32, name='two'),
fakedb.ConnectedBuildslave(buildslaveid=32, masterid=10),
fakedb.ConnectedBuildslave(buildslaveid=32, masterid=11),
fakedb.BuilderMaster(id=24, builderid=20, masterid=10),
fakedb.BuilderMaster(id=25, builderid=20, masterid=11),
fakedb.ConfiguredBuildslave(buildslaveid=32, buildermasterid=24),
fakedb.ConfiguredBuildslave(buildslaveid=32, buildermasterid=25),
])
slavedict = yield self.db.buildslaves.getBuildslave(buildslaveid=32)
validation.verifyDbDict(self, 'buildslavedict', slavedict)
self.assertEqual(slavedict,
dict(id=32, name='two', slaveinfo={'a': 'b'},
connected_to=[10, 11], configured_on=[
{'builderid': 20, 'masterid': 10},
{'builderid': 20, 'masterid': 11},
]))
@defer.inlineCallbacks
def test_getBuildslave_by_name_not_configured(self):
yield self.insertTestData(self.baseRows)
slavedict = yield self.db.buildslaves.getBuildslave(name='zero')
validation.verifyDbDict(self, 'buildslavedict', slavedict)
self.assertEqual(slavedict,
dict(id=30, name='zero', slaveinfo={'a': 'b'},
connected_to=[], configured_on=[]))
@defer.inlineCallbacks
def test_getBuildslave_not_connected(self):
yield self.insertTestData(self.baseRows + [
fakedb.BuilderMaster(id=12, builderid=20, masterid=10),
fakedb.ConfiguredBuildslave(buildslaveid=30, buildermasterid=12),
])
slavedict = yield self.db.buildslaves.getBuildslave(buildslaveid=30)
validation.verifyDbDict(self, 'buildslavedict', slavedict)
self.assertEqual(slavedict,
dict(id=30, name='zero', slaveinfo={'a': 'b'},
configured_on=[
{'masterid': 10, 'builderid': 20}],
connected_to=[]))
@defer.inlineCallbacks
def test_getBuildslave_connected(self):
yield self.insertTestData(self.baseRows + [
fakedb.BuilderMaster(id=12, builderid=20, masterid=10),
fakedb.ConfiguredBuildslave(buildslaveid=30, buildermasterid=12),
fakedb.ConnectedBuildslave(buildslaveid=30, masterid=10),
])
slavedict = yield self.db.buildslaves.getBuildslave(buildslaveid=30)
validation.verifyDbDict(self, 'buildslavedict', slavedict)
self.assertEqual(slavedict,
dict(id=30, name='zero', slaveinfo={'a': 'b'},
configured_on=[
{'masterid': 10, 'builderid': 20}],
connected_to=[10]))
@defer.inlineCallbacks
def test_getBuildslave_with_multiple_masters(self):
yield self.insertTestData(self.baseRows + self.multipleMasters)
slavedict = yield self.db.buildslaves.getBuildslave(buildslaveid=30)
validation.verifyDbDict(self, 'buildslavedict', slavedict)
slavedict['configured_on'].sort()
self.assertEqual(slavedict,
dict(id=30, name='zero', slaveinfo={'a': 'b'},
configured_on=sorted([
{'masterid': 10, 'builderid': 20},
{'masterid': 10, 'builderid': 21},
{'masterid': 11, 'builderid': 20},
]), connected_to=[10]))
@defer.inlineCallbacks
def test_getBuildslave_with_multiple_masters_builderid(self):
yield self.insertTestData(self.baseRows + self.multipleMasters)
slavedict = yield self.db.buildslaves.getBuildslave(buildslaveid=30, builderid=20)
validation.verifyDbDict(self, 'buildslavedict', slavedict)
slavedict['configured_on'].sort()
self.assertEqual(slavedict,
dict(id=30, name='zero', slaveinfo={'a': 'b'},
configured_on=sorted([
{'masterid': 10, 'builderid': 20},
{'masterid': 11, 'builderid': 20},
]), connected_to=[10]))
@defer.inlineCallbacks
def test_getBuildslave_with_multiple_masters_masterid(self):
yield self.insertTestData(self.baseRows + self.multipleMasters)
slavedict = yield self.db.buildslaves.getBuildslave(buildslaveid=30, masterid=11)
validation.verifyDbDict(self, 'buildslavedict', slavedict)
self.assertEqual(slavedict,
dict(id=30, name='zero', slaveinfo={'a': 'b'},
configured_on=[
{'masterid': 11, 'builderid': 20},
], connected_to=[]))
@defer.inlineCallbacks
def test_getBuildslave_with_multiple_masters_builderid_masterid(self):
yield self.insertTestData(self.baseRows + self.multipleMasters)
slavedict = yield self.db.buildslaves.getBuildslave(buildslaveid=30,
builderid=20, masterid=11)
validation.verifyDbDict(self, 'buildslavedict', slavedict)
self.assertEqual(slavedict,
dict(id=30, name='zero', slaveinfo={'a': 'b'},
configured_on=[
{'masterid': 11, 'builderid': 20},
], connected_to=[]))
@defer.inlineCallbacks
def test_getBuildslave_by_name_with_multiple_masters_builderid_masterid(self):
yield self.insertTestData(self.baseRows + self.multipleMasters)
slavedict = yield self.db.buildslaves.getBuildslave(name='zero',
builderid=20, masterid=11)
validation.verifyDbDict(self, 'buildslavedict', slavedict)
self.assertEqual(slavedict,
dict(id=30, name='zero', slaveinfo={'a': 'b'},
configured_on=[
{'masterid': 11, 'builderid': 20},
], connected_to=[]))
@defer.inlineCallbacks
def test_getBuildslaves_no_config(self):
yield self.insertTestData(self.baseRows)
slavedicts = yield self.db.buildslaves.getBuildslaves()
[validation.verifyDbDict(self, 'buildslavedict', slavedict)
for slavedict in slavedicts]
self.assertEqual(sorted(slavedicts), sorted([
dict(id=30, name='zero', slaveinfo={'a': 'b'},
configured_on=[], connected_to=[]),
dict(id=31, name='one', slaveinfo={'a': 'b'},
configured_on=[], connected_to=[]),
]))
@defer.inlineCallbacks
def test_getBuildslaves_with_config(self):
yield self.insertTestData(self.baseRows + self.multipleMasters)
slavedicts = yield self.db.buildslaves.getBuildslaves()
for slavedict in slavedicts:
validation.verifyDbDict(self, 'buildslavedict', slavedict)
slavedict['configured_on'].sort()
self.assertEqual(sorted(slavedicts), sorted([
dict(id=30, name='zero', slaveinfo={'a': 'b'},
configured_on=sorted([
{'masterid': 10, 'builderid': 20},
{'masterid': 10, 'builderid': 21},
{'masterid': 11, 'builderid': 20},
]), connected_to=[10]),
dict(id=31, name='one', slaveinfo={'a': 'b'},
configured_on=sorted([
{'masterid': 11, 'builderid': 20},
{'masterid': 11, 'builderid': 22},
]), connected_to=[11]),
]))
@defer.inlineCallbacks
def test_getBuildslaves_empty(self):
yield self.insertTestData(self.baseRows + self.multipleMasters)
slavedicts = yield self.db.buildslaves.getBuildslaves(masterid=11, builderid=21)
for slavedict in slavedicts:
validation.verifyDbDict(self, 'buildslavedict', slavedict)
slavedict['configured_on'].sort()
self.assertEqual(sorted(slavedicts), [])
@defer.inlineCallbacks
def test_getBuildslaves_with_config_builderid(self):
yield self.insertTestData(self.baseRows + self.multipleMasters)
slavedicts = yield self.db.buildslaves.getBuildslaves(builderid=20)
for slavedict in slavedicts:
validation.verifyDbDict(self, 'buildslavedict', slavedict)
slavedict['configured_on'].sort()
self.assertEqual(sorted(slavedicts), sorted([
dict(id=30, name='zero', slaveinfo={'a': 'b'},
configured_on=sorted([
{'masterid': 10, 'builderid': 20},
{'masterid': 11, 'builderid': 20},
]), connected_to=[10]),
dict(id=31, name='one', slaveinfo={'a': 'b'},
configured_on=sorted([
{'masterid': 11, 'builderid': 20},
]), connected_to=[11]),
]))
@defer.inlineCallbacks
def test_getBuildslaves_with_config_masterid_10(self):
yield self.insertTestData(self.baseRows + self.multipleMasters)
slavedicts = yield self.db.buildslaves.getBuildslaves(masterid=10)
for slavedict in slavedicts:
validation.verifyDbDict(self, 'buildslavedict', slavedict)
slavedict['configured_on'].sort()
self.assertEqual(sorted(slavedicts), sorted([
dict(id=30, name='zero', slaveinfo={'a': 'b'},
configured_on=sorted([
{'masterid': 10, 'builderid': 20},
{'masterid': 10, 'builderid': 21},
]), connected_to=[10]),
]))
@defer.inlineCallbacks
def test_getBuildslaves_with_config_masterid_11(self):
yield self.insertTestData(self.baseRows + self.multipleMasters)
slavedicts = yield self.db.buildslaves.getBuildslaves(masterid=11)
for slavedict in slavedicts:
validation.verifyDbDict(self, 'buildslavedict', slavedict)
slavedict['configured_on'].sort()
self.assertEqual(sorted(slavedicts), sorted([
dict(id=30, name='zero', slaveinfo={'a': 'b'},
configured_on=sorted([
{'masterid': 11, 'builderid': 20},
]), connected_to=[]),
dict(id=31, name='one', slaveinfo={'a': 'b'},
configured_on=sorted([
{'masterid': 11, 'builderid': 20},
{'masterid': 11, 'builderid': 22},
]), connected_to=[11]),
]))
@defer.inlineCallbacks
def test_getBuildslaves_with_config_masterid_11_builderid_22(self):
yield self.insertTestData(self.baseRows + self.multipleMasters)
slavedicts = yield self.db.buildslaves.getBuildslaves(
masterid=11, builderid=22)
for slavedict in slavedicts:
validation.verifyDbDict(self, 'buildslavedict', slavedict)
slavedict['configured_on'].sort()
self.assertEqual(sorted(slavedicts), sorted([
dict(id=31, name='one', slaveinfo={'a': 'b'},
configured_on=sorted([
{'masterid': 11, 'builderid': 22},
]), connected_to=[11]),
]))
@defer.inlineCallbacks
def test_buildslaveConnected_existing(self):
yield self.insertTestData(self.baseRows + self.buildslave1_rows)
NEW_INFO = {'other': [1, 2, 3]}
yield self.db.buildslaves.buildslaveConnected(
buildslaveid=self.BS1_ID, masterid=11, slaveinfo=NEW_INFO)
bs = yield self.db.buildslaves.getBuildslave(self.BS1_ID)
self.assertEqual(bs, {
'id': self.BS1_ID,
'name': self.BS1_NAME,
'slaveinfo': NEW_INFO,
'configured_on': [],
'connected_to': [11]})
@defer.inlineCallbacks
def test_buildslaveConnected_already_connected(self):
yield self.insertTestData(self.baseRows + self.buildslave1_rows + [
fakedb.ConnectedBuildslave(id=888,
buildslaveid=self.BS1_ID, masterid=11),
])
yield self.db.buildslaves.buildslaveConnected(
buildslaveid=self.BS1_ID, masterid=11, slaveinfo={})
bs = yield self.db.buildslaves.getBuildslave(self.BS1_ID)
self.assertEqual(bs['connected_to'], [11])
@defer.inlineCallbacks
def test_buildslaveDisconnected(self):
yield self.insertTestData(self.baseRows + self.buildslave1_rows + [
fakedb.ConnectedBuildslave(id=888,
buildslaveid=self.BS1_ID, masterid=10),
fakedb.ConnectedBuildslave(id=889,
buildslaveid=self.BS1_ID, masterid=11),
])
yield self.db.buildslaves.buildslaveDisconnected(
buildslaveid=self.BS1_ID, masterid=11)
bs = yield self.db.buildslaves.getBuildslave(self.BS1_ID)
self.assertEqual(bs['connected_to'], [10])
@defer.inlineCallbacks
def test_buildslaveDisconnected_already_disconnected(self):
yield self.insertTestData(self.baseRows + self.buildslave1_rows)
yield self.db.buildslaves.buildslaveDisconnected(
buildslaveid=self.BS1_ID, masterid=11)
bs = yield self.db.buildslaves.getBuildslave(self.BS1_ID)
self.assertEqual(bs['connected_to'], [])
@defer.inlineCallbacks
def test_buildslaveConfigured(self):
yield self.insertTestData(self.baseRows + self.multipleMasters)
# should remove builder 21, and add 22
yield self.db.buildslaves.deconfigureAllBuidslavesForMaster(masterid=10)
yield self.db.buildslaves.buildslaveConfigured(
buildslaveid=30, masterid=10, builderids=[20, 22])
bs = yield self.db.buildslaves.getBuildslave(30)
self.assertEqual(sorted(bs['configured_on']), sorted([
{'builderid': 20, 'masterid': 11},
{'builderid': 20, 'masterid': 10},
{'builderid': 22, 'masterid': 10}]))
@defer.inlineCallbacks
def test_buildslaveConfiguredTwice(self):
yield self.insertTestData(self.baseRows + self.multipleMasters)
# should remove builder 21, and add 22
yield self.db.buildslaves.deconfigureAllBuidslavesForMaster(masterid=10)
yield self.db.buildslaves.buildslaveConfigured(
buildslaveid=30, masterid=10, builderids=[20, 22])
# configure again (should eat the duplicate insertion errors)
yield self.db.buildslaves.buildslaveConfigured(
buildslaveid=30, masterid=10, builderids=[20, 21, 22])
bs = yield self.db.buildslaves.getBuildslave(30)
self.assertEqual(sorted(bs['configured_on']), sorted([
{'builderid': 20, 'masterid': 11},
{'builderid': 20, 'masterid': 10},
{'builderid': 21, 'masterid': 10},
{'builderid': 22, 'masterid': 10}]))
@defer.inlineCallbacks
def test_nothingConfigured(self):
yield self.insertTestData(self.baseRows + self.multipleMasters)
# should remove builder 21, and add 22
yield self.db.buildslaves.deconfigureAllBuidslavesForMaster(masterid=10)
yield self.db.buildslaves.buildslaveConfigured(
buildslaveid=30, masterid=10, builderids=[])
# should only keep builder for master 11
bs = yield self.db.buildslaves.getBuildslave(30)
self.assertEqual(sorted(bs['configured_on']), sorted([
{'builderid': 20, 'masterid': 11}]))
@defer.inlineCallbacks
def test_deconfiguredAllSlaves(self):
yield self.insertTestData(self.baseRows + self.multipleMasters)
res = yield self.db.buildslaves.getBuildslaves(masterid=11)
self.assertEqual(len(res), 2)
# should remove all slave configured for masterid 11
yield self.db.buildslaves.deconfigureAllBuidslavesForMaster(masterid=11)
res = yield self.db.buildslaves.getBuildslaves(masterid=11)
self.assertEqual(len(res), 0)
from twisted.trial import unittest
testData = [
fakedb.Builder(id=40, name=u'b1'),
fakedb.Builder(id=41, name=u'b2'),
fakedb.Master(id=13),
fakedb.Master(id=14),
fakedb.BuilderMaster(id=4013, builderid=40, masterid=13),
fakedb.BuilderMaster(id=4014, builderid=40, masterid=14),
fakedb.BuilderMaster(id=4113, builderid=41, masterid=13),
fakedb.Buildslave(id=1, name=u'linux', info={}),
fakedb.ConfiguredBuildslave(id=14013, buildslaveid=1,
buildermasterid=4013),
fakedb.ConfiguredBuildslave(id=14014, buildslaveid=1,
buildermasterid=4014),
fakedb.ConnectedBuildslave(id=113, masterid=13, buildslaveid=1),
fakedb.Buildslave(id=2, name=u'windows', info={"a": "b"}),
fakedb.ConfiguredBuildslave(id=24013, buildslaveid=2,
buildermasterid=4013),
fakedb.ConfiguredBuildslave(id=24014, buildslaveid=2,
buildermasterid=4014),
fakedb.ConfiguredBuildslave(id=24113, buildslaveid=2,
buildermasterid=4113),
fakedb.ConnectedBuildslave(id=214, masterid=14, buildslaveid=2),
]
def _filt(bs, builderid, masterid):
bs['connected_to'] = sorted([
d for d in bs['connected_to']
if not masterid or masterid == d['masterid']
