mcos / schemabuf

Generate a protocol buffer schema from a MySQL database schema

schemabuf

Generates a protobuf schema from your mysql database schema.

Uses

Use from the command line:

go install github.com/mcos/schemabuf

$ schemabuf -h

Usage of schemabuf:
  -db string
        the database type (default "mysql")
  -host string
        the database host (default "localhost")
  -ignore_tables string
        a comma spaced list of tables to ignore
  -package string
        the protocol buffer package. defaults to the database schema. (default "db_name")
  -password string
        the database password (default "root")
  -port int
        the database port (default 3306)
  -schema string
        the database schema (default "db_name")
  -user string
        the database user (default "root")

$ schemabuf -host my.database.com -port 3307 -user foo -schema bar -package my_package -ignore_tables=billing,passwords > foobar.proto

Use as an imported library

import "github.com/mcos/schemabuf"

func main() {
    connStr := config.get("dbConnStr")
    pkg := "my_package"

    db, err := sql.Open(*dbType, connStr)
    if err != nil {
        log.Fatal(err)
    }

    defer db.Close()

    s, err := schemabuf.GenerateSchema(db, pkg, nil)

	if nil != err {
		log.Fatal(err)
	}

	if nil != s {
		fmt.Println(s)
	}
}

schemabuf's Issues

hi,i got an question for golang project.

language: golang
i generate proto file . contain text as follow:
google.protobuf.Timestamp create_time = 19;
google.protobuf.Timestamp update_time = 20;

but when i build my golang project. can.'t find
*protobuf.Timestamp this type. the reason is that author of this repositor can't exist go file from protoFile.
How can I solve this problem?
----- i use ci-cd,so it's not good by Manually generating

Skip/discard singularize message name (table name)

If I have 2 tables with similar names, eg: some_type and some_types, then I get only one message named SomeType, with all fields are merged from 2 tables above.

Obviously, some errors like schema.proto:6176:9: "id" is already defined in "schema.SomeType". occurred when I used it with protoc command.

Feature Request: Support CRUD operations for all tables.

I would like to see this repo generate CRUD RPCs for each table without joins.

add custom comment to fields of messages

To hook to generate custom tags in protobuf

hi，i got an question about golang.

language: golang
i generate proto file . contain text as follow:
google.protobuf.Timestamp create_time = 19;
google.protobuf.Timestamp update_time = 20;

but when i build my golang project. can.'t find
*protobuf.Timestamp this type. the reason is that author of this repositor can't exist go file from protoFile.
How can I solve this problem?
----- i use ci-cd,so it's not good by Manually generating

Implement Go modules and drop glide.

Support for "json" type in mysql

Currently, I got the error:

no compatible protobuf type found for `json`. column: `table_name`.`col_name`

Add option to set value to go_package option