import time
import random
import re
import io
import os
sys.path.append('/home/hemaobin/workspace/stock')
import mysqldb
import analyzer
analyzer = analyzer.Analyzer()
basic_url = 'http://hq.sinajs.cn/list='
symbollist = [
'sz000651', 'sz000333', 'sz300104', 'sz300415', 'sh601777', 'sz300051'
]
code_list = ['000651', '000333', '300104', '300415', '601777', '300051']
headers = {'User-Agent': 'gsi'}
stock = mysqldb.StockDatabase()
stock.connectdatabase()
cursor = stock.getcursor()
while True:
i = 0
for symbol in symbollist:
url = basic_url + symbol
print(url)
time.sleep(1)
request = urllib.request.Request(url, headers=headers)
try:
response = urllib.request.urlopen(request)
html = response.read()
except urllib.error.URLError as e:
print('urlerror!!')
html = ""
def compare_price(self,symbol,price):
stock = mysqldb.StockDatabase()
stock.connectdatabase()
cursor = stock.getcursor()
sell_volume = 0
buy_volume=0
diff_valume=0
i=0
sell_price = float(price) - float(price)*0.02
print(sell_price)
print(price)
try:
os.remove('mail.txt')
except:
print('no file')
f = open('/home/hemaobin/workspace/stock/mail.txt','w')
sql = 'SELECT SUM(volume) AS volume FROM trade%s WHERE volume < 1' % symbol
volume = stock.select(cursor,sql)
print('volume:',volume)
if volume != None:
sell_volume = volume[0][0]
print("sell:",sell_volume)
else:
sell_volume = 0
sql = 'SELECT @r:=@r+1 as rownum,a.* FROM trade%s a,(select @r:=0) b WHERE volume > 1 limit 100' % symbol
data = stock.select(cursor,sql)
if data != None:
for item in data:
buy_volume = buy_volume + item[2]
i = i+1
if buy_volume >= abs(sell_volume):
print('buyvolume:',buy_volume,'num:',i)
break
else:
return 0
if sell_volume == 0:
buy_volume = 0
diff_valume = buy_volume - abs(sell_volume)
sql = 'SELECT * FROM trade%s WHERE volume > 1 and costprice < %s limit %s,100' % (symbol,sell_price,i-1)
data = stock.select(cursor,sql)
if data == None:
print('none')
return 0
k = 0
for item in data:
print(item)
if k == 0:
lst = list(item)
print('lst1:',lst[1])
lst[1] =diff_valume
print('lst1:',lst[1])
item = tuple(lst)
print('diff:',diff_valume)
print('1:',lst[1])
print('2:',item[1])
f.write(str(item))
f.write(str(sell_price))
f.write('\n')
k = k+1
f.close()
size=os.path.getsize('/home/hemaobin/workspace/stock/mail.txt')
print('filesize:',size)
if size >= 30:
os.system('/home/hemaobin/workspace/stock/sendmail.sh')
stock.closedb()