在gva框架下自己手动实现一个CRUD的操作该操作将会结合gen进行探讨学习具体实现可以看下面代码的实现项目目录层级分为api层service层model层common层router层gen层。

我的这个实现方式有些许不太一样就是我的修改并非传统的restful风格通过json方式进行传递这个id也确保安全所以这里的请求我不会用Get请求。

创建一个Banner

在gva下的server文件夹中找到plugin文件然后在这里创建一个banner文件夹我们的手动CRUD实现的代码就放置在这里查看项目目录结构banner包的路径是/server/plugin/banner。

model层

在model层中我们分为前端请求的参数request以及后端返回的只response。

在我们的model下会有一个创建表的结构体也就是对应数据库字段的一个struct

package

github.com/flipped-aurora/gin-vue-admin/server/globaltype

Banner

gorm:column:url;comment:图片地址Path

string

gorm:column:path;comment:轮播图跳转地址Description

string

gorm:column:description;comment:轮播介绍

model.request层

(github.com/flipped-aurora/gin-vue-admin/server/plugin/banner/commongithub.com/flipped-aurora/gin-vue-admin/server/plugin/banner/modelgithub.com/flipped-aurora/gin-vue-admin/server/plugin/banner/model/daogorm.io/gen

)type

gorm:column:url;comment:图片地址Path

string

gorm:column:path;comment:轮播图跳转地址Description

string

gorm:column:description;comment:轮播介绍

}func

gorm:column:url;comment:图片地址Path

string

gorm:column:path;comment:轮播图跳转地址Description

string

gorm:column:description;comment:轮播介绍

}func

gorm:column:url;comment:图片地址Path

string

gorm:column:path;comment:轮播图跳转地址Description

string

gorm:column:description;comment:轮播介绍

}func

tx.Where(dao.Banner.Url.Eq(r.Url))}if

r.Path

tx.Where(dao.Banner.Path.Eq(r.Path))}if

r.Description

tx.Where(dao.Banner.Description.Eq(r.Description))}return

tx}

gorm:column:url;comment:图片地址Path

string

gorm:column:path;comment:轮播图跳转地址Description

string

gorm:column:description;comment:轮播介绍

}gen层

可以查看gorm的gen的使用文档地址https://gorm.io/gen/

具体详细的看gorm的文档地址关于gen的相关使用可以看目录结构我的文件存放地

gen是基于gorm封装的在我们最后的banner/main.go中需要装配一下传入db,判断有没有db没有db的调用需要传入db。

get

(github.com/flipped-aurora/gin-vue-admin/server/plugin/banner/modelospath/filepathgorm.io/gen

)//

gen.WithQueryInterface,FieldCoverable:

true,WithUnitTest:

挂在自己的结构体在这里根据自己的业务而定g.ApplyBasic(new(model.Banner),)g.Execute()

}common层

common层一般是放置一些公共资源需要使用的比如一些返回信息雪花算法生成id等。

common.common.go

tx.Offset(offset).Limit(c.PageSize)}

}type

(contextgithub.com/flipped-aurora/gin-vue-admin/server/plugin/banner/commongithub.com/flipped-aurora/gin-vue-admin/server/plugin/banner/modelgithub.com/flipped-aurora/gin-vue-admin/server/plugin/banner/model/daogithub.com/flipped-aurora/gin-vue-admin/server/plugin/banner/model/requestgithub.com/pkg/errors

)var

dao.Q.WithContext(ctx).Bannerquery

query.Scopes(info.Search())count,

err

query.Scopes(info.Paginate()).Find()if

err

dao.Q.WithContext(ctx).Bannerentity,

err

query.Where(dao.Banner.ID.Eq(info.ID)).First()if

err

dao.Q.WithContext(ctx).Bannererr

err

dao.Q.WithContext(ctx).Banner_,

err

query.Where(dao.Banner.ID.Eq(info.ID)).Updates(update)if

err

dao.Q.WithContext(ctx).Banner_,

err

query.Where(dao.Banner.ID.Eq(info.ID)).Delete()if

err

dao.Q.WithContext(ctx).Banner_,

err

query.Where(dao.Banner.ID.In(info.IDs...)).Delete()if

err

(github.com/flipped-aurora/gin-vue-admin/server/plugin/banner/commongithub.com/flipped-aurora/gin-vue-admin/server/plugin/banner/model/requestgithub.com/flipped-aurora/gin-vue-admin/server/plugin/banner/responsegithub.com/flipped-aurora/gin-vue-admin/server/plugin/banner/servicegithub.com/gin-gonic/ginnet/http

)var

service.Banner.List(c.Request.Context(),

list)if

http.StatusInternalServerError,

Message:

service.Banner.First(c.Request.Context(),

info)if

http.StatusInternalServerError,

Message:

service.Banner.Create(c.Request.Context(),

create)if

http.StatusInternalServerError,

Message:

service.Banner.Update(c.Request.Context(),

update)if

http.StatusInternalServerError,

Message:

service.Banner.Delete(c.Request.Context(),

info)if

http.StatusInternalServerError,

Message:

service.Banner.Deletes(c.Request.Context(),

info)if

http.StatusInternalServerError,

Message:

(github.com/flipped-aurora/gin-vue-admin/server/middlewaregithub.com/flipped-aurora/gin-vue-admin/server/plugin/banner/apigithub.com/flipped-aurora/gin-vue-admin/server/plugin/banner/responsegithub.com/gin-gonic/gin

)type

response.Handler()(api.Banner.List))group.POST(first,

response.Handler()(api.Banner.First))}{

带日志中间件group.Use(middleware.OperationRecord())group.POST(create,

response.Handler()(api.Banner.Create))group.PUT(update,

response.Handler()(api.Banner.Update))group.DELETE(delete,

response.Handler()(api.Banner.Delete))group.DELETE(deletes,

response.Handler()(api.Banner.Deletes))}

}banner/main.go

(github.com/flipped-aurora/gin-vue-admin/server/globalgithub.com/flipped-aurora/gin-vue-admin/server/plugin/banner/model/daogithub.com/flipped-aurora/gin-vue-admin/server/plugin/banner/routergithub.com/gin-gonic/gin

)var

{router.NewBanner(group).Init()//

这里需要自动装配一下调用dbif

{dao.SetDefault(global.GVA_DB)}

}func