SQLite 数据库管理器
| 14 | |
| 15 | |
| 16 | class SQLiteManager: |
| 17 | """SQLite 数据库管理器""" |
| 18 | |
| 19 | # 状态字段常量 |
| 20 | STATE_FIELDS = { |
| 21 | "error_codes", |
| 22 | "error_messages", |
| 23 | "disabled", |
| 24 | "last_success", |
| 25 | "user_email", |
| 26 | "model_cooldowns", |
| 27 | "preview", |
| 28 | "tier", |
| 29 | "enable_credit", |
| 30 | } |
| 31 | |
| 32 | # 所有必需的列定义（用于自动校验和修复） |
| 33 | REQUIRED_COLUMNS = { |
| 34 | "credentials": [ |
| 35 | ("disabled", "INTEGER DEFAULT 0"), |
| 36 | ("error_codes", "TEXT DEFAULT '[]'"), |
| 37 | ("error_messages", "TEXT DEFAULT '[]'"), |
| 38 | ("last_success", "REAL"), |
| 39 | ("user_email", "TEXT"), |
| 40 | ("model_cooldowns", "TEXT DEFAULT '{}'"), |
| 41 | ("preview", "INTEGER DEFAULT 1"), |
| 42 | ("tier", "TEXT DEFAULT 'pro'"), |
| 43 | ("rotation_order", "INTEGER DEFAULT 0"), |
| 44 | ("call_count", "INTEGER DEFAULT 0"), |
| 45 | ("created_at", "REAL DEFAULT (unixepoch())"), |
| 46 | ("updated_at", "REAL DEFAULT (unixepoch())") |
| 47 | ], |
| 48 | "antigravity_credentials": [ |
| 49 | ("disabled", "INTEGER DEFAULT 0"), |
| 50 | ("error_codes", "TEXT DEFAULT '[]'"), |
| 51 | ("error_messages", "TEXT DEFAULT '[]'"), |
| 52 | ("last_success", "REAL"), |
| 53 | ("user_email", "TEXT"), |
| 54 | ("model_cooldowns", "TEXT DEFAULT '{}'"), |
| 55 | ("tier", "TEXT DEFAULT 'pro'"), |
| 56 | ("enable_credit", "INTEGER DEFAULT 0"), |
| 57 | ("rotation_order", "INTEGER DEFAULT 0"), |
| 58 | ("call_count", "INTEGER DEFAULT 0"), |
| 59 | ("created_at", "REAL DEFAULT (unixepoch())"), |
| 60 | ("updated_at", "REAL DEFAULT (unixepoch())") |
| 61 | ] |
| 62 | } |
| 63 | |
| 64 | def __init__(self): |
| 65 | self._db_path = None |
| 66 | self._credentials_dir = None |
| 67 | self._initialized = False |
| 68 | self._lock = asyncio.Lock() |
| 69 | |
| 70 | # 内存配置缓存 - 初始化时加载一次 |
| 71 | self._config_cache: Dict[str, Any] = {} |
| 72 | self._config_loaded = False |
| 73 |