ddl-maker is generate ddl from Go struct.
_example/example.go
package example
import (
"database/sql"
"time"
"github.com/kayac/ddl-maker/dialect"
"github.com/kayac/ddl-maker/dialect/mysql"
)
type User struct {
Id uint64
Name string
CreatedAt time.Time
UpdatedAt time.Time
Token string `ddl:"-"`
DailyNotificationAt string `ddl:"type=time"`
}
func (u *User) Table() string {
return "player"
}
func (u *User) PrimaryKey() dialect.PrimaryKey {
return mysql.AddPrimaryKey("id")
}
type Entry struct {
Id int32 `ddl:"auto"`
Title string `ddl:"size=100"`
Public bool `ddl:"default=0"`
Content *string `ddl:"type=text"`
CreatedAt time.Time
UpdatedAt time.Time
}
func (e Entry) PrimaryKey() dialect.PrimaryKey {
return mysql.AddPrimaryKey("id", "created_at")
}
func (e Entry) Indexes() dialect.Indexes {
return dialect.Indexes{
mysql.AddUniqueIndex("created_at_uniq_idx", "created_at"),
mysql.AddIndex("title_idx", "title"),
mysql.AddIndex("created_at_idx", "created_at"),
mysql.AddFullTextIndex("full_text_idx", "content").WithParser("ngram"),
}
}
type PlayerComment struct {
Id int32 `ddl:"auto,size=100" json:"id"`
PlayerID int32 `json:"player_id"`
EntryID int32 `json:"entry_id"`
Comment sql.NullString `json:"comment" ddl:"null,size=99"`
CreatedAt time.Time `json:"created_at"`
updatedAt time.Time
}
func (pc PlayerComment) PrimaryKey() dialect.PrimaryKey {
return mysql.AddPrimaryKey("id")
}
func (pc PlayerComment) Indexes() dialect.Indexes {
return dialect.Indexes{
mysql.AddIndex("player_id_entry_id_idx", "player_id", "entry_id"),
}
}
func (pc PlayerComment) ForeignKeys() dialect.ForeignKeys {
return dialect.ForeignKeys{
mysql.AddForeignKey(
[]string{"player_id"},
[]string{"id"},
"player",
),
mysql.AddForeignKey(
[]string{"entry_id"},
[]string{"id"},
"entry",
),
}
}
type Bookmark struct {
Id int32 `ddl:"size=100" json:"id"`
UserId int32 `json:"user_id"`
EntryId int32 `json:"entry_id"`
CreatedAt time.Time `json:"created_at"`
UpdatedAt time.Time `json:"updated_at"`
}
func (b Bookmark) PrimaryKey() dialect.PrimaryKey {
return mysql.AddPrimaryKey("id")
}
func (b Bookmark) Indexes() dialect.Indexes {
return dialect.Indexes{
mysql.AddUniqueIndex("user_id_entry_id", "user_id", "entry_id"),
}
}
func (b Bookmark) ForeignKeys() dialect.ForeignKeys {
return dialect.ForeignKeys{
mysql.AddForeignKey(
[]string{"player_id"},
[]string{"id"},
"player",
),
mysql.AddForeignKey(
[]string{"entry_id"},
[]string{"id"},
"entry",
),
}
}_example/create_ddl/create_ddl.go
package main
import (
"flag"
"log"
"github.com/kayac/ddl-maker"
ex "github.com/kayac/ddl-maker/_example"
)
func main() {
var (
driver string
engine string
charset string
outFilePath string
)
flag.StringVar(&driver, "d", "", "set driver")
flag.StringVar(&driver, "driver", "", "set driver")
flag.StringVar(&outFilePath, "o", "./sql/master.sql", "set ddl output file path")
flag.StringVar(&outFilePath, "outfile", "./sql/master.sql", "set ddl output file path")
flag.StringVar(&engine, "e", "InnoDB", "set driver engine")
flag.StringVar(&engine, "engine", "InnoDB", "set driver engine")
flag.StringVar(&charset, "c", "utf8mb4", "set driver charset")
flag.StringVar(&charset, "charset", "utf8mb4", "set driver charset")
flag.Parse()
if driver == "" {
log.Println("Please set driver name. -d or -driver")
return
}
if outFilePath == "" {
log.Println("Please set outFilePath. -o or -outfile")
return
}
conf := ddlmaker.Config{
DB: ddlmaker.DBConfig{
Driver: driver,
Engine: engine,
Charset: charset,
},
OutFilePath: outFilePath,
}
dm, err := ddlmaker.New(conf)
if err != nil {
log.Println(err.Error())
return
}
structs := []interface{}{
ex.User{},
ex.Entry{},
ex.PlayerComment{},
ex.Bookmark{},
}
dm.AddStruct(structs...)
err = dm.Generate()
if err != nil {
log.Println(err.Error())
return
}
}create ddl
$ cd _example
$ go run create_ddl/create_ddl.gosql/schema.sql
SET foreign_key_checks=0;
DROP TABLE IF EXISTS `player`;
CREATE TABLE `player` (
`id` BIGINT unsigned NOT NULL,
`name` VARCHAR(191) NOT NULL,
`created_at` DATETIME NOT NULL,
`updated_at` DATETIME NOT NULL,
`daily_notification_at` TIME NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4;
DROP TABLE IF EXISTS `entry`;
CREATE TABLE `entry` (
`id` INTEGER NOT NULL AUTO_INCREMENT,
`title` VARCHAR(100) NOT NULL,
`public` TINYINT(1) NOT NULL DEFAULT 0,
`content` TEXT NOT NULL,
`created_at` DATETIME NOT NULL,
`updated_at` DATETIME NOT NULL,
FULLTEXT `full_text_idx` (`content`) WITH PARSER `ngram`,
INDEX `created_at_idx` (`created_at`),
INDEX `title_idx` (`title`),
UNIQUE `created_at_uniq_idx` (`created_at`),
PRIMARY KEY (`id`, `created_at`)
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4;
DROP TABLE IF EXISTS `player_comment`;
CREATE TABLE `player_comment` (
`id` INTEGER NOT NULL AUTO_INCREMENT,
`player_id` INTEGER NOT NULL,
`entry_id` INTEGER NOT NULL,
`comment` VARCHAR(99) NULL,
`created_at` DATETIME NOT NULL,
`updated_at` DATETIME NOT NULL,
INDEX `player_id_entry_id_idx` (`player_id`, `entry_id`),
FOREIGN KEY (`entry_id`) REFERENCES `entry` (`id`),
FOREIGN KEY (`player_id`) REFERENCES `player` (`id`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4;
DROP TABLE IF EXISTS `bookmark`;
CREATE TABLE `bookmark` (
`id` INTEGER NOT NULL,
`user_id` INTEGER NOT NULL,
`entry_id` INTEGER NOT NULL,
`created_at` DATETIME NOT NULL,
`updated_at` DATETIME NOT NULL,
UNIQUE `user_id_entry_id` (`user_id`, `entry_id`),
FOREIGN KEY (`entry_id`) REFERENCES `entry` (`id`),
FOREIGN KEY (`player_id`) REFERENCES `player` (`id`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4;
SET foreign_key_checks=1;
- MySQL
| Golang Type | MySQL Column |
|---|---|
| int8 | TINYINT |
| int16 | SMALLINT |
| int32 | INTGER |
| int64, sql.NullInt64 | BIGINT |
| uint8 | TINYINT unsigned |
| uint16 | SMALLINT unsigned |
| uint32 | INTEGER unsigned |
| uint64 | BIGINT unsigned |
| float32 | FLOAT |
| float64, sql.NullFloat64 | DOUBLDE |
| string, sql.NullString | VARCHAR |
| bool, sql.NullBool | TINYINT(1) |
| time.Time, mysql.NullTime | DATETIME |
| json.RawMessage | JSON |
mysql.NullTime is from github.com/go-sql-driver/mysql.
tag prefix is ddl
| TAG Value | VALUE |
|---|---|
| null | NULL (DEFAULT NOT NULL) |
size=<size> |
VARCHAR(<size value>) |
| auto | AUTO INCREMENT |
type=<type> |
OVERRIDE struct type. ex) string `ddl:"text` |
| - | Don't define column |
Define struct method called PrimaryKey()
ex)
func (b Bookmark) PrimaryKey() dialect.PrimaryKey {
return mysql.AddPrimaryKey("id")
}Define struct method called Indexes()
| Index Type | Method |
|---|---|
| Index | dialect.Index(index name, columns...) |
| Unique Index | dialect.UniqIndex(index name, columns...) |
| Full Text Index | dialect.FullTextIndex(index name, columns...).WithParser(parser name) |
| Spatial Index | dialect.SpatialIndex(index name, columns...) |
| ex) |
func (b Bookmark) Indexes() dialect.Indexes {
return dialect.Indexes{
mysql.AddUniqueIndex("user_id_entry_id", "user_id", "entry_id"),
}
}Define struct method called ForeignKeys()
| ReferentialActionsOption | Method |
|---|---|
| ON UPDATE | WithUpdateForeignKeyOption(option ForeignKeyOptionType) |
| ON DELETE | WithDeleteForeignKeyOption(option ForeignKeyOptionType) |
| ForeignKeyOptionType | Value |
|---|---|
| ForeignKeyOptionCascade | CASCADE |
| ForeignKeyOptionSetNull | SET NULL |
| ForeignKeyOptionRestrict | RESTRICT |
| ForeignKeyOptionNoAction | NO ACTION |
| ForeignKeyOptionSetDefault | SET DEFAULT |
func (pc PlayerComment) ForeignKeys() dialect.ForeignKeys {
return dialect.ForeignKeys{
mysql.AddForeignKey(
[]string{"player_id"},
[]string{"id"},
"player",
),
mysql.AddForeignKey(
[]string{"entry_id"},
[]string{"id"},
"entry",
),
}
}