bind = '127.0.0.1:9015'   # 监听ip和端口
wsgi_app = 'public.wsgi:application'   # 指定wsgi app
workers = 2   # 启动的工作进程
threads = 8   # 每个进程可用于处理请求的线程数（可同时处理的最大请求量为 workers * threads）
timeout = 30   # 请求处理超时时间
max_requests = 2000  # 每个工作进程最大处理请求量（达到后自动重启工作进程，可防止内存泄露）
max_requests_jitter = 200  # 重启工作进程的最大抖动（防止工作进程在达到max requests时同时重启导致服务中断）
accesslog = '-'  # 访问日志（可指定文件，- 意味着输出到标准输出）
errorlog = 'access.log'  # 错误日志
capture_output = True  # 捕获标准输出和标准错误输出至errorlog（结合accesslog='-'意味所有输出都会被记录到errolog中）
access_log_format = '%({x-forwarded-for}i)s %(t)s %(r)s %(s)s generated %(b)s bytes in %(M)s ms'  # 访问日志格式
daemon = True   # 守护进程模式
reload = True  # 自动重载（开发测试环境可用，检测到代码变化自动重载）

def adjust_ws(ws):
    def get_length(text):
        _length = 0
        for char in str(text):
            if '\u4e00' <= char <= '\u9fff':  # 中文字符
                _length += 2
            else:
                _length += 1
        return _length

    def has_chinese(text):
        try:
            text.encode('ascii')
            return False
        except UnicodeEncodeError:
            return True

    for col in ws.columns:
        max_length = 0
        column = col[0].column_letter

        for cell in col:
            if cell.value:
                lines = str(cell.value).split('\n')
                length = max(get_length(line) for line in lines)
                if length > max_length:
                    max_length = length

        # 设置列宽，这里可以根据需要调整比率增加或减少宽度
        ws.column_dimensions[column].width = (max_length + 2) * 1

    for row in ws.rows:
        max_lines = 1
        for cell in row:
            if cell.value:
                lines_count = sum([1.4 if has_chinese(x) else 1 for x in str(cell.value).split('\n')])
                if lines_count > max_lines:
                    max_lines = lines_count
        # 设置行高，可根据需要调整比率增加或减少
        ws.row_dimensions[row[0].row].height = 15 * max_lines

from openpyxl import Workbook
from openpyxl.styles import Alignment

def export_excel():
    # 创建工作簿和工作表
    wb = Workbook()
    ws = wb.active

    # 示例数据（包含换行符）
    data = [
        ['姓名', '描述', '备注'],
        ['张三', '这是一段很长的描述\n需要换行显示', '备注1'],
        ['李四', '另一段描述内容\n同样需要换行', '备注2'],
    ]

    # 写入数据
    for row_idx, row in enumerate(data, start=1):
        for col_idx, value in enumerate(row, start=1):
            cell = ws.cell(row=row_idx, column=col_idx, value=value)
            if '\n' in str(value):
                cell.alignment = Alignment(
                    wrap_text=True,
                    vertical='center',
                    horizontal='left'
                )

    # 引用上述函数调整列宽和行高
    adjust_ws(ws)

    # 保存文件
    wb.save('example.xlsx')
    
export_excel()

from django.http import StreamingHttpResponse
import json

def hello(request):
    # 生成器函数
    def handle_data():
      for i in range(int(last_id or -1) + 1, 100):
          # 触发前端的 onmessage 回调函数，默认 event：message
          yield f'data:data is {i}\n\n'
          # 返回复杂数据（转JSON字符串）
          data = {'a': 1, 'b': 2}
          yield f'data:{json.dumps(data)}\n\n'
          # 触发前端的 addEventListener('ping')，event：ping
          yield f'event:ping\ndata: ping data...\n\n'

    response = StreamingHttpResponse(handle_data(), content_type='text/event-stream')
    response['Cache-Control'] = 'no-cache'
    return response

import logging

# 日志记录到./demo.log文件中，format指定日志格式
logging.basicConfig(filename='./demo.log', format='%(asctime)s %(message)s')

logging.warning('hello')

# 基础使用
logging.basicConfig(filename='./demo.log', format='%(asctime)s %(message)s')
# 记录器使用，配合Handler
formatter = logging.Formatter('%(asctime)s %(message)s')
handler.setFormatter(formaater)

import logging

# 创建记录器对象
logger = logging.getLogger('log1')
# 创建文件处理器，指定日志文件
handler = logging.FileHandler('./demo.log')
# 格式器
formatter = logging.Formatter('%(asctime)s %(message)s')
handler.setFormatter(formatter)
logger.addHandler(handler)

logger.setLevel('INFO')
logger.error('hello error')

from logging.handlers import RotatingFileHandler
import logging

logger = logging.getLogger('log1')
# maxBytes 设置单个文件的最大值（单位：字节）
# backupCount 设置最多保留多少个备份文件
# maxBytes 和 backupCount 都必须同时设置才生效
# 以下配置会最多生成 demo.log demo.log.1 demo.log2 demo.log3  4个文件
handler = RotatingFileHandler('./demo.log', maxBytes=1024, backupCount=3)
logger.addHandler(handler)

from logging.handlers import TimedRotatingFileHandler
import logging

logger = logging.getLogger('log1')
# when 设置轮换间隔时间（midnight：午夜0点）
# backupCount 设置最多保留多少个备份文件
# 以下配置会每天生成新文件最多保留7天历史文件
handler = TimedRotatingFileHandler('./demo.log', when='midnight', backupCount=7)
logger.addHandler(handler)

from django.db import models


class Person(models.Model):
    name = models.CharField(max_length=30)
    age = models.IntegerField()
    remarks = models.CharField(max_length=255, null=True)
    created_at = models.DateTimeField(auto_now_add=True)

    class Meta:
        db_table = 'persons'

from django.db import models


class Class(models.Model):
    name = models.CharField(max_length=30)
    remarks = models.CharField(max_length=255, null=True)
    created_at = models.DateTimeField(auto_now_add=True)

    class Meta:
        db_table = 'classes'



class Person(models.Model):
    cls = models.ForeignKey(Class, on_delete=models.PROTECT, null=True)
    name = models.CharField(max_length=30)
    age = models.IntegerField()
    remarks = models.CharField(max_length=255, null=True)
    created_at = models.DateTimeField(auto_now_add=True)

    class Meta:
        db_table = 'persons'

import json

body = {
    "id": "12",
    "url": "https://gitee.com/yooke/User.git",
    "type": "c",
}

# request.GET
# request.POST
# application/json   json.loads(request.body)


body = json.dumps(body)


class Argument:
    def __init__(self, key, required=True, filter=None, type=None, help=None):
        self.key = key
        self.required = required
        self.filter = filter
        self.type = type
        self.help = help


class Parser:
    def __init__(self, *arguments):
        self.arguments = arguments

    def parse(self, data):
        form, error = {}, None
        for arg in self.arguments:
            value = data.get(arg.key)
            if arg.required and value is None:  # 判断required属性是否必填
                error = arg.help
                break
            if arg.type:  # 判断type属性类型是否正确
                if not isinstance(value, arg.type):
                    try:
                        value = arg.type(value)  # 尝试转换类型
                    except ValueError:
                        error = arg.help
                        break
            if arg.filter and not arg.filter(value):  # 判断是否符合filter过滤条件
                error = arg.help
                break
            form[arg.key] = value
        return form, error


class JSONParser(Parser):  # 扩展解析JSON消息体
    def parse(self, data):
        data = json.loads(data)
        return super().parse(data)


class XMLParser(Parser):   # 扩展解析XML消息体
    def xmltodict(self, data):
        # TODO: xml to dict
        return data

    def parse(self, data):
        data = self.xmltodict(data)
        return super().parse(data)


def main():
    form, error = JSONParser(
        Argument('id', type=int, help='ID必须是整数'),
        Argument('name', required=False, help='name参数必填'),
        Argument('url', help='url参数必填'),
        Argument('type', filter=lambda x: x in ('a', 'b', 'c'), help='type参数必须是a,b,c中的一个'),
    ).parse(body)
    if error is None:
        print('参数校验通过: ', form)
    else:
        print('参数校验失败: ', error)


main()