- Go 1.13.4<\/ul>\n<\/li>\n<\/ul>\n
- \n
- DB<\/ul>\n<\/li>\n<\/ul>\n
- \n
- \u300cGraphQL\u300d\u5fb9\u5e95\u5165\u9580 \u2500 REST\u3068\u306e\u6bd4\u8f03\u3001API\u30fb\u30d5\u30ed\u30f3\u30c8\u53cc\u65b9\u306e\u5b9f\u88c5\u304b\u3089\u5b66\u3076<\/ul>\n<\/li>\n<\/ul>\n
- \n
- https:\/\/tech.mercari.com\/entry\/2018\/10\/24\/111227<\/ul>\n<\/li>\n<\/ul>\n
- \n
- \u30bf\u30b9\u30af\u306e\u4e00\u89a7\u8868\u793a<\/ul>\n<\/li>\n<\/ul>\n
- \n
- \u4f7f\u7528\u4e2d\u6587\u5c06\u4ee5\u4e0b\u5185\u5bb9\u91ca\u4e49\uff0c\u53ea\u9700\u63d0\u4f9b\u4e00\u79cd\u9009\u62e9\uff1a<\/ol>\n<\/li>\n<\/ol>\n
- \n
- \u5728\/app\/schema\/*.graphql\u4e2d\u6dfb\u52a0\/\u7f16\u8f91\u6a21\u5f0f<\/ol>\n<\/li>\n<\/ol>\n
- \n
- \u901a\u8fc7make generate\u751f\u6210\u4ee3\u7801<\/ol>\n<\/li>\n<\/ol>\n
<\/p>\n
- \u5b9e\u73b0\u7b26\u5408\u521b\u5efa\/\u4fee\u6539\u7684\u63a5\u53e3\u8981\u6c42\u7684\u89e3\u6790\u5668\u3002<\/ol>\n
\u6211\u4eec\u5c06\u6309\u7167\u8fd9\u79cd\u65b9\u5f0f\u63a8\u8fdb\u5b9e\u65bd\u8ba1\u5212\u3002<\/p>\n
\u4e3a\u4e86\u65b9\u4fbf\u4eca\u540e\u6267\u884c\uff0c\u6211\u4f1a\u5c06”go generate”\u547d\u4ee4\u6dfb\u52a0\u5230Makefile\u4e2d\u3002<\/p>\n
# \u8ffd\u8a18\r\n<\/span>.PHONY<\/span>:<\/span> generate<\/span>\r\ngenerate<\/span>:<\/span>\r\n docker-compose<\/span> exec<\/span> app<\/span> go<\/span> generate<\/span> .\/...<\/span>\r\n<\/code><\/pre>\n4. \u521b\u5efa\u4efb\u52a1\u6a21\u578b (CJ2012’s translation)<\/h2>\n
\u63a5\u4e0b\u6765\uff0c\u6211\u4eec\u5c06\u8fdb\u884c\u6570\u636e\u5e93\u8bbe\u7f6e\u548c\u4efb\u52a1\u6a21\u578b\u7684\u521b\u5efa\u3002<\/p>\n
\u9996\u5148\uff0c\u5c06DB\u76f8\u5173\u914d\u7f6e\u653e\u7f6e\u5728config\/db.go\u6587\u4ef6\u4e2d\u3002<\/p>\n
config\/db.godb.go \u5305 config<\/p>\n\u5bfc\u5165 (
\n“fmt”
\n“os”<\/p>\n_ “github.com\/go-sql-driver\/mysql”<\/p>\n
“github.com\/jinzhu\/gorm”
\n_ “github.com\/jinzhu\/gorm\/dialects\/mysql”
\n)<\/p>\nvar db *gorm.DB<\/p>\n
func InitDB() error {
\nconn, err := gorm.Open(“mysql”, dbsn())
\nif err != nil {
\nreturn err
\n}<\/p>\ndb = conn.Set(“gorm:auto_update”, false)<\/p>\n
return nil
\n}<\/p>\nfunc dbsn() string {
\nreturn fmt.Sprintf(
\n“%s:%s@tcp(%s:%s)\/%s?charset=utf8mb4&parseTime=True&loc=Local”,
\nos.Getenv(“DB_USER”),
\nos.Getenv(“DB_PASSWORD”),
\nos.Getenv(“DB_HOST”),
\nos.Getenv(“DB_PORT”),
\nos.Getenv(“DB_NAME”),
\n)
\n}<\/p>\nfunc DB() *gorm.DB {
\nreturn db
\n}<\/p>\nmain.go
\n…
\nfunc main() {
\ne := echo.New()<\/p>\n\u5982\u679c\u53d1\u751f\u9519\u8bef := config.InitDB(); \u9519\u8bef != nil {
\n\u53d1\u751f\u9519\u8bef(err.Error())
\n}
\n…<\/p>\n<\/details>\n\u63a5\u7740\uff0c\u5728 model\/task.go \u4e2d\u521b\u5efa Task \u6a21\u578b\u3002<\/p>\n
\u6a21\u578b\/\u4efb\u52a1.go\u5728\u6a21\u578b\/\u4efb\u52a1.go\u4e2d\u521b\u5efa\u4efb\u52a1\u6a21\u578b\u3002
\n\u5e76\u4e14\uff0c\u4f7f\u7528GORM\u7684BeforeSave\u94a9\u5b50\u8fdb\u884c\u7ed3\u6784\u4f53\u9a8c\u8bc1\u3002
\n\u9a8c\u8bc1\u5668\u7684\u521d\u59cb\u5316\u5728\u6a21\u578b\/\u6a21\u578b.go\u4e2d\u8fdb\u884c\u3002<\/p>\n\u6a21\u578b\/\u4efb\u52a1.go
\npackage \u6a21\u578b<\/p>\nimport “time”<\/p>\n
type \u4efb\u52a1 struct {
\nID int
\n\u6807\u8bc6\u7b26 string `validate:”required,max=255″`
\n\u6807\u9898 string `validate:”required,max=255″`
\n\u7b14\u8bb0 string `validate:”max=65535″`
\n\u5df2\u5b8c\u6210 bool
\n\u5230\u671f\u65f6\u95f4 *time.Time
\n\u521b\u5efa\u65f6\u95f4 time.Time
\n\u66f4\u65b0\u65f6\u95f4 time.Time
\n\u5220\u9664\u65f6\u95f4 *time.Time
\n}<\/p>\nfunc (t *\u4efb\u52a1) BeforeSave() error {
\nreturn \u9a8c\u8bc1\u5668.Struct(t)
\n}<\/p>\n\u6a21\u578b\/\u6a21\u578b.go
\npackage \u6a21\u578b<\/p>\nimport (
\nv “gopkg.in\/go-playground\/validator.v9”
\n)<\/p>\nvar \u9a8c\u8bc1\u5668 *v.Validate<\/p>\n
func init() {
\n\u9a8c\u8bc1\u5668 = v.New()
\n}<\/p>\n<\/details>\n\u63a5\u4e0b\u6765\uff0c\u6211\u4eec\u5c06\u5bf9Tasktype\u8fdb\u884c\u6a21\u5f0f\u6dfb\u52a0\uff0c\u5e76\u5c06\u5176\u4e0e\u521b\u5efa\u7684\u6a21\u578b\u8fdb\u884c\u5173\u8054\u3002<\/p>\n
\u9996\u5148\uff0c\u521b\u5efaschema\/task.graphql\u3002<\/p>\n
<\/p>\n
- \n
- \n
<\/p>\n
- \n
- \n
\u30da\u30fc\u30b8\u30cd\u30fc\u30b7\u30e7\u30f3\u3082\u5b9f\u88c5\u3059\u308b<\/p>\n
\u30bf\u30b9\u30af\u306e\u4e26\u3073\u66ff\u3048<\/p>\n
\u4f5c\u6210\u65e5\u304c\u65b0\u3057\u3044\u9806
\n\u671f\u9650\u304c\u65e9\u3044\u9806<\/p>\n\u30bf\u30b9\u30af\u306e\u4f5c\u6210
\n\u30bf\u30b9\u30af\u306e\u66f4\u65b0<\/p>\n\u5c06\u8fd9\u4e9b\u529f\u80fd\u6620\u5c04\u5230GraphQL\u7684\u6a21\u5f0f\u4e2d\u4f1a\u53d8\u6210\u8fd9\u6837\u3002<\/p>\n
\u6a21\u5f0fschema.graphql
\n\u67e5\u8be2 {
\n\u4efb\u52a1(input: \u4efb\u52a1\u8f93\u5165\uff01, \u6309\u7167: \u4efb\u52a1\u6392\u5e8f\u5b57\u6bb5\uff01, \u5206\u9875: \u5206\u9875\u8f93\u5165\uff01): \u4efb\u52a1\u8fde\u63a5\uff01
\n}<\/p>\n\u53d8\u66f4 {
\n\u521b\u5efa\u4efb\u52a1(\u8f93\u5165: \u521b\u5efa\u4efb\u52a1\u8f93\u5165\uff01): \u4efb\u52a1\uff01
\n\u66f4\u65b0\u4efb\u52a1(\u8f93\u5165: \u66f4\u65b0\u4efb\u52a1\u8f93\u5165\uff01): \u4efb\u52a1\uff01
\n}<\/p>\ntask.graphql
\n\u7c7b\u578b \u4efb\u52a1 \u5b9e\u73b0\u8282\u70b9 {
\nID: ID\uff01
\n\u6807\u9898: String\uff01
\n\u6ce8\u91ca: String\uff01
\n\u5df2\u5b8c\u6210: Boolean\uff01
\n\u622a\u6b62\u65f6\u95f4: \u65f6\u95f4\uff01
\n}
\n\u7c7b\u578b \u4efb\u52a1\u8fb9 \u5b9e\u73b0\u8fb9 {
\n\u6e38\u6807: String\uff01
\n\u8282\u70b9: \u4efb\u52a1\uff01
\n}
\n\u7c7b\u578b \u4efb\u52a1\u8fde\u63a5 \u5b9e\u73b0\u8fde\u63a5 {
\n\u9875\u9762\u4fe1\u606f: \u9875\u4fe1\u606f\uff01
\n\u8fb9: [\u4efb\u52a1\u8fb9]\uff01
\n}<\/p>\n\u8f93\u5165 \u4efb\u52a1\u8f93\u5165 {
\n\u5df2\u5b8c\u6210: Boolean
\n}<\/p>\n\u679a\u4e3e \u4efb\u52a1\u6392\u5e8f\u5b57\u6bb5 {
\n\u6700\u65b0
\n\u622a\u6b62\u65e5\u671f
\n}<\/p>\n\u8f93\u5165 \u521b\u5efa\u4efb\u52a1\u8f93\u5165 {
\n\u6807\u9898: String\uff01
\n\u6ce8\u91ca: String
\n\u5df2\u5b8c\u6210: Boolean
\n\u622a\u6b62\u65f6\u95f4: \u65f6\u95f4
\n}<\/p>\n\u8f93\u5165 \u66f4\u65b0\u4efb\u52a1\u8f93\u5165 {
\n\u4efb\u52a1ID: ID\uff01
\n\u6807\u9898: String
\n\u6ce8\u91ca: String
\n\u5df2\u5b8c\u6210: Boolean
\n\u622a\u6b62\u65f6\u95f4: \u65f6\u95f4
\n}<\/p>\npage.graphql
\n\u7c7b\u578b \u9875\u4fe1\u606f {
\n\u7ed3\u675f\u6e38\u6807: String\uff01
\n\u662f\u5426\u6709\u4e0b\u4e00\u9875: Boolean\uff01
\n}<\/p>\n\u63a5\u53e3 \u8fde\u63a5 {
\n\u9875\u9762\u4fe1\u606f: \u9875\u4fe1\u606f\uff01
\n\u8fb9: [\u8fb9]\uff01
\n}
\n\u63a5\u53e3 \u8fb9 {
\n\u6e38\u6807: String\uff01
\n\u8282\u70b9: \u8282\u70b9\uff01
\n}
\n\u63a5\u53e3 \u8282\u70b9 {
\nID: ID\uff01
\n}<\/p>\n\u8f93\u5165 \u5206\u9875\u8f93\u5165 {
\n\u7b2c\u4e00\u9879: Int
\n\u5728\u4e4b\u540e: String
\n}<\/p>\n<\/details>\n\u5728\u6bcf\u4e2a\u529f\u80fd\u5b9e\u73b0\u7684\u65f6\u5019\uff0c\u6211\u4eec\u5c06\u8be6\u7ec6\u8bf4\u660e\u3002<\/p>\n
\u7136\u540e\uff0c\u6211\u4eec\u4f1a\u7ee7\u7eed\u63a8\u8fdb\u5b9e\u65bd\u3002<\/p>\n
1. \u9879\u76ee\u7684\u8bbe\u7f6e<\/h2>\n
\u9996\u5148\uff0c\u4f7f\u7528Docker\u548cdocker-compose\u6765\u521b\u5efaGo\u7684\u73af\u5883\u3002<\/p>\n
Dockerfile\u4ecegolang:1.13.4-alpine3.10\u4f5c\u4e3a\u6784\u5efa\u73af\u5883<\/p>\n\u5de5\u4f5c\u76ee\u5f55\/app<\/p>\n
\u66f4\u65b0apk\u5e76\u7981\u7528\u7f13\u5b58
\n\u5b89\u88c5git\u3001gcc\u548cmusl-dev<\/p>\n\u590d\u5236go.mod\u548cgo.sum\u6587\u4ef6<\/p>\n
\u8fd0\u884cgo mod download\u547d\u4ee4<\/p>\n
\u590d\u5236\u6240\u6709\u6587\u4ef6<\/p>\n
\u5728Linux\u7cfb\u7edf\u4e0a\u6784\u5efaAMD64\u67b6\u6784\u7684\u5e94\u7528\uff08main.go\uff09\uff0c\u8f93\u51fa\u4e3aapp<\/p>\n
\u5173\u95edGO111MODULE\u5e76\u83b7\u53d6github.com\/oxequa\/realize<\/p>\n
\u5173\u95edGO111MODULE\uff0c\u5e76\u4f7f\u7528’tags mysql’\u53c2\u6570\uff0c\u83b7\u53d6github.com\/golang-migrate\/migrate\/cmd\/migrate\u7684\u6700\u65b0\u7248\u672c<\/p>\n<\/details>\n
docker-compose.yml
\n—
\n\u7248\u672c: ‘3.7’\u670d\u52a1:
\n\u5e94\u7528\u7a0b\u5e8f:
\n\u5bb9\u5668\u540d\u79f0: graphql-app-backend
\n\u6784\u5efa:
\n\u4e0a\u4e0b\u6587: .\/app
\n\u76ee\u6807: \u6784\u5efa
\n\u6302\u8f7d:
\n– .\/app:\/app
\n\u73af\u5883\u53d8\u91cf:
\nDB_HOST: db
\nDB_PORT: 3306
\nDB_USER: root
\nDB_PASSWORD: root
\nDB_NAME: graphql-app-development
\n\u7aef\u53e3:
\n– 3000:3000
\n\u4f9d\u8d56:
\n– db
\n\u94fe\u63a5:
\n– db
\n\u7ec8\u7aef: true<\/p>\n\u6570\u636e\u5e93:
\n\u5bb9\u5668\u540d\u79f0: graphql-app-db
\n\u955c\u50cf: mysql:8.0.13
\n\u6302\u8f7d:
\n– .\/db\/mysql\/data:\/var\/lib\/mysql
\n– .\/db\/mysql\/my.cnf:\/etc\/mysql\/conf.d\/my.cnf
\n\u73af\u5883\u53d8\u91cf:
\nMYSQL_USER: root
\nMYSQL_ROOT_PASSWORD: root
\nMYSQL_DATABASE: graphql-app-development
\n\u7aef\u53e3:
\n– 3306:3306
\n\u7ec8\u7aef: true<\/p>\n<\/details>\n\u8fdb\u884cGo\u6a21\u5757\u7684\u8bbe\u7f6e\uff0c\u5e76\u4f7f\u7528echo\u521b\u5efa\u4e00\u4e2a\u7b80\u5355\u7684HTTP\u670d\u52a1\u5668\u3002<\/p>\n
\u4e3b\u8981.go\u4f7f\u7528 echo \u521b\u5efa\u4e00\u4e2a\u7b80\u5355\u7684 HTTP \u670d\u52a1\u5668\u3002
\n\u6709\u5173\u6bcf\u4e2a\u4e2d\u95f4\u4ef6\u7684\u8be6\u7ec6\u4fe1\u606f\uff0c\u8bf7\u53c2\u9605 echo \u7684\u6587\u6863
\nhttps:\/\/echo.labstack.com\/middleware<\/p>\n\u4e3b\u8981.go
\n\u5305\u4e3b\u8981<\/p>\n\u5bfc\u5165 (
\n“net\/http”<\/p>\n“github.com\/labstack\/echo”
\n“github.com\/labstack\/echo\/middleware”
\n)<\/p>\n\u529f\u80fd\u4e3b\u8981() {
\ne := echo.New()<\/p>\ne.Use(middleware.Recover())
\ne.Use(middleware.Logger())
\ne.Use(middleware.Gzip())<\/p>\ne.Use(middleware.CORSWithConfig(middleware.CORSConfig{
\nAllowOrigins: []string{os.Getenv(“CORS_ALLOW_ORIGIN”)},
\nAllowHeaders: []string{echo.HeaderOrigin, echo.HeaderContentType, echo.HeaderAccept},
\n}))<\/p>\ne.GET(“\/health”, func(c echo.Context) error {
\n\u8fd4\u56de c.NoContent(http.StatusOK)
\n})<\/p>\ne.HideBanner = true
\ne.Logger.Fatal(e.Start(“:3000”))
\n}<\/p>\n<\/details>\n\u4e3a\u4e86\u8fdb\u884c\u6b63\u5728\u5f00\u53d1\u7684\u70ed\u91cd\u8f7d\uff0c\u4e5f\u8981\u914d\u7f6erealize\u7684\u8bbe\u7f6e\u6587\u4ef6\u3002<\/p>\n
\u5b9e\u73b0.yml\u5b9e\u73b0.yml
\n—
\n\u8bbe\u7f6e:
\n\u65e7\u7248:
\n\u5f3a\u5236\uff1a\u5047
\n\u95f4\u9694\uff1a0\u79d2<\/p>\n\u67b6\u6784\uff1a
\n– \u540d\u79f0\uff1a\u5e94\u7528
\n\u8def\u5f84\uff1a.
\n\u547d\u4ee4\uff1a
\n\u5b89\u88c5\uff1a
\n\u72b6\u6001\uff1a\u771f
\n\u65b9\u6cd5\uff1ago build -o app main.go
\n\u8fd0\u884c\uff1a
\n\u72b6\u6001\uff1a\u771f
\n\u65b9\u6cd5\uff1a.\/app
\n\u89c2\u5bdf\u8005\uff1a
\n\u6269\u5c55\u540d\uff1a
\n– go
\n\u8def\u5f84\uff1a
\n– \/
\n\u5ffd\u7565\u7684\u8def\u5f84\uff1a
\n– .realize<\/p>\n<\/details>\n\u5c06\u670d\u52a1\u5668\u7684\u542f\u52a8\u548c\u8fc1\u79fb\u547d\u4ee4\u6574\u7406\u5230Makefile\u4e2d\u3002<\/p>\n
MakefileDB_HOST=db
\nDB_PORT=3306
\nDB_USER=root
\nDB_PASSWORD=root
\nDB_NAME=graphql-app-development
\nDB_CONN=mysql:\/\/${DB_USER}:${DB_PASSWORD}@tcp\\(${DB_HOST}:${DB_PORT}\\)\/${DB_NAME}<\/p>\n.PHONY: run
\nrun:
\ndocker-compose up –build -d<\/p>\n.PHONY: start
\nstart:
\ndocker-compose exec app realize start –run<\/p>\n# \u521b\u5efa\u8fc1\u79fb\u6587\u4ef6
\n.PHONY: migrate-create
\nmigrate-create:
\ndocker-compose exec app migrate create -ext sql -dir migrations ${FILENAME}<\/p>\n# \u6267\u884c\u8fc1\u79fb
\n.PHONY: migrate-up
\nmigrate-up:
\ndocker-compose exec app migrate –source file:\/\/migrations –database ${DB_CONN} up<\/p>\n# \u6267\u884c\u8fc1\u79fb\u56de\u6eda
\n.PHONY: migrate-down
\nmigrate-down:
\ndocker-compose exec app migrate –source file:\/\/migrations –database ${DB_CONN} down 1<\/p>\n<\/details>\n\u6211\u8ba4\u4e3a\u6587\u4ef6\u7ed3\u6784\u4f1a\u662f\u8fd9\u6837\u7684\u6837\u5b50\u3002<\/p>\n
$ <\/span>tree backend\r\n.<\/span>\r\n\u251c\u2500\u2500 .gitignore\r\n\u251c\u2500\u2500 Makefile\r\n\u251c\u2500\u2500 README.md\r\n\u251c\u2500\u2500 app\r\n\u2502 \u251c\u2500\u2500 .realize.yaml\r\n\u2502 \u251c\u2500\u2500 Dockerfile\r\n\u2502 \u251c\u2500\u2500 go.mod\r\n\u2502 \u251c\u2500\u2500 go.sum\r\n\u2502 \u2514\u2500\u2500 main.go\r\n\u251c\u2500\u2500 db\r\n\u2502 \u2514\u2500\u2500 mysql\r\n\u2502 \u2514\u2500\u2500 my.cnf\r\n\u2514\u2500\u2500 docker-compose.yml\r\n<\/code><\/pre>\n\u5728backend\u76ee\u5f55\u4e2d\u6267\u884cmake\u547d\u4ee4\uff0capp\u670d\u52a1\u548cdb\u670d\u52a1\u4f1a\u542f\u52a8\uff0c\u901a\u8fc7\u6267\u884cmake start\u6765\u542f\u52a8\u670d\u52a1\u5668\u5373\u53ef\u3002<\/p>\n
$ <\/span>make start\r\ndocker-compose exec <\/span>app realize start --run<\/span>\r\n[<\/span>14:28:00][APP] : Watching 9 file\/s 6 folder\/s\r\n[<\/span>14:28:00][APP] : Install started\r\n[<\/span>14:28:01][APP] : Install completed in <\/span>0.748 s\r\n[<\/span>14:28:01][APP] : Running..\r\n[<\/span>14:28:02][APP] : \u21e8 http server started on [<\/span>::]:3000\r\n<\/code><\/pre>\n\u521b\u5efa tasks \u8868<\/h2>\n
\u63a5\u4e0b\u6765\uff0c\u6211\u4eec\u5c06\u521b\u5efa\u4e00\u4e2a\u7528\u4e8e\u4fdd\u5b58\u4efb\u52a1\u7684tasks\u8868\u3002\u4f7f\u7528\u6211\u4eec\u4e4b\u524d\u5728Makefile\u4e2d\u7f16\u5199\u7684make migrate-create\u547d\u4ee4\u6765\u6267\u884c\uff0c\u4ee5\u521b\u5efa\u7528\u4e8etasks\u8868\u7684\u8fc1\u79fb\u6587\u4ef6\u3002<\/p>\n
$ FILENAME<\/span>=<\/span>create_tasks make migrate-create\r\n<\/code><\/pre>\n\u8fd0\u884c\u540e\uff0c\u5c06\u5728migrations\u76ee\u5f55\u4e0b\u521b\u5efa\u4e24\u4e2a\u6587\u4ef6\uff1a_create_tasks.up.sql\u548c_create_tasks.down.sql\u3002\u60a8\u9700\u8981\u5206\u522b\u5728\u8fd9\u4e24\u4e2a\u6587\u4ef6\u4e2d\u7f16\u5199up\u548cdown\u7684SQL\u8bed\u53e5\u3002<\/p>\n
2019xxxx_create_tasks.up.sql
\n\u521b\u5efa\u8868tasks(
\nid INT \u81ea\u589e,
\nidentifier varchar(255) \u4e8c\u8fdb\u5236 \u975e\u7a7a,
\ntitle varchar(255) \u975e\u7a7a,
\nnotes text \u975e\u7a7a,
\ncompleted tinyint(1) \u975e\u7a7a \u9ed8\u8ba4\u4e3a0,
\ndue timestamp NULL \u9ed8\u8ba4\u4e3aNULL,
\ncreated_at timestamp \u975e\u7a7a,
\nupdated_at timestamp \u975e\u7a7a,
\ndeleted_at timestamp NULL \u9ed8\u8ba4\u4e3aNULL,
\nPRIMARY KEY (id),
\nUNIQUE KEY uix_tasks_identifier (identifier)
\n) ENGINE=InnoDB;2019xxxx_create_tasks.down.sql
\n\u5982\u679c\u5b58\u5728\u5219\u5220\u9664\u8868tasks;<\/p>\n<\/details>\n\u6267\u884cMakefile\u4e2d\u7f16\u5199\u7684migrate-up\u547d\u4ee4\u4ee5\u521b\u5efa\u8868\u3002<\/p>\n
$ <\/span>make migrate-up\r\n<\/code><\/pre>\n\u5982\u679c\u8868\u683c\u662f\u4ee5\u8fd9\u6837\u7684\u65b9\u5f0f\u521b\u5efa\u7684\uff0c\u90a3\u5c31\u53ef\u4ee5\u3002<\/p>\n
mysql<\/span>><\/span> desc<\/span> tasks<\/span>;<\/span>\r\n+<\/span>------------+--------------+------+-----+---------+----------------+<\/span>\r\n|<\/span> Field<\/span> |<\/span> Type<\/span> |<\/span> Null<\/span> |<\/span> Key<\/span> |<\/span> Default<\/span> |<\/span> Extra<\/span> |<\/span>\r\n+<\/span>------------+--------------+------+-----+---------+----------------+<\/span>\r\n|<\/span> id<\/span> |<\/span> int<\/span>(<\/span>11<\/span>)<\/span> |<\/span> NO<\/span> |<\/span> PRI<\/span> |<\/span> NULL<\/span> |<\/span> auto_increment<\/span> |<\/span>\r\n|<\/span> identifier<\/span> |<\/span> varchar<\/span>(<\/span>255<\/span>)<\/span> |<\/span> NO<\/span> |<\/span> UNI<\/span> |<\/span> NULL<\/span> |<\/span> |<\/span>\r\n|<\/span> title<\/span> |<\/span> varchar<\/span>(<\/span>255<\/span>)<\/span> |<\/span> NO<\/span> |<\/span> |<\/span> NULL<\/span> |<\/span> |<\/span>\r\n|<\/span> notes<\/span> |<\/span> text<\/span> |<\/span> NO<\/span> |<\/span> |<\/span> NULL<\/span> |<\/span> |<\/span>\r\n|<\/span> completed<\/span> |<\/span> tinyint<\/span>(<\/span>1<\/span>)<\/span> |<\/span> NO<\/span> |<\/span> |<\/span> 0<\/span> |<\/span> |<\/span>\r\n|<\/span> due<\/span> |<\/span> timestamp<\/span> |<\/span> YES<\/span> |<\/span> |<\/span> NULL<\/span> |<\/span> |<\/span>\r\n|<\/span> created_at<\/span> |<\/span> timestamp<\/span> |<\/span> NO<\/span> |<\/span> |<\/span> NULL<\/span> |<\/span> |<\/span>\r\n|<\/span> updated_at<\/span> |<\/span> timestamp<\/span> |<\/span> NO<\/span> |<\/span> |<\/span> NULL<\/span> |<\/span> |<\/span>\r\n|<\/span> deleted_at<\/span> |<\/span> timestamp<\/span> |<\/span> YES<\/span> |<\/span> |<\/span> NULL<\/span> |<\/span> |<\/span>\r\n+<\/span>------------+--------------+------+-----+---------+----------------+<\/span>\r\n9<\/span> rows<\/span> in<\/span> set<\/span> (<\/span>0<\/span>.<\/span>02<\/span> sec<\/span>)<\/span>\r\n<\/code><\/pre>\n3. gqlgen\u7684\u914d\u7f6e<\/h2>\n
\u63a5\u4e0b\u6765\uff0c\u6211\u4eec\u5c06\u8fdb\u884c gqlgen \u7684\u914d\u7f6e\u3002\u57fa\u672c\u4e0a\u4e0e gqlgen \u7684\u6559\u7a0b\u6ca1\u6709\u4ec0\u4e48\u533a\u522b\u3002<\/p>\n
\u9996\u5148\uff0c\u4f7f\u7528gqlgen init\u547d\u4ee4\u521b\u5efa\u9879\u76ee\u6a21\u677f\u3002<\/p>\n
$ <\/span>docker-compose exec <\/span>app go run github.com\/99designs\/gqlgen init\r\n<\/code><\/pre>\n\u8fd0\u884c\u540e\u5c06\u521b\u5efa\u4ee5\u4e0b\u6587\u4ef6<\/p>\n
gqlgen.yml<\/p>\n
gqlgen\u306e\u8a2d\u5b9a\u30d5\u30a1\u30a4\u30eb<\/p>\n
generated.go<\/p>\n
GraphQL \u3092\u5b9f\u884c\u3059\u308b\u30e9\u30f3\u30bf\u30a4\u30e0 (go generate\u3067\u66f4\u65b0\u3059\u308b)<\/p>\n
models_gen.go<\/p>\n
\u4e0d\u8db3\u3057\u3066\u3044\u308b model (GraphQL \u306e type, input, enum \u306a\u3069) \u306e\u69cb\u9020\u4f53 (go generate\u3067\u66f4\u65b0\u3059\u308b)<\/p>\n
resolver.go<\/p>\n
resolver (\u4eca\u5f8c query, mutation \u3092\u5b9f\u88c5\u3057\u3066\u3044\u304f\u90e8\u5206)<\/p>\n
schema.graphql<\/p>\n
\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u3067\u8a2d\u5b9a\u3055\u308c\u308b Todo \u306a\u3069\u306e GraphQL \u30b9\u30ad\u30fc\u30de\u3092\u5b9a\u7fa9\u3057\u3066\u3044\u308b<\/p>\n
server\/server.go<\/p>\n
\u30b5\u30fc\u30d0\u30fc\u3092\u7acb\u3061\u4e0a\u3052\u3066\u3044\u308b<\/p>\n
\u6211\u4f1a\u5206\u522b\u7f16\u8f91\u5b83\u4eec\u3002<\/p>\n
generated.go \u279d resolver\/generated.go \u306b\u914d\u7f6e\u3057\u3001\u30d1\u30c3\u30b1\u30fc\u30b8\u3092\u5909\u66f4\u3059\u308b<\/p>\n
models_gen.go \u279d model\/models_gen.go \u306b\u914d\u7f6e\u3057\u3001\u30d1\u30c3\u30b1\u30fc\u30b8\u540d\u3092\u5909\u66f4\u3059\u308b<\/p>\n
\u521b\u5efaresolver\/model\u5305\u5e76\u8fdb\u884c\u5206\u5272\u3002gqlgen.yml
\n—
\nschema:
\n– “schema\/*.graphql”<\/p>\nexec:
\nfilename: resolver\/generated.go
\npackage: resolver<\/p>\nmodel:
\nfilename: model\/models_gen.go
\npackage: model<\/p>\nresolver:
\nfilename: resolver\/resolver.go
\ntype: Resolver<\/p>\n<\/details>\n\u5c06resolver.go\u6587\u4ef6\u653e\u7f6e\u5728resolver\/resolver.go\u8def\u5f84\u4e0b\uff0c\u5e76\u8fdb\u884c\u4ee5\u4e0b\u66f4\u6539\uff1aresolver.go
\n\/\/go:generate go run github.com\/99designs\/gqlgen<\/p>\npackage resolver<\/p>\n
type Resolver struct{}<\/p>\n
type queryResolver struct{ *Resolver }
\ntype mutationResolver struct{ *Resolver }<\/p>\nfunc New() *Resolver {
\nreturn &Resolver{}
\n}<\/p>\nfunc (r *Resolver) Mutation() MutationResolver {
\nreturn &mutationResolver{r}
\n}<\/p>\nfunc (r *Resolver) Query() QueryResolver {
\nreturn &queryResolver{r}
\n}<\/p>\n<\/details>\n\u5220\u53bb\u4e0d\u5fc5\u8981\u7684 type\u3001query \u548c mutation\uff0c\u5e76\u5728 schema\/schema.graphql \u4e2d\u6dfb\u52a0\u7a7a\u7684 Query \u548c Mutation\u3002<\/details>\n\u5728 main.go \u4e2d\u6dfb\u52a0\u4ee3\u7801\uff0c\u5c06 server\/server.go \u7684\u5185\u5bb9\u8ffd\u52a0\u8fdb\u53bb\u3002
\n\u5220\u9664 server\/server.go \u6587\u4ef6\uff0c\u5e76\u4e14\u5728 main.go \u4e2d\u6dfb\u52a0\u4ee3\u7801\u4ee5\u542f\u52a8 GraphQL \u670d\u52a1\u5668\u3002
\n\u8fd9\u91cc\u6211\u4eec\u4f7f\u7528\u4e86 \/graphql \u4f5c\u4e3a\u7aef\u70b9\u3002main.go
\npackage main<\/p>\nimport (
\n“app\/resolver”
\n“net\/http”<\/p>\n“github.com\/99designs\/gqlgen\/handler”
\n“github.com\/labstack\/echo”
\n“github.com\/labstack\/echo\/middleware”
\n)<\/p>\nfunc main() {
\ne := echo.New()<\/p>\ne.Use(middleware.Recover())
\ne.Use(middleware.Logger())
\ne.Use(middleware.Gzip())<\/p>\ne.GET(“\/health”, func(c echo.Context) error {
\nreturn c.NoContent(http.StatusOK)
\n})<\/p>\ne.POST(“\/graphql”, func(c echo.Context) error {
\nconfig := resolver.Config{
\nResolvers: resolver.New(),
\n}
\nh := handler.GraphQL(resolver.NewExecutableSchema(config))
\nh.ServeHTTP(c.Response(), c.Request())<\/p>\nreturn nil
\n})<\/p>\ne.HideBanner = true
\ne.Logger.Fatal(e.Start(“:3000”))
\n}<\/p>\n<\/details>\n\u53ea\u8981\u5e94\u7528\u7a0b\u5e8f\u7684\u76ee\u5f55\u7ed3\u6784\u5982\u4e0b\u6240\u793a\uff0c\u5c31\u53ef\u4ee5\u3002<\/p>\n
$ <\/span>tree app\r\n.<\/span>\r\n\u251c\u2500\u2500 .realize.yaml\r\n\u251c\u2500\u2500 Dockerfile\r\n\u251c\u2500\u2500 go.mod\r\n\u251c\u2500\u2500 go.sum\r\n\u251c\u2500\u2500 gqlgen.yml\r\n\u251c\u2500\u2500 main.go\r\n\u251c\u2500\u2500 migrations\r\n\u2502 \u251c\u2500\u2500 <timestamp>_create_tasks.down.sql\r\n\u2502 \u2514\u2500\u2500 <timestamp>_create_tasks.up.sql\r\n\u251c\u2500\u2500 model\r\n\u2502 \u2514\u2500\u2500 models_gen.go\r\n\u251c\u2500\u2500 resolver\r\n\u2502 \u251c\u2500\u2500 generated.go\r\n\u2502 \u2514\u2500\u2500 resolver.go\r\n\u2514\u2500\u2500 schema\r\n \u2514\u2500\u2500 schema.graphql\r\n<\/code><\/pre>\ngqlgen \u7684\u914d\u7f6e\u5df2\u7d93\u5b8c\u6210\u3002\u5f9e\u9019\u88e1\u958b\u59cb\u9032\u884c\u6bcf\u500b\u67e5\u8a62\u548c\u8b8a\u66f4\u7684\u5be6\u73fe\u3002
\n\u57fa\u672c\u4e0a\uff0c\u5f9e\u9019\u88e1\u958b\u59cb\uff0c\u6211\u5011\u6703\u9032\u884c\u6bcf\u500b\u67e5\u8a62\u548c\u8b8a\u66f4\u7684\u5be6\u73fe\u3002<\/p>\n- \n
- \n
<\/p>\n
- https:\/\/tech.mfkessai.co.jp\/2018\/08\/go-gqlgen-graphql\/<\/ul>\n
\u5bf9\u4e8e\u5e94\u7528\u7a0b\u5e8f\u7684\u89c4\u8303<\/h1>\n
\u8fd9\u662f\u4e00\u4e2a\u7b80\u5355\u7684\u4efb\u52a1\u7ba1\u7406\u5e94\u7528\u7a0b\u5e8f\u3002<\/p>\n
\u529f\u80fd\u5217\u8868<\/h4>\n
- \n
- \n
<\/p>\n
- GraphQL Advent Calendar 2019<\/ul>\n
gqlgen \u662f\u4ec0\u4e48\uff1f<\/h1>\n
\u8bf7\u5728\u4e2d\u56fd\u672c\u571f\u4e2d\u6587\u8fdb\u884c\u6539\u8ff0\uff1a\u53ea\u9700\u63d0\u4f9b\u4e00\u79cd\u9009\u9879\uff1a gqldgen.com<\/p>\n
gqlgen\u662f\u4e00\u4e2a\u65b9\u4fbf\u5feb\u6377\u7684Go\u5e93\uff0c\u7528\u4e8e\u6784\u5efaGraphQL\u670d\u52a1\u5668\u3002<\/p><\/blockquote>\n
gqlgen\u662f\u4e00\u500b\u5177\u6709Schema First\u3001\u578b\u5b89\u5168\u548c\u4ee3\u78bc\u751f\u6210\u7279\u6027\u7684Go GraphQL\u670d\u52d9\u5668\u5eab\u3002
\nSchema First\u610f\u5473\u8457\u9996\u5148\u5b9a\u7fa9\u6a21\u5f0f\uff0c\u7136\u5f8c\u751f\u6210\u4ee3\u78bc\u8207\u5be6\u65bd\u5177\u9ad4\u8655\u7406\uff0c\u53ef\u4ee5\u958b\u767c\u76f8\u95dc\u7684\u98a8\u683c\u3002
\n\u8acb\u53c3\u8003gqlgen\u5b98\u65b9\u7db2\u7ad9\u4e0a\u8207\u5176\u4ed6\u4f7f\u7528Go\u7de8\u5beb\u7684GraphQL\u670d\u52d9\u5668\u5eab\u9032\u884c\u6bd4\u8f03\u3002<\/p>\n\u5f15\u5165\u6848\u4f8b<\/p>\n
- \n
- \n
MySQL 8.0.13<\/p>\n
ORM<\/p>\n
jinzhu\/gorm<\/p>\n
http\u30b5\u30fc\u30d0\u30fc<\/p>\n
labstack\/echo<\/p>\n
DB \u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3<\/p>\n
golang-migrate\/migrate<\/p>\n
\u30b5\u30fc\u30d0\u30fc\u306e\u30db\u30c3\u30c8\u30ea\u30ed\u30fc\u30c9<\/p>\n
oxequa\/realize<\/p>\n
struct \u306e\u30d0\u30ea\u30c7\u30fc\u30b7\u30e7\u30f3<\/p>\n
go-playground\/validator<\/p>\n
\u30e6\u30cb\u30fc\u30afID\u306e\u751f\u6210<\/p>\n
teris-io\/shortid<\/p>\n
GraphQL \u662f\u4e00\u79cd\u7528\u4e8e API \u7684\u67e5\u8be2\u8bed\u8a00\u548c\u8fd0\u884c\u65f6\u73af\u5883\u7684\u5f00\u6e90\u89c4\u8303\u3002<\/h1>\n
![\"undefined\"](\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d827b913a08637a6b070b\/8-0.png\" "\\"\\"")
<\/div>\n\u8bf7\u7528\u4e2d\u6587\u5c06\u4ee5\u4e0b\u5185\u5bb9\u91cd\u8ff0\u4e00\u904d\uff1a\u201cgraphql.org\u201d\u3002<\/p>\n
GraphQL \u662f\u7528\u4e8e API \u7684\u67e5\u8be2\u8bed\u8a00\uff0c\u4e5f\u662f\u7528\u73b0\u6709\u6570\u636e\u6765\u6ee1\u8db3\u8fd9\u4e9b\u67e5\u8be2\u7684\u8fd0\u884c\u65f6\u3002GraphQL \u63d0\u4f9b\u4e86\u5bf9 API \u6570\u636e\u7684\u5b8c\u6574\u4e14\u6613\u4e8e\u7406\u89e3\u7684\u63cf\u8ff0\uff0c\u4f7f\u5ba2\u6237\u7aef\u80fd\u591f\u51c6\u786e\u5730\u8bf7\u6c42\u4ed6\u4eec\u6240\u9700\u7684\u6570\u636e\u800c\u4e0d\u9700\u8981\u591a\u4f59\u7684\u4fe1\u606f\uff0c\u4f7f\u5f97 API \u5728\u65f6\u95f4\u4e0a\u66f4\u6613\u4e8e\u6f14\u8fdb\uff0c\u5e76\u63d0\u4f9b\u4e86\u5f3a\u5927\u7684\u5f00\u53d1\u8005\u5de5\u5177\u3002<\/p><\/blockquote>\n
GraphQL\u662f\u4e00\u79cd\u7528\u4e8eAPI\u7684\u67e5\u8be2\u8bed\u8a00\u548c\u5b9e\u73b0\u3002\u5b83\u6700\u521d\u7531Facebook\u5f00\u53d1\u5e76\u5f00\u6e90\uff0c\u76ee\u524d\u7531GraphQL Foundation\u63a8\u52a8\u5f00\u53d1\u3002
\n\u901a\u8fc7\u4f7f\u7528GraphQL\uff0c\u6211\u4eec\u53ef\u4ee5\u4eab\u53d7\u5230\u591a\u79cd\u597d\u5904\uff0c\u5982\u7c7b\u578b\u5b89\u5168\u7684\u8bf7\u6c42\u3001\u7f16\u8f91\u5668\u81ea\u52a8\u8865\u5168\u3001\u6587\u6863\u751f\u6210\u7b49\u5468\u8fb9\u5de5\u5177\u3002<\/p>\n- \n
- \n
<\/p>\n
- \n