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'))