xorm自動生成model檔案
進入專案根目錄
luwei@luweideMacBook-Pro-2 go-simple-task % pwd
/Users/myself/Golang/common_project/src/go-simple-task
luwei@luweideMacBook-Pro-2 go-simple-task % ls
Dockerfile go-simple-task go.mod go.sum logic logs main.go model models overall serv templates tool
luwei@luweideMacBook-Pro-2 go-simple-task %
- 如果沒有go-sql-driver/mysql就先安裝
go get -u github.com/go-sql-driver/mysql
- 安裝xorm,在cmd命令列下
go get github.com/go-xorm/xorm
- 再安裝xorm的cmd命令工具
go get github.com/go-xorm/cmd/xorm
- 安裝 cmd 報錯處理
luwei@luweideMacBook-Pro-2 go-simple-task % go get github.com/go-xorm/cmd/xorm # github.com/go-xorm/cmd/xorm ../../pkg/mod/github.com/go-xorm/cmd/xorm@v0.0.0-20190426080617-f87981e709a1/dump.go:45:26: cannot use "github.com/go-xorm/core".LOG_UNKNOWN (type "github.com/go-xorm/core".LogLevel) as type "xorm.io/core".LogLevel in argument to engine.Logger().SetLevel ../../pkg/mod/github.com/go-xorm/cmd/xorm@v0.0.0-20190426080617-f87981e709a1/reverse.go:246:34: cannot use tables (type []*"xorm.io/core".Table) as type []*"github.com/go-xorm/core".Table in argument to langTmpl.GenImports ../../pkg/mod/github.com/go-xorm/cmd/xorm@v0.0.0-20190426080617-f87981e709a1/reverse.go:254:18: cannot use table (type *"xorm.io/core".Table) as type *"github.com/go-xorm/core".Table in append ../../pkg/mod/github.com/go-xorm/cmd/xorm@v0.0.0-20190426080617-f87981e709a1/reverse.go:291:26: cannot use table (type *"xorm.io/core".Table) as type *"github.com/go-xorm/core".Table in slice literal ../../pkg/mod/github.com/go-xorm/cmd/xorm@v0.0.0-20190426080617-f87981e709a1/shell.go:60:26: cannot use "github.com/go-xorm/core".LOG_UNKNOWN (type "github.com/go-xorm/core".LogLevel) as type "xorm.io/core".LogLevel in argument to engine.Logger().SetLevel ../../pkg/mod/github.com/go-xorm/cmd/xorm@v0.0.0-20190426080617-f87981e709a1/source.go:45:26: cannot use "github.com/go-xorm/core".LOG_UNKNOWN (type "github.com/go-xorm/core".LogLevel) as type "xorm.io/core".LogLevel in argument to engine.Logger().SetLevel luwei@luweideMacBook-Pro-2 go-simple-task %
跳出專案目錄執行,完了再跳回去
luwei@luweideMacBook-Pro-2 go-simple-task % cd ../ luwei@luweideMacBook-Pro-2 src % go get github.com/go-xorm/cmd/xorm luwei@luweideMacBook-Pro-2 src %
在專案目錄下建立 templates/goxorm 資料夾
- 這個檔案下建立config和struct.go.tpl檔案.
- 模板內容可以根據你自己的需要修改
- config內容如下
lang=go genJson=1 prefix=
- struct.go.tpl內容如下
package {{.Models}}
{{$ilen := len .Imports}}
{{if gt $ilen 0}}
import (
{{range .Imports}}"{{.}}"{{end}}
)
{{end}}
{{range .Tables}}
type {{Mapper .Name}} struct {
{{$table := .}}
{{range .ColumnsSeq}}{{$col := $table.GetColumn .}} {{Mapper $col.Name}} {{Type $col}} {{Tag $table $col}}
{{end}}
}
{{end}}
- 最後執行命令
程式會在當前目錄下生成models資料夾,並在models資料夾中生成go檔案
xorm reverse mysql root:root@/fox?charset=utf8 templates/goxorm
執行報錯
luwei@luweideMacBook-Pro-2 go-simple-task % xorm reverse mysql root:123456@/bubble?charset=utf8 templates/goxorm
zsh: no matches found: root:123456@/bubble?charset=utf8
- 解決方案
vim ~/.zshrc
- 在~/.zshrc中加入:
setopt no_nomatch
- 檢查一下
luwei@luweideMacBook-Pro-2 go-simple-task % cat ~/.zshrc source ~/.bash_profile export GOPROXY=https://goproxy.io,direct setopt no_nomatch
- 最後執行
source ~/.zshrc
再次執行
luwei@luweideMacBook-Pro-2 go-simple-task % xorm reverse mysql root:123456@/bubble?charset=utf8 templates/goxorm
luwei@luweideMacBook-Pro-2 go-simple-task %
剩下就是把models裡的內容賦值到model 對應的model裡面了
本作品採用《CC 協議》,轉載必須註明作者和本文連結