def setUp(self):
     # instantiate broker for testing
     self.sommelier_broker = SommelierBroker()
     # create mock DB
     db = MagicMock()
     db.execute = MagicMock()
     db.fetch_all = MagicMock()
     db.fetch_one = MagicMock()
     # inject mock db into broker
     self.sommelier_broker.db = db