Generates a protobuf file from your mysql database.
Tips: If your operating system is windows, the default encoding of windows command line is "GBK", you need to change it to "UTF-8", otherwise the generated file will be messed up.
go install github.com/yanshicheng/sql2pb@latest
❯ sql2pb -h
Usage of sql2pb:
-db string
the database type (default "mysql")
-field_style string
gen protobuf field style, sql_pb | sqlPb (default "sqlPb")
-go_package string
the protocol buffer go_package. defaults to the database schema.
-host string
the database host (default "localhost")
-ignore_columns string
a comma spaced list of mysql columns to ignore
-ignore_tables string
a comma spaced list of tables to ignore
-output_file string
the output file path
-package string
the protocol buffer package. defaults to the database schema.
-password string
the database password
-port int
the database port (default 3306)
-schema string
the database schema
-service_name string
the protobuf service name , defaults to the database schema.
-table string
the table schema，multiple tables ',' split. (default "*")
-user string
the database user (default "root")
$ sql2pb -go_package ./pb -host localhost -package pb -password root -port 3306 -schema usercenter -service_name usersrv -user root --output_file usersrv.proto
$ go get -u github.com/yanshicheng/sql2pb@latest
git tag -d latest
git tag latest
git push origin :refs/tags/latest
git push origin latest
git tag v2
git push origin v2Mikaelemmmm : github.com/Mikaelemmmm/sql2pb/core
schemabuf : https://github.com/mcos/schemabuf
