def insertPosition(position):
data = []
for dic in position:
dicList = []
dicList.append(dic['买入冻结'])
dicList.append(dic['交易市场'])
dicList.append(dic['卖出冻结'])
dicList.append(dic['参考市价'])
dicList.append(dic['参考市值'])
dicList.append(dic['参考成本价'])
dicList.append(dic['参考盈亏'])
dicList.append(dic['当前持仓'])
dicList.append(dic['盈亏比例(%)'])
dicList.append(dic['股东代码'])
dicList.append(dic['股份余额'])
dicList.append(dic['股份可用'])
dicList.append(dic['证券代码'])
dicList.append(dic['证券名称'])
data.append(dicList)
sql = 'insert into chicang values(?,?,?,?,?,?,?,?,?,?,?,?,?,?)'
conn = sqlite3API.get_conn('stock.db')
sqlite3API.truncate(conn, 'chicang')
sqlite3API.save(conn, sql, data)
print('insertPosition OK!')
print(data)
return data
def getLiutong_from_qq():
q = easyquotation.use('qq')
#取上市300天内的股票
stock_list = getCixinCode()
stockinfo, stockinfo_zhangting = q.stocks(stock_list)
data = []
for key, value in stockinfo.items():
try:
infoLiutong = (stockinfo[key]['code'], stockinfo[key]['流通市值'])
data.append(infoLiutong)
except Exception as e:
print(e)
for key, value in stockinfo_zhangting.items():
try:
infoLiutong = (stockinfo_zhangting[key]['code'],
stockinfo_zhangting[key]['流通市值'])
data.append(infoLiutong)
except Exception as e:
print(e)
#sql_truncat = 'truncat table liutong_from_qq'
sql = 'insert into liutong_from_qq values(?,?)'
conn = sqlite3API.get_conn('stock.db')
#sqlite3API.save(conn,sql_truncat,data)
sqlite3API.truncate(conn, 'liutong_from_qq')
sqlite3API.save(conn, sql, data)
print('getLiutong_from_qq OK!')
def getListBisi(url):
try:
html = requests.get(url, timeout=5)
# rege1 = re.compile( '>([^<]+)</a>\]</em> <a href="thread-([0-9]+)-1-[0-9]+.html"[^>]+>([^<]+)</a>\n[^\n]+\n[^\n]+\n[^\n]+\n[^\n]+\n[^\n]+\n<a href="([^"]+)"[^>]+>([^<]+)</a>[^\n]+\n<em><span>([^<]+)</span></em>\n</td>\n<td class="num"><a [^>]+>([0-9]+)</a><em>([0-9]+)</em></td>')
regex = re.compile(
'>([^<]+)</a>\]</em> <a href="thread-([0-9]+)-1-[0-9]+.html"[^>]+>([^<]+)</a>[^\n]*\n[^\n]+\n[^\n]+\n[^\n]+\n[^\n]+\n[^\n]+\n<a href="([^"]+)"[^>]+>([^<]+)</a>[^\n]+\n<em><span>([^<]+)</span></em>[^\n]*\n[^\n]*\n<td class="num"><a [^>]+>([0-9]+)</a><em>([0-9]+)</em></td>'
)
rows = regex.findall(html.text)
print((rows))
print('regex', len(rows))
# return
conn = sqlite3API.get_conn(DB_FILE_PATH)
save_sql = 'insert ignore into bisi_discuz_test values(?,?,?,?,?,?,?,?,now())'
sqlite3API.save(conn, save_sql, rows)
# mysql = mysqlAPI('test')
# mysql.insert_mysql('insert ignore into bisi_discuz_test values(%s,%s,%s,%s,%s,%s,%s,%s,now())',rows)
# mysql.close_mysql()
except:
pass
time.sleep(1)
def delPositionHuatai(data):
conn = sqlite3API.get_conn('stock.db')
sql_tid='''
delete from position where code=?;
'''
sqlite3API.save(conn,sql_tid,data)
def insertPositionHuatai(data):
conn = sqlite3API.get_conn('stock.db')
sql_tid='''
insert into position values(?,?);
'''
sqlite3API.save(conn,sql_tid,data)
def insertTradeHistory(position_info,min_liutong):
sql = 'insert into trade_history values(' + ('?,'*47) + "?,datetime('now'))"
conn = sqlite3API.get_conn('stock.db')
data = []
data.append(editStockInfo(position_info,'S'))
data.append(editStockInfo(min_liutong,'B'))
sqlite3API.save(conn,sql,data)
print('insertTradeHistory OK!')
print (data)
def delChiyou():
try:
code = request.form['code']
sql = 'delete from chicang where code=?'
conn = sqlite3API.get_conn('stock.db')
# sqlite3API.truncate(conn,'chicang')
data = [[code]]
sqlite3API.save(conn,sql,data)
return 'delete %s OK' % code
except Exception as e:
#print(e)
return e
def toChiyou():
try:
code = request.form['code']
name = request.form['name']
print(code)
sql = 'insert into chicang (gufen_keyong,code,name) values(100,?,?)'
conn = sqlite3API.get_conn('stock.db')
# sqlite3API.truncate(conn,'chicang')
data = [[code,name]]
sqlite3API.save(conn,sql,data)
return 'insert chicang OK'
except Exception as e:
#print(e)
return e
def getReplyContent(url):
try:
html = requests.get(url, timeout=5)
regex = re.compile('<td class="t_f"[^\n]+\n([^<]+)<')
rows = regex.findall(html.text)
# print(rows)
conn = sqlite3API.get_conn(DB_FILE_PATH)
save_sql = "insert ignore into reply_content (content,flg) values(?,'0')"
sqlite3API.save(conn, save_sql, rows)
# mysql = mysqlAPI('test')
# mysql.insert_mysql("insert ignore into reply_content (content,flg) values(%s,'0')",rows)
# mysql.close_mysql()
except:
pass
time.sleep(1)