__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())