Skip to content

keakon/sql-to-struct

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

2 Commits
 
 
 
 
 
 

Repository files navigation

用法

go run . <file_path> [<table_name>] [mode=sql/json/sb/sql+sb/...]

输出所有表

go run . ~/Workspace/db/sql/mysql/createdb.sql  # 改为实际路径

输出指定表

go run . createdb.sql user

设置输出模式

go run . createdb.sql mode=sql+sb

mode 可以为 sqljsonsb,以及它们用 + 连接的组合,默认为 json+sb

示例输出

  • sql
     type User struct {
     	ID       uint32 `db:"id"`
     	TenantID uint16 `db:"tenant_id"`
     }
  • json
     type User struct {
     	ID       uint32 `db:"id" json:"id"`
     	TenantID uint16 `db:"tenant_id" json:"tenant_id"`
     }
  • sb
     type UserTable struct {
     	sb.Table `db:"user"`
     	ID       sb.Column `db:"id"`
     	TenantID sb.Column `db:"tenant_id"`
     }

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages