def test_XueqiuDao_Filter(self):
dao = XueqiuDao('../db.sqlite3','xueqiu')
cond = [('mc',0,10000)]
ret = dao.filter(cond)
self.assertGreater(len(ret),1)
stock = XueqiuStock(*ret[0])
self.assertGreater(stock.mc,0)
self.assertGreater(10000,stock.mc)
def test_XueqiuDao_Filter(self):
dao = XueqiuDao('../db.sqlite3', 'xueqiu')
cond = [('mc', 0, 10000)]
ret = dao.filter(cond)
self.assertGreater(len(ret), 1)
stock = XueqiuStock(*ret[0])
self.assertGreater(stock.mc, 0)
self.assertGreater(10000, stock.mc)
def test_XueqiuDao_Filter_Multi(self):
dao = XueqiuDao('../db.sqlite3','xueqiu')
cond = [('mc',-7000,7000),('fmc',-10000,10000)]
ret = dao.filter(cond)
self.assertGreater(len(ret),1)
for item in ret:
stock = XueqiuStock(*item)
self.assertGreater(stock['mc'],-7000)
self.assertGreater(7000,stock['mc'])
self.assertGreater(stock['fmc'],-10000)
self.assertGreater(10000,stock['fmc'])
def test_XueqiuDao_Filter_Multi(self):
dao = XueqiuDao('../db.sqlite3', 'xueqiu')
cond = [('mc', -7000, 7000), ('fmc', -10000, 10000)]
ret = dao.filter(cond)
self.assertGreater(len(ret), 1)
for item in ret:
stock = XueqiuStock(*item)
self.assertGreater(stock['mc'], -7000)
self.assertGreater(7000, stock['mc'])
self.assertGreater(stock['fmc'], -10000)
self.assertGreater(10000, stock['fmc'])
