CSPON/jiaxing/landsite_agent_jx/xuanzhi_query.py

import json
from fastapi import APIRouter, Query
from typing import List, Any

from database import Database

router = APIRouter()
database = Database()

@router.get("/xzgyyd-query")
async def klyzy_query(id: str = Query(..., description="ID列表, 逗号分隔")) -> List[Any]:
    """
    查询可利用资源信息
    """
    sql = (
        "select *, st_astext(st_transform(shape,4490)) as geom, st_astext(st_centroid(st_transform(shape,4490))) as center_wkt "
        "from public.xzgyyd where id in ({id})"
    )
    result = await database.execute_query(sql.format(id=id))
    return result