编辑器执行
<p>[TOC]</p>
<h5>简要描述</h5>
<ul>
<li>编辑器执行</li>
</ul>
<h5>请求URL</h5>
<ul>
<li><code>/RunTask</code></li>
</ul>
<h5>请求方式</h5>
<ul>
<li>POST </li>
</ul>
<h5>参数</h5>
<table>
<thead>
<tr>
<th style="text-align: left;">参数名</th>
<th style="text-align: left;">必选</th>
<th style="text-align: left;">类型</th>
<th>说明</th>
</tr>
</thead>
<tbody>
<tr>
<td style="text-align: left;">name</td>
<td style="text-align: left;">是</td>
<td style="text-align: left;">string</td>
<td>模块名称</td>
</tr>
<tr>
<td style="text-align: left;">type</td>
<td style="text-align: left;">是</td>
<td style="text-align: left;">string</td>
<td>方法名称</td>
</tr>
<tr>
<td style="text-align: left;">packid</td>
<td style="text-align: left;">是</td>
<td style="text-align: left;">string</td>
<td>方法id,默认null</td>
</tr>
<tr>
<td style="text-align: left;">param</td>
<td style="text-align: left;">是</td>
<td style="text-align: left;">dict</td>
<td>参数</td>
</tr>
<tr>
<td style="text-align: left;">cache</td>
<td style="text-align: left;">是</td>
<td style="text-align: left;">string</td>
<td>缓存方式,默认all</td>
</tr>
<tr>
<td style="text-align: left;">children</td>
<td style="text-align: left;">是</td>
<td style="text-align: left;">string</td>
<td>递归config</td>
</tr>
</tbody>
</table>
<h5>请求示例</h5>
<pre><code> {
"name":"source",
"type":"sql",
"packid":null,
"cache":"cache",
"param":{
"num":100,
"sql":"select * from xmr_test",
"dbtype":"mysql",
"info":{
"host":"127.0.0.1",
"port":3306,
"dbtype":"mysql",
"database":"test",
"user":"root",
"password":"123456"
},
"model":"normal"
},
"children":[
{
"name":"dtransform",
"type":"compound",
"packid":null,
"cache":"cache",
"param":{
"config":[
{
"func":"add_col",
"add_dict": [
{"col":"hhhhhh",
"funcstr":"{spcdata}+50"
}
]
},
{
"func":"add_col",
"add_dict": [
{"col":"ttttttt",
"funcstr":"{spcdata}+100"
}
]
}
]
},
"children":[
]
}
]
}</code></pre>
<h5>返回示例</h5>
<pre><code>{
"result": {
"data": [
[
"2020-11-02T15:21:29",
2.07,
52.07,
102.07
],
[
"2020-11-02T15:21:30",
1.98,
51.98,
101.98
],
[
"2020-11-02T15:21:31",
1.79,
51.79,
101.79
],
[
"2020-11-02T15:21:32",
3.12,
53.12,
103.12
],
[
"2020-11-02T15:21:33",
4.89,
54.89,
104.89
]
],
"column": {
"spctime": {
"dtype": "datetime"
},
"spcdata": {
"dtype": "data"
},
"hhhhhh": {
"dtype": "data"
},
"ttttttt": {
"dtype": "data"
}
}
},
"message": "查询成功",
"status": 200
}</code></pre>
<h5>返回参数说明</h5>
<table>
<thead>
<tr>
<th style="text-align: left;">参数名</th>
<th style="text-align: left;">类型</th>
<th>说明</th>
</tr>
</thead>
<tbody>
<tr>
<td style="text-align: left;">status</td>
<td style="text-align: left;">int</td>
<td>响应状态码</td>
</tr>
<tr>
<td style="text-align: left;">result</td>
<td style="text-align: left;">dict</td>
<td>返回结果</td>
</tr>
<tr>
<td style="text-align: left;">message</td>
<td style="text-align: left;">string</td>
<td>响应状态信息</td>
</tr>
</tbody>
</table>
<h5>返回示例</h5>
<ul>
<li>更多返回错误代码请看首页的错误代码描述</li>
</ul>
<h5>注意</h5>
<ul>
<li>数据库参数的"model"要用"simple",表示只取前50条数据</li>
<li>编辑器建议用compound函数,将所有的计算方法变为列表,后端依次回调执行</li>
</ul>