def update_currentinfo(self): col_name='currentinfo' db=DatabaseInterface() stlget=StockGetAll(self.token) res=stlget.get_api_tickers() clause={} updates={'$set':{'currentTickerList':res}} db.update_db(self.db_name,col_name,clause,updates) db.update_db_date(self.db_name,'ticker')
def update_stockbase_Equ(self,fields): col_name='stockbase' stkif=StockInterface(self.token) db=DatabaseInterface() tickers=db.get_db_tickers() for t in tickers: #获取字典 Equ_dics=stkif._getEqu(fields,t)[0] db.update_db(self.db_name,col_name,{"ticker":t},{"$set":Equ_dics}) print 'update stockbase data with ticker.no'+t+'....'
def update_stockbase_SecTips(self,tips): col_name='stockbase' fields='ticker' stkif=StockInterface(self.token) db=DatabaseInterface() tickers_dic=stkif._getSecTips([fields],tips) tickers=self.unpack_dic(fields,tickers_dic) updates={"$set":{'tipsTypeCD':tips}} for t in tickers: print t+'today turn to'+tips db.update_db(self.db_name,col_name,{'ticker':t},updates)
@author: warriorzhai """ import os os.chdir('C:/Users/warriorzhai/Desktop/project/stockAPI/stockAPI') from DatabaseInterface import DatabaseInterface #更换数据库修改以下三项 user_name='root' psw='root' MONGODB_URI ='mongodb://%s:%[email protected]:41394/tempdb' MONGODB_URI=MONGODB_URI % (user_name,psw) dbin=DatabaseInterface(MONGODB_URI=MONGODB_URI) db_name='tempdb' col_name='tempcol' #测试connect_db connection=dbin.connect_db(db_name,col_name) connection.count() #测试update_db clause={"fund_name":"test"} updates={"$set":{"fund_return":"2"}} dbin.update_db(db_name,col_name,clause,updates,upsert=False, multi=False)