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)
