__author__ = 'zoulida'
import tushare as ts
from tools.LogTools import Logger
logger = Logger(logName='log.txt', logLevel="DEBUG",
logger="downTickCVS3.py").getlog()
codeset = [
'000001.SH',
'000300.SH',
'000905.SH',
'399001.SZ',
'399005.SZ',
'399006.SZ',
'399016.SZ',
'399300.SZ',
]
#描述：目前只提供上证综指，深证成指，上证50，中证500，中小板指，创业板指的每日指标数据
#邹立达算法：获得数据库最大日期，再从这个日期做为开始日期下载指数。
'''
ts_code trade_date turnover_rate pe
0 000001.SH 20181018 0.38 11.92
1 000300.SH 20181018 0.27 11.17
2 000905.SH 20181018 0.82 18.03
3 399001.SZ 20181018 0.88 17.48
4 399005.SZ 20181018 0.85 21.43
5 399006.SZ 20181018 1.50 29.56
6 399016.SZ 20181018 1.06 18.86
7 399300.SZ 20181018 0.27 11.17
'''
pro = ts.pro_api('69d6b836725cd75df21b39873603b14fed58d101bc033b991b51eb41')
__author__ = 'zoulida'
from tools.tusharePro import getPro
from tools.LogTools import Logger
import time
logger = Logger(logName='log.txt', logLevel="DEBUG", logger="santai3").getlog()
#from tools.connectMySQL import getStockDataBaseCursorAndDB
def getProOk(): #没有用到
getPro()
def getZTList(codelist, dateDay):
listA = []
#if haveBeenGreaterThanbyOneDay(codelist, dateDay):
# listA.append(code)
def getGreaterThanList(codelist,
dateDay,
percentage=1.07): #取得最高价大于percentage的list
start = time.time()
listA = []
res_l = []
pool = poolpre()
for row in codelist.itertuples(index=True, name='Pandas'):
code = getattr(row, "Index")
booleanValue = pool.apply_async(
haveBeenGreaterThanbyOneDay, (code, dateDay, percentage),
__author__ = 'zoulida'
import tushare as ts
import pandas as pd
from tools.LogTools import Logger #注意可以.LogTools import Logger相对路径更为简洁一些
from memory_profiler import profile
logger = Logger(logName='log.txt', logLevel="DEBUG",
logger="logTest.py").getlog()
#@profile
def get_all_stock2():
import tools.platformPrint as pp
import tools.mkdir as mkdir
if pp.UsePlatform() == "Linux":
mkdir.mkdirA('/volume/stock_data')
filepath = '/volume/stock_data/get_stock_basics.csv'
elif pp.UsePlatform() == "Windows":
mkdir.mkdirA('E:\\stock_data\\')
filepath = 'E:\\stock_data\\get_stock_basics.csv'
stock_info = ts.get_stock_basics()
stock_info.to_csv(filepath, encoding="gbk",
index=True) #获得股票列表，一读一写是为了防止网络问题
normal_stocks = stock_info.loc[:, ['name']]
#print(normal_stocks)
tms = pd.read_csv(filepath, dtype=str, encoding="gbk")
#tms2 = pd.read_csv(filepath, dtype=str, encoding="gbk")
#del tms2
#tms3 = pd.read_csv(filepath, dtype=str, encoding="gbk")
__author__ = 'Administrator'
from tools.LogTools import Logger
logger = Logger(logName='log.txt', logLevel="DEBUG",
logger="downTickCVS3.py").getlog()
from tools import connectMySQL
cursor, db = connectMySQL.getTickCursorAndDB() #getTickCursor()
#print(df.keys())
#创建数据表
logger.info("正在创建数据表" + "ErrorInfo")
sqlSentence3 = "create table ErrorInfo" + "(股票代码 VARCHAR(10), 第一次出错日期 date, 连续出错次数 bigint DEFAULT 0, 名称 VARCHAR(10),\
weight float, primary key(股票代码) )"
print(sqlSentence3)
try:
cursor.execute(sqlSentence3)
except Exception as msg:
#print (str(msg))
logger.info("数据表ErrorInfo" + "已经存在，无法再次创建")
updateSentence = "INSERT INTO ErrorInfo(股票代码, 第一次出错日期, 名称, weight) VALUE('100001','2017-7-24' ,'小李','666') ON DUPLICATE KEY UPDATE 名称= '小张',weight=weight+1"
cursor.execute(updateSentence)
print(updateSentence)
cursor.close()
db.commit()
db.close()
from selenium import webdriver
from selenium.webdriver.common.desired_capabilities import DesiredCapabilities
import time
#解决cmd CMD路径问题，就是将当然执行的路径包加入到sys中去。
import sys
import os
path2 = os.path.abspath('.')
print(path2)
sys.path.extend([path2])
#sys.path.extend(['D:\pythonworkspace\weblogin'])
import datetime
from tools.LogTools import Logger
nowTime = datetime.datetime.now().strftime('%Y-%m-%d_%H-%M-%S')
logName = 'webLoginlog-' + nowTime + '.txt'
logger = Logger(logName, logLevel="DEBUG", logger="loginIndex.py").getlog()
class alert_is_present(object):
""" Expect an alert to be present."""
"""判断当前页面的alert弹窗"""
def __init__(self):
pass
def __call__(self, driver):
try:
alert = driver.switch_to.alert
alert.text
return alert
except:
return False
__author__ = 'Administrator'
from tools.LogTools import *
logger = Logger(logName='log.txt', logLevel="DEBUG",
logger="logTest.py").getlog()
logger.debug("苍井空")
logger.info("麻生希")
logger.warning("小泽玛利亚")
logger.error("桃谷绘里香")
logger.critical("泷泽萝拉")
from tools.LogCut import * #这是log的升级，详见logcut
logger = Logger(logName='logcut.out', logLevel="DEBUG",
logger="logTest.py").getlog()
# Log some messages
for i in range(100):
logger.debug('i = %d' % i)
import datetime
from tools.LogTools import Logger
nowTime = datetime.datetime.now().strftime('%Y-%m-%d_%H-%M-%S')
logName = 'log-' + nowTime + '.txt'
logger = Logger(logName, logLevel="DEBUG", logger="downTickCVS7.py").getlog()
str_test = "0123456"
try:
str_test[:3] = "9"
except Exception as e:
import traceback
#print('traceback.print_exc():', traceback.print_exc())