mysql操作

# import pymysql
# conn = pymysql.connect(
#     host='124.220.179.221',
#     user='root',
#     password='123456',
#     database='iruance_cms',
#     port=3307,
#     charset='utf8'
# )
# cursor = conn.cursor()
#
# # sql = 'select * from sys_user'
# # cursor.execute(sql)
# # print(cursor.fetchone())
# # print(cursor.fetchmany(5))
# # print(cursor.fetchall())
# # cursor.close()
# # conn.close()
# # sql ='update sys_user set user_email="6666@qq.com" where id = "6"'
# # cursor.execute(sql)
# # conn.commit()
# # cursor.close()
# # conn.close()
# sql = "select * from sys_user where user_email='6666@qq.com'"
# cursor.execute(sql)
# print(cursor.fetchall())
# cursor.close()
# conn.close()



# def login():
#     user = input('username:').strip()
#     user_account = input('user_account:').strip()
#     sql ='select user_name,user_account from sys_user where user_name=%s and user_account=%s'
#     cursor.execute(sql,(user,user_account))
#     print(cursor.fetchall())
#     cursor.close()
#     conn.close()
# login()



# logging.basicConfig()函数中可通过具体参数来更改logging模块默认行为，可用参数有：
#
# filename：用指定的文件名创建FiledHandler，这样日志会被存储在指定的文件中。
# filemode：文件打开方式，在指定了filename时使用这个参数，默认值为“a”还可指定为“w”。
# format：指定handler使用的日志显示格式。
# datefmt：指定日期时间格式。
# level：设置rootlogger（后边会讲解具体概念）的日志级别
# stream：用指定的stream创建StreamHandler。可以指定输出到sys.stderr,sys.stdout或者文件(f=open(‘test.log’,’w’))，
# 默认为sys.stderr。若同时列出了filename和stream两个参数，则stream参数会被忽略。
#
# format参数中可能用到的格式化串：
# %(name)s Logger的名字
# %(levelno)s 数字形式的日志级别
# %(levelname)s 文本形式的日志级别
# %(pathname)s 调用日志输出函数的模块的完整路径名，可能没有
# %(filename)s 调用日志输出函数的模块的文件名
# %(module)s 调用日志输出函数的模块名
# %(funcName)s 调用日志输出函数的函数名
# %(lineno)d 调用日志输出函数的语句所在的代码行
# %(created)f 当前时间，用UNIX标准的表示时间的浮 点数表示
# %(relativeCreated)d 输出日志信息时的，自Logger创建以 来的毫秒数
# %(asctime)s 字符串形式的当前时间。默认格式是 “2003-07-08 16:49:45,896”。逗号后面的是毫秒
# %(thread)d 线程ID。可能没有
# %(threadName)s 线程名。可能没有
# %(process)d 进程ID。可能没有
# %(message)s用户输出的消息


import logging

# logging.basicConfig(level=logging.DEBUG)
# logging.debug('deg msg')
# logging.info('info msg')
# logging.warning('warning msg')
# logging.error('error msg')
# logging.critical('critical msg')

# fh = logging.FileHandler(filename='xxx.log')
# logging.basicConfig(level=logging.INFO,handlers =[fh])
#
# logging.debug('deg msg')
# logging.info('info msg')
# logging.warning('warning msg')
# logging.error('error msg')
# logging.critical('critical msg')



# fh = logging.FileHandler(filename='xxx.log')
# sh = logging.StreamHandler()
# logging.basicConfig(level=logging.INFO,handlers = [fh,sh])
# logging.debug('deg msg')
# logging.info('info msg')
# logging.warning('warning msg')
# logging.error('error msg')
# logging.critical('critical msg')


# file_handler =logging.FileHandler(filename='test.log',mode='a',encoding='utf-8')
# logging.basicConfig(
#     format='%(asctime)s - %(name)s[%(lineno)d] - %(levelname)s -%(module)s: %(message)s',
#     datefmt='%Y-%m-%d  %H:%S:%S %p',
#     handlers = [file_handler],
#     level=logging.INFO
# )
# logging.debug('deg msg')
# logging.info('info msg')
# logging.warning('warning msg')
# logging.error('error msg')
# logging.critical('critical msg')


# import time
# import logging
# from logging import handlers
# sh = logging.StreamHandler()
# rh= handlers.RotatingFileHandler('myapp.log',maxBytes=1024,backupCount=5,encoding='utf-8')
# fh = handlers.TimedRotatingFileHandler(filename='x2.log',when='s',interval=5,encoding='utf-8')
# logging.basicConfig(
#     format='%(asctime)s - %(name)s - %(levelname)s - %(module)s: %(message)s',
#     datefmt='%Y-%m-%d %H:%M:%S %p',
#     handlers =[fh,sh,rh],
#     level=logging.INFO
# )
# while True:
#     logging.warning('你输入的错误数字，程序造成一次异常，已被处理')
#     time.sleep(0.2)