Python进阶与常用库：探索高效编程的奥秘

import logging
import colorlog

# 创建日志器
logger = logging.getLogger('my_app')
logger.setLevel(logging.DEBUG)

# 创建控制台处理器
handler = logging.StreamHandler()
handler.setLevel(logging.DEBUG)

# 设置彩色格式
formatter = colorlog.ColoredFormatter(
    "%(log_color)s%(levelname)s:%(name)s:%(message)s",
    log_colors=colorlog.default_log_colors
)
handler.setFormatter(formatter)
logger.addHandler(handler)

# 测试日志
logger.debug('Debug message')
logger.info('Info message')
logger.warning('Warning message')
logger.error('Error message')
logger.critical('Critical message')

import time
from functools import wraps

def timing_decorator(func):
    @wraps(func)
    def wrapper(*args, **kwargs):
        start = time.time()
        result = func(*args, **kwargs)
        end = time.time()
        print(f"{func.__name__} took {end - start:.2f} seconds")
        return result
    return wrapper

@timing_decorator
def slow_function(x, y):
    time.sleep(2)
    return x + y

print(slow_function(10, 20))  # 输出执行时间和结果

from functools import wraps
from datetime import datetime

# 模拟用户数据库
users_db = {
    1: {"username": "zhangsan", "password": "zhangsan", "role": "admin"},
    2: {"username": "lisi", "password": "lisi", "role": "user"}
}

# 操作日志
operation_logs = []

# 权限验证装饰器
def require_admin(func):
    @wraps(func)
    def wrapper(user_id, *args, **kwargs):
        if users_db.get(user_id, {}).get("role") != "admin":
            print("Unauthorized access")
            return {"error": "Unauthorized access"}
        return func(user_id, *args, **kwargs)
    return wrapper

# 日志记录装饰器
def log_operation(func):
    @wraps(func)
    def wrapper(user_id, *args, **kwargs):
        result = func(user_id, *args, **kwargs)
        action_time = datetime.now().strftime("%Y-%m-%d %H:%M:%S")
        log_entry = {
            "user_id": user_id,
            "action_time": action_time,
            "action": f"Called {func.__name__} with args {args}, kwargs {kwargs}"
        }
        operation_logs.append(log_entry)
        print("Logged operation")
        return result
    return wrapper

@require_admin
@log_operation
def edit_user_info(user_id, new_email, new_username, new_password):
    print(f"Editing user {new_username} with email {new_email}")
    return {"status": "success"}

# 测试
print(edit_user_info(1, "new@admin.com", "newuser", "newpass"))  # 成功
print(edit_user_info(2, "new@admin.com", "newuser", "newpass"))  # 无权限
print(operation_logs)

import smtplib
from email.mime.text import MIMEText
from email.header import Header

# 邮件服务器配置
mail_host = "smtp.163.com"
mail_user = "your_email@163.com"
mail_pass = "your_password"
sender = "your_email@163.com"
receivers = ["recipient@admin.com"]

# 创建邮件
message = MIMEText("Hello, this is a test email!", "plain", "utf-8")
message["From"] = Header("Python Bot", "utf-8")
message["To"] = Header("User", "utf-8")
message["Subject"] = Header("Test Email", "utf-8")

# 发送邮件
try:
    smtp_obj = smtplib.SMTP()
    smtp_obj.connect(mail_host, 25)
    smtp_obj.login(mail_user, mail_pass)
    smtp_obj.sendmail(sender, receivers, message.as_string())
    print("Email sent successfully")
except smtplib.SMTPException as e:
    print(f"Error: {e}")

import pymysql

db = pymysql.connect(host='localhost', user='root', password='', database='python', port=3306)
cursor = db.cursor()

# 创建表
cursor.execute("DROP TABLE IF EXISTS users")
cursor.execute("""
    CREATE TABLE users (
        id INT NOT NULL,
        username CHAR(20),
        pwd CHAR(255)
    )
""")

# 插入数据
cursor.execute("INSERT INTO users (id, username, pwd) VALUES (111, 'zhangsan', 'zhangsan')")
db.commit()
db.close()

import sqlite3

conn = sqlite3.connect('test.db')
cursor = conn.cursor()

# 创建表
cursor.execute("DROP TABLE IF EXISTS users")
cursor.execute("""
    CREATE TABLE users (
        id INT NOT NULL,
        username CHAR(20),
        pwd CHAR(255)
    )
""")

# 插入数据
cursor.execute("INSERT INTO users (id, username, pwd) VALUES (111, 'zhangsan', 'zhangsan')")
conn.commit()

# 查询数据
cursor.execute("SELECT * FROM users")
for row in cursor.fetchall():
    print(row)
conn.close()