Skip to main content
Version: 2.0.0

Table and Migration

CREATE/ALTER table​

Without dropping existing indexes and columns​

import (
    "time"
    "golang.org/x/text/language"
    "github.com/paulmach/orb"
    "cloud.google.com/go/civil"
)

type User struct{
    Name            string `sqlike:",size=100"`
    Age             uint
    Detail struct{
        FirstName   string
        Address     string
    }
    Address         string  `sqlike:",longtext"`
    Money           float64 `sqlike:",unsigned"`
    FavouriteFoods  []string
    ChosenLanguage  language.Tag
    Birthday        civil.Date
    Geolocation     orb.Point
    JoinAt          time.Time
}

db := client.Database("sqlike")

db.Table("Users").MustMigrate(User{})
// or
db.Table("Users").Migrate(User{})

Drop existing indexes and columns if they no longer available​

db.Table("Users").UnsafeMigrate(User{})

Drop table​

client.Database("sqlike").
    Table("Users").
    Drop(context.Background())

Drop table if exists​

client.Database("sqlike").
    Table("Users").
    DropIfExists(context.Background())

Rename table​

client.Database("sqlike").
    Table("Users").
    Rename(context.Background(), "newUsers")

Truncate table records​

client.Database("sqlike").
    Table("Users").
    Truncate(context.Background())