-
Notifications
You must be signed in to change notification settings - Fork 0
/
Migrations.go
42 lines (33 loc) · 1.14 KB
/
Migrations.go
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
package models
import (
"github.com/astaxie/beego/orm"
"github.com/lifei6671/mindoc/conf"
"time"
)
type Migration struct {
MigrationId int `orm:"column(migration_id);pk;auto;unique;" json:"migration_id"`
Name string `orm:"column(name);size(500)" json:"name"`
Statements string `orm:"column(statements);type(text);null" json:"statements"`
Status string `orm:"column(status);default(update)" json:"status"`
CreateTime time.Time `orm:"column(create_time);type(datetime);auto_now_add" json:"create_time"`
Version int64 `orm:"type(bigint);column(version);unique" json:"version"`
}
// TableName 获取对应数据库表名.
func (m *Migration) TableName() string {
return "migrations"
}
// TableEngine 获取数据使用的引擎.
func (m *Migration) TableEngine() string {
return "INNODB"
}
func (m *Migration) TableNameWithPrefix() string {
return conf.GetDatabasePrefix() + m.TableName()
}
func NewMigration() *Migration {
return &Migration{}
}
func (m *Migration) FindFirst() (*Migration, error) {
o := orm.NewOrm()
err := o.QueryTable(m.TableNameWithPrefix()).OrderBy("-migration_id").One(m)
return m, err
}