展示 SQL 文件

接口URL

/api/v1/dms/sqleditor/sqlFiles?clusterID=&database=&userID=

请求方式

GET

Content-Type

application/json

认证方式

Bearer auth

请求Query参数

成功响应示例

{
    "Data": {
        "sqlFiles": [
            {
                "SQLFileID": "sqlfile-1316574190083396",
                "name": "SQL file 1",
                "clusterID": "tidb-f91e1f860d360502",
                "database": "test",
                "userID": "haibo",
                "content": "CREATE TABLE regions (\n    region_id INT (11) AUTO_INCREMENT PRIMARY KEY,\n    region_name VARCHAR (25) DEFAULT NULL\n);\n\n/*Data for the table regions */\n\nINSERT INTO regions(region_id,region_name) VALUES (1,'欧洲');\nINSERT INTO regions(region_id,region_name) VALUES (2,'美洲');\nINSERT INTO regions(region_id,region_name) VALUES (3,'亚洲');\nINSERT INTO regions(region_id,region_name) VALUES (4,'中东和非洲');\n"
            },
            {
                "SQLFileID": "sqlfile-6398853327841070",
                "name": "SQL file 2",
                "clusterID": "tidb-f91e1f860d360502",
                "database": "test",
                "userID": "haibo",
                "content": "select * from regions;"
            }
        ],
        "database": "test"
    },
    "Success": true
}