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