class RouteDataTest(TestCase): def setUp(self): self.data = RouteData() self.db = self.data.db def test_version(self): self.assertEqual(self.data.version, '20110905') def test_get_country(self): self.assertRaises(CountryError, self.data.get_countrynum, 'URW') self.assertEqual(self.data.get_countrynum('JP'), '392') self.assertEqual(self.data.get_countrynum('DE'), '276') self.assertEqual(self.data.get_countrynum('de'), '276') def test_read_depots(self): c = self.db.cursor() c.execute("""SELECT * FROM depots WHERE DepotNumber=?""", ('0015', )) rows = c.fetchall() self.assertEqual(1, len(rows)) self.assertEqual( ('0015', '', '', 'Betriebsgesellschaft DPD GmbH', '', 'Otto-Hahn-Strasse 5', '', '59423', 'Unna', 'DE', '+49-(0) 23 03-8 88-0', '+49-(0) 23 03-8 88-31', '', ''), rows[0]) def test_expand_depots(self): c = self.db.cursor() c.execute("""SELECT id FROM routes WHERE DestinationCountry='DE' AND BeginPostCode='42477'""" ) rows = c.fetchall() # Interestingly we sometimes get two routes # self.assertEqual(1, len(rows)) route = rows[0][0] c.execute("SELECT depot FROM routedepots WHERE route=?", (route, )) rows = c.fetchall() self.assertEqual(1, len(rows)) def test_get_service(self): self.assertEqual(self.data.get_service('180'), ('180', 'AM1-NO', '', '022,160', '')) self.assertRaises(ServiceError, self.data.get_service, '100000') def test_get_servicetext(self): text = self.data.get_servicetext('185') self.assertEqual('DPD 10:00 Unfrei / ex works', text) def test_translate_location(self): self.assertEqual('1', self.data.translate_location('Dublin', 'IE')) self.assertRaises(TranslationError, self.data.translate_location, 'Cahir', 'IE')
class RouteDataTest(TestCase): def setUp(self): self.data = RouteData() self.db = self.data.db def test_version(self): self.assertEqual(self.data.version, '20100503') def test_get_country(self): self.assertRaises(CountryError, self.data.get_countrynum, 'URW') self.assertEqual(self.data.get_countrynum('JP'), '392') self.assertEqual(self.data.get_countrynum('DE'), '276') self.assertEqual(self.data.get_countrynum('de'), '276') def test_read_depots(self): c = self.db.cursor() c.execute("""SELECT * FROM depots WHERE DepotNumber=?""", ('0015', )) rows = c.fetchall() self.assertEqual(1, len(rows)) self.assertEqual(('0015', '', '', 'Betriebsgesellschaft DPD Deutscher', '', 'Otto-Hahn-Strasse 5', '', '59423', 'Unna', 'DE', '+49-(0) 23 03-8 88-0', '+49-(0) 23 03-8 88-31', '', ''), rows[0]) def test_expand_depots(self): c = self.db.cursor() c.execute("""SELECT id FROM routes WHERE DestinationCountry='DE' AND BeginPostCode='42477'""") rows = c.fetchall() # Interestingly we sometimes get two routes # self.assertEqual(1, len(rows)) route = rows[0][0] c.execute("SELECT depot FROM routedepots WHERE route=?", (route, )) rows = c.fetchall() self.assertEqual(1, len(rows)) def test_get_service(self): self.assertEqual(self.data.get_service('180'), ('180', 'AM1-NO', '', '022,160', '')) self.assertRaises(ServiceError, self.data.get_service, '100000') def test_get_servicetext(self): text = self.data.get_servicetext('185') self.assertEqual('DPD 10:00 Unfrei / ex works', text) def test_translate_location(self): self.assertEqual('1', self.data.translate_location('Dublin', 'IE')) self.assertRaises(TranslationError, self.data.translate_location, 'Cahir', 'IE')