4 from sqlalchemy.engine import create_engine
5 from sqlalchemy.orm import sessionmaker
9 class TestWrMwDb(unittest.TestCase):
12 cls.engine = create_engine('mysql://philipp@localhost:3306/philipp_winterrodeln_wiki?charset=utf8&use_unicode=1')
13 cls.Session = sessionmaker(bind=cls.engine)
16 self.metadata = sqlalchemy.MetaData()
17 self.session = self.Session()
20 self.session.rollback()
22 def test_wrreport_table(self):
23 WrReport = wrpylib.wrmwdb.wrreport_table(self.metadata)
24 wrreport = self.session.query(WrReport).filter(WrReport.c.id==130).first()
25 self.assertEqual(wrreport.id, 130)
26 self.assertEqual(wrreport.page_title, 'Simmeringalm')
28 def test_wrsledruncache_table(self):
29 WrSledrunCache = wrpylib.wrmwdb.wrsledruncache_table(self.metadata)
30 wrsledruncache = self.session.query(WrSledrunCache).filter(WrSledrunCache.c.page_id==226).first()
31 self.assertEqual(wrsledruncache.page_id, 226)
32 self.assertEqual(wrsledruncache.page_title, 'Axamer_Lizum')
34 def test_wrinncache_table(self):
35 WrInnCache = wrpylib.wrmwdb.wrinncache_table(self.metadata)
36 wrinncache = self.session.query(WrInnCache).filter(WrInnCache.c.page_id==324).first()
37 self.assertEqual(wrinncache.page_id, 324)
38 self.assertEqual(wrinncache.page_title, 'Alpengasthaus_Gleinserhof')
40 def test_wrreportcache_table(self):
41 WrReportCache = wrpylib.wrmwdb.wrreportcache_table(self.metadata)
42 wrreport = self.session.query(WrReportCache).filter(WrReportCache.c.page_id==226).first()
43 self.assertEqual(wrreport.page_title, 'Axamer Lizum')
45 def test_wrregion_table(self):
46 WrRegion = wrpylib.wrmwdb.wrregion_table(self.metadata)
47 wrregion = self.session.query(WrRegion).filter(WrRegion.c.id==18).first()
48 self.assertEqual(wrregion.id, 18)
49 self.assertEqual(wrregion.name, 'Salzburg')
51 def test_wrregioncache_table(self):
52 WrRegionCache = wrpylib.wrmwdb.wrregioncache_table(self.metadata)
53 wrregioncache = self.session.query(WrRegionCache).filter(WrRegionCache.c.id==43545).first()
54 self.assertEqual(wrregioncache.id, 43545)
55 self.assertEqual(wrregioncache.region_id, 27)
56 self.assertEqual(wrregioncache.page_id, 54)