go-service-agent/functions/query_json.go

package functions

import (
	"github.com/gin-gonic/gin"

	"git.x2erp.com/qdy/go-base/types"
	"git.x2erp.com/qdy/go-db/factory"
)

// 执行查询，返回CSV数据格式。无参数查询
func QueryToJSON(dbFactory *factory.DBFactory) func(c *gin.Context, req types.QueryRequest) {
	return func(c *gin.Context, req types.QueryRequest) {
		result := dbFactory.QueryToJSON(req.SQL)
		c.JSON(200, result)
	}
}

// 执行查询，返回CSV数据格式。带参数名称进行查询
func QueryParamNameToJSON(dbFactory *factory.DBFactory) func(c *gin.Context, req types.QueryRequest) {
	return func(c *gin.Context, req types.QueryRequest) {
		result := dbFactory.QueryParamsNameToJSON(req.SQL, req.Params)
		c.JSON(200, result)
	}
}

// 执行查询，返回JSON数据格式。带占位参数进行查询
func QueryPositionalToJSON(dbFactory *factory.DBFactory) func(c *gin.Context, req types.QueryRequest) {
	return func(c *gin.Context, req types.QueryRequest) {
		result := dbFactory.QueryPositionalToJSON(req.SQL, req.PositionalParams)

		c.JSON(200, result)
	}
}