from datetime import datetime
from typing import Literal
from pydantic import BaseModel, ConfigDict, Field, field_validator, model_validator

class Task(BaseModel):
    model_config = ConfigDict(str_strip_whitespace=True)
    title: str = Field(min_length=1, max_length=50)
    priority: Literal["low", "high"] = "low"
    tags: list[str] = Field(default_factory=list)
    due: datetime | None = None

    @field_validator("tags")
    @classmethod
    def _norm(cls, tags: list[str]) -> list[str]:
        return list(dict.fromkeys(t.strip().lower() for t in tags if t.strip()))

    @model_validator(mode="after")
    def _high_needs_due(self):
        if self.priority == "high" and self.due is None:
            raise ValueError("high 优先级必须有 due")
        return self

import logging
from pathlib import Path

def setup_logging(level: str, log_file: Path | None = None) -> None:
    root = logging.getLogger()
    root.setLevel(level.upper())
    if root.handlers:          # 已配置过：只调级别，不重复加 handler
        return
    fmt = logging.Formatter("%(asctime)s %(levelname)s %(name)s: %(message)s")
    console = logging.StreamHandler(); console.setFormatter(fmt); root.addHandler(console)
    if log_file:
        fh = logging.FileHandler(log_file, encoding="utf-8"); fh.setFormatter(fmt); root.addHandler(fh)

import re
LOG_LINE = re.compile(r"""
    ^(?P<time>\d{4}-\d{2}-\d{2}\ \d{2}:\d{2}:\d{2})\s+
    \[(?P<level>[A-Z]+)\]\s+
    (?P<logger>[\w.]+):\s+
    (?P<message>.*)$
""", re.VERBOSE)

def parse_log_line(line: str) -> dict | None:
    m = LOG_LINE.match(line.strip())
    return m.groupdict() if m else None

import sqlite3

SCHEMA = """
CREATE TABLE IF NOT EXISTS notes (id INTEGER PRIMARY KEY AUTOINCREMENT, title TEXT NOT NULL);
CREATE INDEX IF NOT EXISTS idx_notes_title ON notes(title);
"""

def migrate(conn: sqlite3.Connection) -> None:
    with conn:
        conn.executescript(SCHEMA)     # IF NOT EXISTS → 幂等

class SqliteRepo:
    def __init__(self, conn: sqlite3.Connection) -> None:
        self.conn = conn
        migrate(conn)
    def add(self, title: str) -> int:
        with self.conn:
            cur = self.conn.execute("INSERT INTO notes (title) VALUES (?)", (title,))
        return int(cur.lastrowid)