修改自动生成的文件
package model
import (
"context"
"database/sql"
"fmt"
"go_control/users/internal/types"
"strings"
"time"
"github.com/zeromicro/go-zero/core/stores/builder"
"github.com/zeromicro/go-zero/core/stores/sqlc"
"github.com/zeromicro/go-zero/core/stores/sqlx"
"github.com/zeromicro/go-zero/core/stringx"
)
var (
backgroundParentPageFieldNames = builder.RawFieldNames(&BackgroundParentPage{})
backgroundParentPageRows = strings.Join(backgroundParentPageFieldNames, ",")
backgroundParentPageRowsExpectAutoSet = strings.Join(stringx.Remove(backgroundParentPageFieldNames, "`id`", "`create_at`", "`create_time`", "`created_at`", "`update_at`", "`update_time`", "`updated_at`"), ",")
backgroundParentPageRowsWithPlaceHolder = strings.Join(stringx.Remove(backgroundParentPageFieldNames, "`id`", "`create_at`", "`create_time`", "`created_at`", "`update_at`", "`update_time`", "`updated_at`"), "=?,") + "=?"
)
type (
backgroundParentPageModel interface {
Insert(ctx context.Context, data *BackgroundParentPage) (sql.Result, error)
FindOne(ctx context.Context, id int64) (*BackgroundParentPage, error)
Update(ctx context.Context, data *BackgroundParentPage) error
Delete(ctx context.Context, id int64) error
Page(ctx context.Context, page, perpage int64) (*types.ShowParentPageReply, error)
}
defaultBackgroundParentPageModel struct {
conn sqlx.SqlConn
table string
}
BackgroundParentPage struct {
Id int64 `db:"id"`
Component sql.NullString `db:"component"`
Name sql.NullString `db:"name"`
Title sql.NullString `db:"title"`
Icon sql.NullString `db:"icon"`
Path sql.NullString `db:"path"`
Redirect sql.NullString `db:"redirect"`
IsCache sql.NullString `db:"is_cache"`
Score sql.NullInt64 `db:"score"`
Status sql.NullInt64 `db:"status"`
CreatedTime time.Time `db:"created_time"`
UpdatedTime time.Time `db:"updated_time"`
Remarks sql.NullString `db:"remarks"`
}
PageBackgroundParentPage struct {
Id int64 `db:"id"`
Component string `db:"component"`
Name string `db:"name"`
Title string `db:"title"`
Icon string `db:"icon"`
Path string `db:"path"`
Redirect string `db:"redirect"`
IsCache string `db:"is_cache"`
Score int64 `db:"score"`
Status int64 `db:"status"`
CreatedTime time.Time `db:"created_time"`
UpdatedTime time.Time `db:"updated_time"`
Remarks string `db:"remarks"`
}
)
func newBackgroundParentPageModel(conn sqlx.SqlConn) *defaultBackgroundParentPageModel {
return &defaultBackgroundParentPageModel{
conn: conn,
table: "`backgroundParentPage`",
}
}
func (m *defaultBackgroundParentPageModel) Page(ctx context.Context, page, perpage int64) (*types.ShowParentPageReply, error) {
countQuery := fmt.Sprintf("SELECT COUNT(*) FROM %s", m.table)
var total int64
err := m.conn.QueryRow(&total, countQuery)
if err != nil {
return nil, err
}
offset := (page - 1) * perpage
dataQuery := fmt.Sprintf("SELECT %s FROM %s LIMIT ? OFFSET ?", backgroundParentPageRows, m.table)
var items []PageBackgroundParentPage
err = m.conn.QueryRows(&items, dataQuery, perpage, offset)
if err != nil {
return nil, err
}
response := &types.ShowParentPageReply{
ParentPagedata: items,
Pagedata: types.BeCurrentShowReq{
Page: page,
PerPage: perpage,
Total: total,
},
}
return response, nil
}
func (m *defaultBackgroundParentPageModel) Delete(ctx context.Context, id int64) error {
query := fmt.Sprintf("delete from %s where `id` = ?", m.table)
_, err := m.conn.ExecCtx(ctx, query, id)
return err
}
func (m *defaultBackgroundParentPageModel) FindOne(ctx context.Context, id int64) (*BackgroundParentPage, error) {
query := fmt.Sprintf("select %s from %s where `id` = ? limit 1", backgroundParentPageRows, m.table)
var resp BackgroundParentPage
err := m.conn.QueryRowCtx(ctx, &resp, query, id)
switch err {
case nil:
return &resp, nil
case sqlc.ErrNotFound:
return nil, ErrNotFound
default:
return nil, err
}
}
func (m *defaultBackgroundParentPageModel) Insert(ctx context.Context, data *BackgroundParentPage) (sql.Result, error) {
query := fmt.Sprintf("insert into %s (%s) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", m.table, backgroundParentPageRowsExpectAutoSet)
ret, err := m.conn.ExecCtx(ctx, query, data.Component, data.Name, data.Title, data.Icon, data.Path, data.Redirect, data.IsCache, data.Score, data.Status, data.CreatedTime, data.UpdatedTime, data.Remarks)
return ret, err
}
func (m *defaultBackgroundParentPageModel) Update(ctx context.Context, data *BackgroundParentPage) error {
query := fmt.Sprintf("update %s set %s where `id` = ?", m.table, backgroundParentPageRowsWithPlaceHolder)
_, err := m.conn.ExecCtx(ctx, query, data.Component, data.Name, data.Title, data.Icon, data.Path, data.Redirect, data.IsCache, data.Score, data.Status, data.CreatedTime, data.UpdatedTime, data.Remarks, data.Id)
return err
}
func (m *defaultBackgroundParentPageModel) tableName() string {
return m.table
}
api 定义
BeCurrentShowReq {
PerPage int64 `form:"per_page"`
Page int64 `form:"page"`
Total int64 `form:"total"`
}
ShowParentPageReply {
ParentPagedata interface{} `json:"parents"`
Pagedata BeCurrentShowReq `json:"page_data"`
}
@handler ShowParentPage
get /user/ShowParentPage (BeCurrentShowReq) returns (ShowParentPageReply)
view
package logic
import (
"context"
"go_control/users/internal/svc"
"go_control/users/internal/types"
"github.com/zeromicro/go-zero/core/logx"
)
type ShowParentPageLogic struct {
logx.Logger
ctx context.Context
svcCtx *svc.ServiceContext
}
func NewShowParentPageLogic(ctx context.Context, svcCtx *svc.ServiceContext) *ShowParentPageLogic {
return &ShowParentPageLogic{
Logger: logx.WithContext(ctx),
ctx: ctx,
svcCtx: svcCtx,
}
}
func (l *ShowParentPageLogic) ShowParentPage(req *types.BeCurrentShowReq) (resp *types.ShowParentPageReply, err error) {
res, err := l.svcCtx.ParentRoute.Page(l.ctx, req.Page, req.PerPage)
return res, err
}