skylei / gen Goto Github PK

The gen tool produces golang structs from a given database for use in a .go file. It supports gorm tags and implements some usable methods. It can also generate RESTful api for those structs.

By reading details from the database about the column structure, gen generates a go compatible struct type with the required column names, data types, and annotations.

Generated datatypes include support for nullable columns sql.NullX types or guregu null.X types and the expected basic built in go types.

gen is based/inspired by the work of Seth Shelnutt's db2struct, and Db2Struct is based/inspired by the work of ChimeraCoder's gojson package gojson.

go get github.com/smallnest/gen
gen --connstr "root@tcp(127.0.0.1:3306)/employees?&parseTime=True" --database employees  --json --gorm --guregu --rest

Currently Supported

• MariaDB
• MySQL
• PostgreSQL
• Microsoft SQL Server
• SQLite

Planned Support

• Oracle

Structures are created by querying the INFORMATION_SCHEMA.Columns table and then formatting the types, column names, and metadata to create a usable go compatible struct type.

Currently only a limited number of datatypes are supported. Initial support includes:

• tinyint (sql.NullInt64 or null.Int)
• int (sql.NullInt64 or null.Int)
• smallint (sql.NullInt64 or null.Int)
• mediumint (sql.NullInt64 or null.Int)
• bigint (sql.NullInt64 or null.Int)
• decimal (sql.NullFloat64 or null.Float)
• float (sql.NullFloat64 or null.Float)
• double (sql.NullFloat64 or null.Float)
• datetime (null.Time)
• time (null.Time)
• date (null.Time)
• timestamp (null.Time)
• var (sql.String or null.String)
• enum (sql.String or null.String)
• varchar (sql.String or null.String)
• longtext (sql.String or null.String)
• mediumtext (sql.String or null.String)
• text (sql.String or null.String)
• tinytext (sql.String or null.String)
• binary
• blob
• longblob
• mediumblob
• varbinary

• Postgres and SQLite driver support for sql.ColumnType.Nullable() (#3)
• Can not distinguish primay key of tables. Only set the first field as primay key. So you need to change it in some cases.