package com.product.server.report;
|
|
import java.util.ArrayList;
|
import java.util.HashMap;
|
import java.util.List;
|
import java.util.Map;
|
|
import com.product.common.utils.HttpTest;
|
import com.product.server.report.config.CmnConst;
|
|
public class ReportDatasourceTest extends HttpTest{
|
|
public static void main(String[] args) {
|
// listDatasource(); //数据源列表
|
// findDatasource(); //数据源详情
|
addDatasource(); //数据源新增
|
// updateDatasource(); //数据源修改
|
// deleteDatasource(); //数据源删除
|
// sqlVerify(); //sql验证
|
// getSysParam(); //获取系统参数
|
}
|
|
public static void listDatasource() {
|
Map<String, Object>map=new HashMap<>();
|
map.put("url/api", "/api/report-datasource/list-datasource");
|
map.put("~table~", CmnConst.PRODUCT_SYS_REPORT_DATASOURCE_CONFIG);
|
map.put("cpage", 1);
|
map.put("pagesize", 10);
|
testPost(map);
|
}
|
|
public static void findDatasource() {
|
Map<String, Object>map=new HashMap<>();
|
map.put("url/api", "/api/report-datasource/find-datasource");
|
map.put("~table~", CmnConst.PRODUCT_SYS_REPORT_DATASOURCE_CONFIG);
|
map.put("uuid", "bd70fd58-e6d9-4b06-982d-d3134890eba8");
|
testPost(map);
|
}
|
|
public static void addDatasource() {
|
Map<String, Object>map=new HashMap<>();
|
map.put("url/api", "/api/report-datasource/add-datasource");
|
map.put("~table~", CmnConst.PRODUCT_SYS_REPORT_DATASOURCE_CONFIG);
|
map.put("report_database_name", "数据源");
|
map.put("is_page", "1");
|
map.put("page_size", "10");
|
map.put("sql_text", "SELECT * FROM product_sys_dict");
|
map.put("org_level_uuid", "");
|
|
List<Map<String, Object>> subList=new ArrayList<Map<String,Object>>();
|
|
Map<String, Object> subList1=new HashMap<String, Object>();
|
subList1.put("field_name", "dict_label");
|
subList1.put("field_text", "");
|
subList1.put("field_format", "文本格式");
|
subList1.put("field_prompt", "a");
|
subList1.put("search_type", "1");
|
|
Map<String, Object> subList2=new HashMap<String, Object>();
|
subList2.put("field_name", "dict_value");
|
subList2.put("field_text", "");
|
subList2.put("field_format", "文本格式");
|
subList2.put("field_prompt", "b");
|
subList2.put("search_type", "1");
|
|
Map<String, Object> subList3=new HashMap<String, Object>();
|
subList3.put("field_name", "dict_id");
|
subList3.put("field_text", "");
|
subList3.put("field_format", "###");
|
subList3.put("field_prompt", "");
|
subList3.put("search_type", "2");
|
|
subList.add(subList1);
|
subList.add(subList2);
|
subList.add(subList3);
|
|
map.put(CmnConst.PRODUCT_SYS_REPORT_DATASOURCE_CONFIG_FIELD, subList);
|
|
testPost(map);
|
}
|
|
public static void updateDatasource() {
|
Map<String, Object>map=new HashMap<>();
|
map.put("url/api", "/api/report-datasource/update-datasource");
|
map.put("~table~", CmnConst.PRODUCT_SYS_REPORT_DATASOURCE_CONFIG);
|
map.put("uuid", "bd70fd58-e6d9-4b06-982d-d3134890eba8");
|
map.put("report_database_name", "数据源");
|
map.put("is_page", "1");
|
map.put("page_size", "10");
|
map.put("sql_text", "SELECT * FROM product_sys_dict");
|
map.put("org_level_uuid", "");
|
|
List<Map<String, Object>> subList=new ArrayList<Map<String,Object>>();
|
|
Map<String, Object> subList1=new HashMap<String, Object>();
|
subList1.put("uuid", "94d12872-a006-4f24-9f4e-8beec8eb69ec");
|
subList1.put("datasource_uuid", "bd70fd58-e6d9-4b06-982d-d3134890eba8");
|
subList1.put("field_name", "dict_label");
|
subList1.put("field_text", "");
|
subList1.put("field_format", "文本格式");
|
subList1.put("field_prompt", "a");
|
subList1.put("search_type", "1");
|
|
Map<String, Object> subList2=new HashMap<String, Object>();
|
subList2.put("uuid", "c50d8db3-0254-4be6-b930-45addb3ecd53");
|
subList2.put("datasource_uuid", "bd70fd58-e6d9-4b06-982d-d3134890eba8");
|
subList2.put("field_name", "dict_value");
|
subList2.put("field_text", "");
|
subList2.put("field_format", "文本格式");
|
subList2.put("field_prompt", "b");
|
subList2.put("search_type", "1");
|
|
Map<String, Object> subList3=new HashMap<String, Object>();
|
subList3.put("uuid", "921bcc3f-c180-4491-8d14-386185a86fc4");
|
subList3.put("datasource_uuid", "bd70fd58-e6d9-4b06-982d-d3134890eba8");
|
subList3.put("field_name", "dict_id");
|
subList3.put("field_text", "");
|
subList3.put("field_format", "##");
|
subList3.put("field_prompt", "");
|
subList3.put("search_type", "2");
|
|
subList.add(subList1);
|
subList.add(subList2);
|
subList.add(subList3);
|
|
map.put(CmnConst.PRODUCT_SYS_REPORT_DATASOURCE_CONFIG_FIELD, subList);
|
testPost(map);
|
}
|
|
public static void deleteDatasource() {
|
Map<String, Object>map=new HashMap<>();
|
map.put("url/api", "/api/report-datasource/delete-datasource");
|
map.put("~table~", CmnConst.PRODUCT_SYS_REPORT_DATASOURCE_CONFIG);
|
map.put("uuid", "bd70fd58-e6d9-4b06-982d-d3134890eba8");
|
testPost(map);
|
}
|
|
public static void sqlVerify(){
|
Map<String,Object>map=new HashMap<>();
|
map.put("url/api", "/api/report-datasource/verify-sql");
|
map.put(CmnConst.SQL_TEXT, "SELECT CONCAT(dict_id,dict_name) FROM product_sys_dict");
|
testPost(map);
|
}
|
|
public static void getSysParam(){
|
Map<String,Object>map=new HashMap<>();
|
map.put("url/api", "/api/report-datasource/get-system-param");
|
testPost(map);
|
}
|
}
|
