/
endpoints.go
114 lines (103 loc) · 2.71 KB
/
endpoints.go
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
112
113
114
package server
import (
"net/http"
"github.com/labstack/echo"
)
func (m *MysqlAPIServer) endpointMetadata(c echo.Context) error {
if c.QueryParam("simple") == "true" {
return goJSON(c, http.StatusOK, m.api.GetDatabaseMetadata().GetSimpleMetadata())
}
return goJSON(c, http.StatusOK, m.api.GetDatabaseMetadata())
}
func (m *MysqlAPIServer) endpointEcho(c echo.Context) (err error) {
bodyM, err := bodyMapOf(c)
if err != nil {
return err
}
return goJSONMessage(c, "echo api", bodyM)
}
func (m *MysqlAPIServer) endpointUpdateMetadata(c echo.Context) error {
m.api.UpdateAPIMetadata()
return goJSONMessage(c, "metadata refreshed", nil)
}
func (m *MysqlAPIServer) endpointTableGet(c echo.Context) (err error) {
tableName := c.Param("table")
limit, offset, fields, wheres, links := parseQueryParams(c)
rs, err := m.api.Select(tableName, nil, limit, offset, fields, wheres, links)
if err != nil {
return err
}
return goJSONMessage(c, "get table", rs)
}
func (m *MysqlAPIServer) endpointTableGetSpecific(c echo.Context) (err error) {
tableName := c.Param("table")
id := c.Param("id")
limit, offset, fields, wheres, links := parseQueryParams(c)
rs, err := m.api.Select(tableName, id, limit, offset, fields, wheres, links)
if err != nil {
return err
}
return goJSONMessage(c, "get table by id", rs)
}
func (m *MysqlAPIServer) endpointTableCreate(c echo.Context) (err error) {
payload, err := bodyMapOf(c)
tableName := c.Param("table")
if err != nil {
return
}
rs, err := m.api.Create(tableName, payload)
if err != nil {
return err
}
msg, err := parseSQLResult(rs)
if err != nil {
return err
}
return goJSONMessage(c, "create record", msg)
}
func (m *MysqlAPIServer) endpointTableUpdateSpecific(c echo.Context) (err error) {
payload, err := bodyMapOf(c)
tableName := c.Param("table")
id := c.Param("id")
if err != nil {
return
}
rs, err := m.api.Update(tableName, id, payload)
if err != nil {
return err
}
msg, err := parseSQLResult(rs)
if err != nil {
return err
}
return goJSONMessage(c, "update record", msg)
}
func (m *MysqlAPIServer) endpointTableDelete(c echo.Context) (err error) {
payload, err := bodyMapOf(c)
tableName := c.Param("table")
if err != nil {
return
}
rs, err := m.api.Delete(tableName, nil, payload)
if err != nil {
return err
}
msg, err := parseSQLResult(rs)
if err != nil {
return err
}
return goJSONMessage(c, "delete record", msg)
}
func (m *MysqlAPIServer) endpointTableDeleteSpecific(c echo.Context) (err error) {
tableName := c.Param("table")
id := c.Param("id")
rs, err := m.api.Delete(tableName, id, nil)
if err != nil {
return err
}
msg, err := parseSQLResult(rs)
if err != nil {
return err
}
return goJSONMessage(c, "delete record by id", msg)
}