package com.product.org.admin.test;

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

import com.product.common.utils.HttpTest;


public class procedureTest extends HttpTest{
	public static void main(String[] args) {
		//procedureRunSql();//运行储存过程语句
		//addProcedure();//保存储存过程信息
		//upProcedure();//修改储存过程信息
		//delProcedure();//删除储存过程
		//getProcedureInfo();//获取存储过程信息
		getProcedureAll();//获取所有存储过程
	}
	/**
	 * 测试存储过程语句
	 */
	public static void procedureRunSql(){
		Map<String, Object> m=new HashMap<String, Object>();
		m.put("procedure_sql", " CREATE PROCEDURE num_from_employee3(IN uuid VARCHAR(64)) BEGIN "+
								" SELECT * FROM product_sys_datamodel_field WHERE table_uuid = uuid;  "+
								" SELECT * FROM product_sys_datamodel_table A WHERE A.uuid = uuid;  "+
								" END");//运行的sql
		m.put("url/api", "/api/procedure/runSql/v1");
		m.put("version","V1");
		testPost(m);
	}
	/**
	 * 新增存储过程表，及参数表
	 */
	public static void addProcedure(){
		Map<String, Object> m=new HashMap<String, Object>();
		m.put("procedure_name", "num_from_employee");//存储过程名
		m.put("procedure_description","查询数据字段表");//存储过程说明
		m.put("procedure_sql"," CREATE PROCEDURE num_from_employe3(IN uuid VARCHAR(64)) BEGIN "+
				" SELECT * FROM product_sys_datamodel_field WHERE table_uuid = uuid;  "+
				" SELECT * FROM product_sys_datamodel_table A WHERE A.uuid = uuid;  "+
				" END");//存储sql
		m.put("url/api", "/api/procedure/saveProcedure/v1");
		m.put("version","V1");
		List<Object> fList = new ArrayList<Object>();
		Map<String, String> fieldMap=new HashMap<String, String>();
		fieldMap.put("para_name", "uuid");//参数名
		fieldMap.put("para_desc", "输入参数");//参数说明
		fList.add(fieldMap);
		m.put("product_sys_datamodel_procedure_sub", fList);
		testPost(m);
	}
	/**
	 * 修改存储过程表，及参数表
	 */
	public static void upProcedure(){
		Map<String, Object> m=new HashMap<String, Object>();
		m.put("procedure_name", "num_from_employee");//存储过程名
		m.put("procedure_description","修改查询数据字段表");//存储过程说明
		m.put("procedure_sql"," CREATE PROCEDURE num_from_employee(IN uuid VARCHAR(64)) BEGIN "+
				" SELECT * FROM product_sys_datamodel_field WHERE table_uuid = uuid;  "+
				" SELECT * FROM product_sys_datamodel_table A WHERE A.uuid = uuid;  "+
				" END");//存储sql
		m.put("uuid", "0c229ee6-ea2d-44e7-914b-811ea82cca4c");
		m.put("url/api", "/api/procedure/saveProcedure/v1");
		m.put("version","V1");
		List<Object> fList = new ArrayList<Object>();
		Map<String, String> fieldMap=new HashMap<String, String>();
		fieldMap.put("para_name", "uuid");//参数名
		fieldMap.put("para_desc", "输入参数uuid");//参数说明
		fList.add(fieldMap);
		m.put("product_sys_datamodel_procedure_sub", fList);
		testPost(m);
	}
	/**
	 * 删除存储过程及参数表
	 */
	public static void delProcedure(){
		Map<String, Object> m=new HashMap<String, Object>();
		m.put("url/api", "/api/procedure/delProcedure/v1");
		m.put("version","V1");
		List<Object> fList = new ArrayList<Object>();

		Map<String, String> fieldMap=new HashMap<String, String>();
		fieldMap.put("procedure_uuid", "9e7f65ba-ee9e-4727-b8bd-b52e19619285");//存储过程uuid
		fieldMap.put("procedure_name","num_from_employee");//存储过程name
		fList.add(fieldMap);
		m.put("product_sys_datamodel_procedure", fList);
		testPost(m);
	}
	/**
	 * 获取储存过程信息
	 */
	public static void getProcedureInfo(){
		Map<String, Object> m=new HashMap<String, Object>();
		m.put("url/api", "/api/procedure/getProcedureInfo/v1");
		m.put("version","V1");
		m.put("uuid", "0c229ee6-ea2d-44e7-914b-811ea82cca4c");
		testPost(m);
	}
	/**
	 * 获取所有储存过程列表
	 */
	public static void getProcedureAll(){
		Map<String, Object> m=new HashMap<String, Object>();
		m.put("url/api", "/api/procedure/getProcedureAll/v1");
		m.put("version","V1");
		testPost(m);
	}
}