NewAPI 渠道类型踩坑：Type 5 不是自定义

INSERT INTO channels (type, key, name, base_url) VALUES
(5, 'sk-xxx', '硅基流动', 'https://api.siliconflow.cn'),
(5, 'gsk_xxx', 'Groq', 'https://api.groq.com/openai/v1'),
(5, 'xxx', 'Together AI', 'https://api.together.xyz/v1'),
(5, 'xxx', 'Fireworks AI', 'https://api.fireworks.ai/v1'),
(5, 'sk-xxx', 'DeepSeek', 'https://api.deepseek.com'),
(5, 'xxx', '火山引擎', 'https://ark.cn-beijing.volces.com/api/v3');

const (
    TypeOpenAI           = 1   // OpenAI / 自定义 OpenAI 兼容
    TypeAnthropic        = 2   // Claude
    TypeBaidu            = 3   // 文心一言
    TypeZhipu            = 4   // 智谱
    TypeMidjourneyPlus   = 5   // Midjourney 出图代理
    TypeCustom           = 8   // ���定义渠道
    TypeGoogle           = 24  // Gemini
    TypeDeepSeek         = 43  // DeepSeek (原生)
    TypeVolcEngine       = 45  // 火山引擎
)

// 请求路径 = base_url + "/v1/chat/completions"

// 请求路径 = base_url + "/chat/completions"

// 请求路径 = base_url + "/api/v3/chat/completions"

// 请求路径 = base_url + "/v1beta/models/..."（Gemini 原生格式）

sqlite3 /path/to/newapi/data/newapi.db "SELECT id, name, type, base_url FROM channels;"

grep "Type.*=" /path/to/newapi/constant/channel.go

#!/usr/bin/env python3
"""
newapi-fix-channel-types.py
批量修正 NewAPI 渠道类型并重建能力表。
"""

import sqlite3
import subprocess
import sys

DB_PATH = "/path/to/newapi/data/newapi.db"
DOCKER_CONTAINER = "newapi"

CHANNEL_FIXES = [
    {
        "name": "硅基流动",
        "new_type": 1,     # OpenAI
        "base_url": "https://api.siliconflow.cn",
    },
    {
        "name": "Groq",
        "new_type": 1,     # OpenAI
        "base_url": "https://api.groq.com/openai",
    },
    {
        "name": "Together AI",
        "new_type": 1,     # OpenAI
        "base_url": "https://api.together.xyz",
    },
    {
        "name": "Fireworks AI",
        "new_type": 1,     # OpenAI
        "base_url": "https://api.fireworks.ai",
    },
    {
        "name": "DeepSeek",
        "new_type": 43,    # DeepSeek
        "base_url": "https://api.deepseek.com",
    },
    {
        "name": "火山引擎",
        "new_type": 45,    # VolcEngine
        "base_url": "https://ark.cn-beijing.volces.com",
    },
]


def fix_channels(conn):
    cur = conn.cursor()
    for ch in CHANNEL_FIXES:
        cur.execute(
            "UPDATE channels SET type = ?, base_url = ? WHERE name = ?",
            (ch["new_type"], ch["base_url"], ch["name"]),
        )
        print(f"  [OK] {ch['name']}: type={ch['new_type']}, base_url={ch['base_url']}")
    conn.commit()


def rebuild_abilities(conn):
    cur = conn.cursor()
    cur.execute("DELETE FROM abilities;")
    print("  [OK] abilities 表已清空")
    # 重新从 channels 表生成 abilities
    cur.execute("SELECT id, type FROM channels;")
    for row in cur.fetchall():
        channel_id, channel_type = row
        # 根据 type 推测可用的模型标记，这里简单写一个通用插入
        # 实际应该由 NewAPI 自动重建，重启后框架会处理
        print(f"  [INFO] channel_id={channel_id}, type={channel_type} 待框架自动重建")
    conn.commit()


def restart_newapi():
    try:
        subprocess.run(
            ["docker", "restart", DOCKER_CONTAINER],
            check=True,
            timeout=30,
        )
        print("  [OK] NewAPI 容器已重启")
    except subprocess.CalledProcessError:
        print("  [ERR] 重启失败，请手动运行: docker restart", DOCKER_CONTAINER)
        sys.exit(1)


def main():
    print("=== NewAPI 渠道类型修复 ===")
    print()

    print("[1/3] 连接数据库...")
    conn = sqlite3.connect(DB_PATH)
    print("  [OK] 已连接")

    print()
    print("[2/3] 修正渠道类型和 Base URL...")
    fix_channels(conn)

    print()
    print("[3/3] 重建能力表...")
    rebuild_abilities(conn)

    conn.close()
    print()
    print("数据库操作完成，准备重启服务...")

    restart_newapi()
    print()
    print("=== 修复完成 ===")
    print("请刷新管理页面确认渠道显示正确。")


if __name__ == "__main__":
    main()

sqlite3 /path/to/newapi/data/newapi.db "SELECT id, name, type, base_url FROM channels;"