新疆电量预测-查询数据

开发中

POST

http://localhost:8085/sql/getDataAndType

请求参数

Body 参数application/json

object {0}

示例

{
    "sessionId":"889900",
    "sql":"SELECT org_name AS `地市`,power_month AS `月份`,power_num AS `售电量_亿kWh` FROM tb_dlyc_area_power_month WHERE org_name = '乌鲁木齐' AND power_year = '2024' AND power_month in ('07','08');SELECT expect_month AS `月份`, org_name AS `地市`, expect_num AS `预测售电量_亿kWh` FROM tb_dlyc_area_prediction_result WHERE org_name = '乌鲁木齐' AND expect_year = '2024' AND expect_month in ('11','12');",
    "prompt":"2024年乌鲁木齐8月的售电量和11月份的预测电量是多少"
}

示例代码

Shell

JavaScript

Java

Swift

PHP

Python

HTTP

Objective-C

Ruby

OCaml

Dart

curl --location --request POST 'http://localhost:8085/sql/getDataAndType' \
--header 'Content-Type: application/json' \
--data-raw '{
    "sessionId":"889900",
    "sql":"SELECT org_name AS `地市`,power_month AS `月份`,power_num AS `售电量_亿kWh` FROM tb_dlyc_area_power_month WHERE org_name = '\''乌鲁木齐'\'' AND power_year = '\''2024'\'' AND power_month in ('\''07'\'','\''08'\'');SELECT expect_month AS `月份`, org_name AS `地市`, expect_num AS `预测售电量_亿kWh` FROM tb_dlyc_area_prediction_result WHERE org_name = '\''乌鲁木齐'\'' AND expect_year = '\''2024'\'' AND expect_month in ('\''11'\'','\''12'\'');",
    "prompt":"2024年乌鲁木齐8月的售电量和11月份的预测电量是多少"
}'

返回响应

🟢200成功

application/json

Body

msg

string

必需

code

integer

必需

data

array [object {5}]

必需

result

array [object {4}]

必需

answerDesc

string

必需

string

必需

string

必需

type

string

必需

示例

{
    "msg": "string",
    "code": 0,
    "data": [
        {
            "result": [
                {
                    "售电量_亿kWh": 0,
                    "地市": "string",
                    "月份": "string",
                    "预测售电量_亿kWh": 0
                }
            ],
            "answerDesc": "string",
            "x": "string",
            "y": "string",
            "type": "string"
        }
    ]
}

修改于 2024-10-18 03:02:00

新疆电量预测 - 智能问数

自适应rag