package com.product.org.admin.test;

import java.util.List;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.Map;

import com.product.common.utils.HttpTest;


public class TableTest extends HttpTest {
	//{"msg":"视图已经存在:testView","code":"7095","status":"fail"}
	//success  成功
	//fail 失败 打印msg
	public static void main(String[] args) {
		//runSql();//运行sql
		addViewInfo();//新增视图
		//upViewInfo();//修改视图表信息
		//upViewSql();//修改视图sql
		//deleteTable();// 删除视图
		//getViewTableInfo();//通过uuid获取视图信息及字段信息
		//getViewTableAll();//获取所有视图信息
	}
	/**
	 * 测试sql运行  
	 */
	public static void runSql() {
		Map m=new HashMap();
		m.put("view_sql", " SELECT uuid,product_name NAMES,product_shortcode shortcode,tricode,NULL client_type_uuid,1 type FROM product_sys_products UNION ALL SELECT uuid,module_name,module_shortcode,tricode,NULL client_type_uuid,2 type FROM product_sys_modules UNION ALL SELECT uuid,function_name,function_shortcode,tricode,NULL client_type_uuid,3 type FROM product_sys_functions UNION ALL  " + 
				" SELECT uuid,button_name,null function_shortcode,function_uuid tricode,client_type_uuid,4 type FROM product_sys_function_buttons  ");//运行的sql
		//m.put("view_sql", " UPDATE product_sys_datamodel_table SET table_description = '视图描述' WHERE table_id = 163 ");//运行的sql
		m.put("url/api", "/api/view/runSql/v1");
		m.put("version","V1");
		testPost(m);
	}
	/**
	 * 新增视图表
	 */
	public static void addViewInfo() {
		Map m=new HashMap();
		m.put("url/api", "/api/view/saveViewInfo/v1");
		m.put("version","V1");
		m.put("table_name", "module_function_views");//视图名en 
		m.put("table_description", "模块功能列表视图");//视图描述
		//m.put("uuid", "");//视图uuid
		m.put("table_base_view", "product_sys_datamodel_table product_sys_datamodel_field");//视图基础表
		m.put("view_sql", " SELECT uuid,product_name NAMES,product_shortcode shortcode,tricode,NULL client_type_uuid,1 type FROM product_sys_products UNION ALL SELECT uuid,module_name,module_shortcode,tricode,NULL client_type_uuid,2 type FROM product_sys_modules UNION ALL SELECT uuid,function_name,function_shortcode,tricode,NULL client_type_uuid,3 type FROM product_sys_functions UNION ALL  \r\n" + 
				"SELECT uuid,button_name,null function_shortcode,function_uuid tricode,client_type_uuid,4 type FROM product_sys_function_buttons ");//运行的sql
		m.put("create_view_sql_status", "true");//是否保存sql
		List fList = new ArrayList();

			Map fieldMap=new HashMap();
			fieldMap.put("field_name", "uuid");//字段名1
			fieldMap.put("field_type","string");//类型
			fieldMap.put("field_length","64");//长度
			fieldMap.put("field_unit","0");//小数位
			fieldMap.put("related_table","");
			fList.add(fieldMap);
			Map fieldMap2=new HashMap();
			fieldMap2.put("field_name", "NAME");//字段名2
			fieldMap2.put("field_type","string");//类型
			fieldMap2.put("field_length","255");//长度
			fieldMap2.put("field_unit","0");//小数位
			fieldMap2.put("related_table","");
			fList.add(fieldMap2);
			Map fieldMap3=new HashMap();
			fieldMap3.put("field_name", "shortcode");//字段名2
			fieldMap3.put("field_type","string");//类型
			fieldMap3.put("field_length","255");//长度
			fieldMap3.put("field_unit","0");//小数位
			fieldMap3.put("related_table","");
			fList.add(fieldMap3);
			Map fieldMap4=new HashMap();
			fieldMap4.put("field_name", "tricode");//字段名2
			fieldMap4.put("field_type","string");//类型
			fieldMap4.put("field_length","800");//长度
			fieldMap4.put("field_unit","0");//小数位
			fieldMap4.put("related_table","");
			fList.add(fieldMap4);
			Map fieldMap5=new HashMap();
			fieldMap5.put("field_name", "client_type_uuid");//字段名2
			fieldMap5.put("field_type","string");//类型
			fieldMap5.put("field_length","255");//长度
			fieldMap5.put("field_unit","0");//小数位
			fieldMap5.put("related_table","");
			fList.add(fieldMap5);
			Map fieldMap6=new HashMap();
			fieldMap6.put("field_name", "type");//字段名2
			fieldMap6.put("field_type","string");//类型
			fieldMap6.put("field_length","255");//长度
			fieldMap6.put("field_unit","0");//小数位
			fieldMap6.put("related_table","");
			fList.add(fieldMap6);
		m.put("product_sys_datamodel_filed", fList);
		testPost(m);
	}
	/**
	 * 修改视图表信息
	 */
	public static void upViewInfo() {
		Map m=new HashMap();
		m.put("url/api", "/api/view/saveViewInfo/v1");
		m.put("version","V1");
		m.put("table_name", "testView");//视图名
		m.put("table_description", "修改视图");//视图描述
		m.put("uuid", "19fe3ffe-87fc-4f6f-866e-a1fa0906ffcb");//视图uuid
		testPost(m);
	}
	/**
	 * 修改视图sql
	 */
	public static void upViewSql() {
		Map m=new HashMap();
		m.put("url/api", "/api/view/saveViewInfo/v1");
		m.put("version","V1");
		m.put("table_name", "uptestViewSql");//视图名
		m.put("table_description", "修改视图sql");//视图描述
		m.put("uuid", "3717d6bf-9263-4039-ad6f-0cc482b711f1");//视图uuid
		m.put("table_base_view", "product_sys_datamodel_table");//视图基础表
		m.put("view_sql", " SELECT uuid FROM product_sys_datamodel_table  ");//运行的sql
		m.put("create_view_sql_status", "true");
		List fList = new ArrayList();

		Map fieldMap=new HashMap();
		fieldMap.put("field_name", "uuid");//字段名1
		fieldMap.put("field_type","string");//类型
		fieldMap.put("field_length","64");//长度
		fieldMap.put("field_unit","0");//小数位
		fieldMap.put("related_table","product_sys_datamodel_table");
		fList.add(fieldMap);
		m.put("product_sys_datamodel_filed", fList);
		testPost(m);
	}
	/**
	 * 删除视图
	 */
	public static void deleteTable(){
		Map m=new HashMap();
		m.put("url/api", "/api/view/deleteTable/v1");
		m.put("version","V1");
		m.put("uuid", "8994ea1b-48a9-4b7e-bb92-c2b554e5cffa");//视图uuid
		testPost(m);
	}
	/**
	 * 获取视图信息及子表信息
	 */
	public static void getViewTableInfo(){
		Map m=new HashMap();
		m.put("url/api", "/api/view/getViewTableInfo/v1");
		m.put("version","V1");
		m.put("uuid", "a990c60c-8e71-41e8-a57d-cb0ed76febcd");//视图uuid
		testPost(m);
	}
	/**
	 * 获取所有实现信息
	 */
	public static void getViewTableAll(){
		Map m=new HashMap();
		m.put("url/api", "/api/view/getViewTableAll/v1");
		m.put("version","V1");
		testPost(m);
	}
}