西宁项目初始

shichongfu

2023-04-25 ce0b49552668d3331055e2b1a1447a743dc54939

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
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);
    }
}