def test_remove_sport_should_remove_associated_entries(self):
     sport = Sport()
     sport.name = u"Test name"
     sport = self.sport_service.store_sport(sport)
     self.sport_service.remove_sport(sport)
     result = self.sport_service.get_sport(1)
     self.assertEqual(result, None)

 def test_max_pace_should_take_floor_of_float(self):
     sport = Sport()
     sport.max_pace = 220.6
     self.ddbb.session.add(sport)
     self.ddbb.session.commit()
     sport = self.ddbb.session.query(Sport).filter(Sport.id == 1).one()
     self.assertEqual(220, sport.max_pace)

 def test_id_should_accept_integer_string(self):
     sport = Sport()
     sport.id = "1"
     self.ddbb.session.add(sport)
     self.ddbb.session.commit()
     sport = self.ddbb.session.query(Sport).filter(Sport.id == 1).one()
     self.assertEqual(1, sport.id)

 def test_met_should_not_accept_non_float_string(self):
     sport = Sport()
     try:
         sport.met = "22.5kg"
     except(ValueError):
         pass
     else:
         self.fail()

 def test_met_should_accept_float_string(self):
     sport = Sport()
     sport.name = "test1"
     sport.met = "22.5"
     self.ddbb.session.add(sport)
     self.ddbb.session.commit()
     sport = self.ddbb.session.query(Sport).filter(Sport.id == 1).one()
     self.assertEqual(22.5, sport.met)

 def test_max_pace_should_not_accept_non_integer_string(self):
     sport = Sport()
     try:
         sport.max_pace = "225s"
     except(ValueError):
         pass
     else:
         self.fail()

 def test_max_pace_should_not_accept_negative_value(self):
     sport = Sport()
     try:
         sport.max_pace = -1
     except(ValueError):
         pass
     else:
         self.fail()

 def test_name_should_not_accept_non_unicode_string(self):
     sport = Sport()
     try:
         sport.name = "Juggling"
     except(TypeError):
         pass
     else:
         self.fail()

 def test_id_should_not_accept_non_integer_string(self):
     sport = Sport()
     try:
         sport.id = "1.1"
     except(ValueError):
         pass
     else:
         self.fail()

 def test_name_should_not_accept_none(self):
     sport = Sport()
     try:
         sport.name = None
     except(TypeError):
         pass
     else:
         self.fail()

 def test_store_sport_should_update_row_when_sport_has_id(self):
     sport = Sport()
     sport.name = u"Test name"
     sport = self.sport_service.store_sport(sport)
     sport.name = u"New name"
     self.sport_service.store_sport(sport)
     sport = self.sport_service.get_sport(1)
     self.assertEqual(sport.name, u"New name")

 def test_color_should_not_accept_none(self):
     sport = Sport()
     try:
         sport.color = None
     except(ValueError):
         pass
     else:
         self.fail()

 def test_weight_should_not_accept_negative_value(self):
     sport = Sport()
     try:
         sport.weight = -1
     except(ValueError):
         pass
     else:
         self.fail()

 def test_remove_sport_should_error_when_sport_has_unknown_id(self):
     sport = Sport()
     sport.id = 100
     try:
         self.sport_service.remove_sport(sport)
     except(SportServiceException):
         pass
     else:
         self.fail()

 def test_name_should_not_accept_none(self):
     sport = Sport()
     sport.name = None
     try:
         self.ddbb.session.add(sport)
         self.ddbb.session.commit()
     except (IntegrityError, OperationalError):
         pass
     else:
         self.fail()

 def test_met_should_not_accept_non_float_string(self):
     sport = Sport()
     sport.met = "22.5kg"
     try:
         self.ddbb.session.add(sport)
         self.ddbb.session.flush()
     except(ValueError, StatementError):
         pass
     else:
         self.fail()

 def test_id_should_not_accept_non_integer_string(self):
     sport = Sport()
     try:
         sport.id = "test"
         self.ddbb.session.add(sport)
         self.ddbb.session.flush()
     except (IntegrityError, DataError, OperationalError):
         pass
     else:
         self.fail()

 def test_weight_should_not_accept_non_float_string(self):
     sport = Sport()
     sport.weight = "22.5kg"
     try:
         self.ddbb.session.add(sport)
         self.ddbb.session.flush()
     except StatementError:
         pass
     else:
         self.fail()

 def test_weight_should_not_accept_none(self):
     sport = Sport()
     sport.weight = None
     try:
         self.ddbb.session.add(sport)
         self.ddbb.session.flush()
     except (IntegrityError, OperationalError):
         pass
     else:
         self.fail()

 def test_color_should_not_accept_none(self):
     sport = Sport()
     sport.color = None
     try:
         self.ddbb.session.add(sport)
         self.ddbb.session.commit()
     except StatementError:
         pass
     else:
         self.fail()