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_XueqiuSpider(self):
spider = XueqiuSpider()
r = []
r = spider.results()
self.assertGreater(len(r), 1000)
if not isinstance(r[0], XueqiuStock):
raise Exception('type error: result item is not Stock instance')
dao = XueqiuDao('db.sqlite3', 'xueqiu')
dao.update(r)
def test_XueqiuSpider(self):
spider = XueqiuSpider()
r = []
r = spider.results()
self.assertGreater(len(r),1000)
if not isinstance(r[0],XueqiuStock):
raise Exception('type error: result item is not Stock instance')
dao = XueqiuDao('db.sqlite3','xueqiu')
dao.update(r)
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'])
def create_stock_ctrl(self, stock_type):
setting = self.setting
if stock_type == 'wencai':
dao = WencaiDao(setting['db_path'], stock_type)
ctrl = StockCtrl(setting, dao, WencaiStock, stock_type)
return ctrl
elif stock_type == 'xueqiu':
dao = XueqiuDao(setting['db_path'], stock_type)
ctrl = StockCtrl(setting, dao, XueqiuStock, stock_type)
return ctrl
def test_XueqiuDao_Update(self):
spider = XueqiuSpider()
ret = spider.results()
dao = XueqiuDao('../db.sqlite3','xueqiu')
dao.update(ret)
self.assertEqual(len(ret),len(dao.all()))
def test_XueqiuDao_Update(self):
spider = XueqiuSpider()
ret = spider.results()
dao = XueqiuDao('../db.sqlite3', 'xueqiu')
dao.update(ret)
self.assertEqual(len(ret), len(dao.all()))