# workspace_delete.dspy - 删除工作空间文件

import os
from urllib.parse import unquote

def _decode_id(s):
    for _ in range(4):
        if '%' not in s:
            break
        s2 = unquote(s)
        if s2 == s:
            break
        s = s2
    return s

file_id = _decode_id((params_kw or {}).get('id', '').strip())

uid = await get_user()
if not uid:
    uid = 'user-01'

session_id = (params_kw or {}).get('session_id', '') or ''
pipeline_id = (params_kw or {}).get('pipeline_id', '') or ''

dbname = get_module_dbname('pipeline-sdlc')

async with DBPools().sqlorContext(dbname) as sor:
    # 产线隔离：跨产线项目视为无项目（与弹窗入口一致，防绕过）
    project_dir, _ = await get_project_dir_pl(sor, uid, session_id, pipeline_id)
    space_dir, _ = await get_space_dir(sor, uid, session_id)
    # 通用会话（pipeline_id=_generic）：锁用户专属目录 _general/{uid}，
    # 不进入任何项目的工作空间（2026-09-08 用户要求）
    if pipeline_id == '_generic':
        _gd = generic_workspace_dir(uid)
        os.makedirs(_gd, exist_ok=True)
        project_dir = _gd
        space_dir = _gd

if not file_id or file_id == '__root__':
    return {"status": "error", "message": "不能删除根目录"}

full_path = resolve_workspace_path(project_dir, space_dir, file_id)

# 防止路径穿越：确保最终路径在机构工作空间（space_dir）内
real_ws = os.path.realpath(space_dir)
real_full = os.path.realpath(full_path)
if not real_full.startswith(real_ws + os.sep):
    return {"status": "error", "message": "非法路径"}

if not os.path.isfile(full_path):
    return {"status": "error", "message": "文件不存在: " + file_id}

try:
    os.remove(full_path)
except Exception as e:
    return {"status": "error", "message": "删除失败: " + str(e)}

return {"status": "ok", "message": "已删除: " + os.path.basename(full_path)}