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);
	}
}