def setUp(self):
ci.get('sdb').query('create table IF NOT EXISTS test( id integer autoincreatement,title varchar(128) ,content text)')
ci.get('mdb').query('''CREATE TABLE IF NOT EXISTS `test` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`title` VARCHAR(128) DEFAULT NULL,
`content` TEXT,
PRIMARY KEY (`id`)
) ENGINE=InnoDB''')
def test_loader_instances(self, req, resp):
#how to connect to different db ?
db2 = ci.loader.cls('CI_DB')(
ci.config['db2']
) # how to create different db instance and save it into ci
ci.set('db2', db2) # save it into ci
print((ci.get('db2').query('select 1')))
#how to log to different file ?
logger2 = ci.loader.cls('CI_Logger')(
ci.config['log2']
) # how to create different db instance and save it into ci
ci.set('logger2', logger2) # save it into ci
print((ci.get('logger2').info('asdfasdfas')))
def test_task(self,req,resp):
stdb= ci.loader.cls('CI_DB')(**ci.config.get('stdb'))
ci.set('stdb',stdb)
crawl= ci.loader.helper('crawl')
# crawl.url_fetch()
crawl.url_fetch('http://www.cninfo.com.cn/cninfo-new/disclosure/szse')
import time
for i in range(1,3):
data={"stock":"","searchkey":"增持;","plate":"","category":"","trade":"","column":"szse","columnTitle":"历史公告查询","pageNum":i,"pageSize":"30","tabName":"fulltext","sortName":"","sortType":"","limit":"","showTitle":"-1/searchkey/增持","seDate":"请选择日期",}
js= crawl.url_fetch('http://www.cninfo.com.cn/cninfo-new/announcement/query',data)
time.sleep(1)
import json
# print json.dumps( json.loads(js),indent=4)
annos=json.loads(js)
for a in annos['announcements']:
try:
if ci.get('stdb').scalar('select count(1) as cnt from st_anno where announcementId=:announcementId',a)['cnt']==0:
ci.get('stdb').insert_safe('st_anno',a)
#print(a)
except Exception as e:
ci.logger.error(e)
print(e)
pass
# print(a['announcementTitle'])
self.add_info(req,resp)
resp.body='ok'
def tearDown(self):
ci.get('sdb').query('drop table test')
ci.get('mdb').query('drop table test')
def test_pool(self):
self._pool(ci.get('mdb'))
def test_mysql(self):
self._mysql(ci.get('mdb'))
def test_db(self):
self._db(ci.get('sdb'))
self._db(ci.get('mdb'))
