func init() {
var err error
if os.Getenv("DB") == "mysql" {
if DB, err = gorm.Open("mysql", "qor:qor@/qor_bookstore?parseTime=True&loc=Local"); err != nil {
panic(err)
}
} else {
if DB, err = gorm.Open("postgres", "user=qor password=qor dbname=qor_bookstore sslmode=disable"); err != nil {
panic(err)
}
}
DB.AutoMigrate(&models.Author{}, &models.Book{}, &models.User{})
DB.LogMode(true)
Pub = publish.New(&DB)
Pub.AutoMigrate(&models.Author{}, &models.Book{})
StagingDB = Pub.DraftDB() // Draft resources are saved here
ProductionDB = Pub.ProductionDB() // Published resources are saved here
l10n.Global = "en-US"
l10n.RegisterCallbacks(&DB)
}
func init() {
var err error
var db gorm.DB
dbConfig := config.Config.DB
if config.Config.DB.Adapter == "mysql" {
db, err = gorm.Open("mysql", fmt.Sprintf("%v:%v@/%v?parseTime=True&loc=Local", dbConfig.User, dbConfig.Password, dbConfig.Name))
} else if config.Config.DB.Adapter == "postgres" {
db, err = gorm.Open("postgres", fmt.Sprintf("user=%v password=%v dbname=%v sslmode=disable", dbConfig.User, dbConfig.Password, dbConfig.Name))
} else {
panic(errors.New("not supported database adapter"))
}
if err == nil {
DB = &db
Publish = publish.New(DB)
config.Config.I18n = i18n.New(database.New(DB))
l10n.RegisterCallbacks(DB)
sorting.RegisterCallbacks(DB)
validations.RegisterCallbacks(DB)
} else {
panic(err)
}
}
func PrepareDB() {
var err error
// Be able to start a server for develop test
dbuser, dbpwd = "qor", "qor"
if devMode {
dbname = "qor_integration"
} else {
dbname = "qor_integration_test"
}
if os.Getenv("TEST_ENV") == "CI" {
dbuser, dbpwd = os.Getenv("DB_USER"), os.Getenv("DB_PWD")
}
DB, err = gorm.Open("mysql", fmt.Sprintf("%s:%s@/%s?charset=utf8&parseTime=True&loc=Local", dbuser, dbpwd, dbname))
if err != nil {
panic(err)
}
Publish = publish.New(&DB)
SetupDb(true)
draftDB = Publish.DraftDB()
l10n.RegisterCallbacks(&DB)
}
func init() {
db = utils.TestDB()
sorting.RegisterCallbacks(db)
l10n.RegisterCallbacks(db)
pb = publish.New(db)
pb.ProductionDB().DropTable(&User{}, &Product{}, &Brand{})
pb.DraftDB().DropTable(&Product{})
db.AutoMigrate(&User{}, &Product{}, &Brand{})
pb.AutoMigrate(&Product{})
}
func init() {
db := utils.TestDB()
l10n.RegisterCallbacks(db)
db.DropTableIfExists(&Product{})
db.DropTableIfExists(&Tag{})
db.Exec("drop table product_tags;")
db.AutoMigrate(&Product{})
db.AutoMigrate(&Tag{})
dbGlobal = db
dbCN = dbGlobal.Set("l10n:locale", "zh")
dbEN = dbGlobal.Set("l10n:locale", "en")
}
func init() {
db = utils.TestDB()
l10n.RegisterCallbacks(db)
pb = publish.New(db)
pbdraft = pb.DraftDB()
pbprod = pb.ProductionDB()
for _, table := range []string{"product_categories", "product_categories_draft", "product_languages", "product_languages_draft", "author_books", "author_books_draft"} {
pbprod.Exec(fmt.Sprintf("drop table %v", table))
}
for _, value := range []interface{}{&Product{}, &Color{}, &Category{}, &Language{}, &Book{}, &Publisher{}, &Comment{}, &Author{}} {
pbprod.DropTable(value)
pbdraft.DropTable(value)
pbprod.AutoMigrate(value)
pb.AutoMigrate(value)
}
}
func init() {
var err error
// CREATE USER 'qor'@'localhost' IDENTIFIED BY 'qor';
// CREATE DATABASE qor_example;
// GRANT ALL PRIVILEGES ON qor_example.* TO 'qor'@'localhost';
dbuser, dbpwd := "qor", "qor"
if os.Getenv("WEB_ENV") == "online" {
dbuser, dbpwd = os.Getenv("DB_USER"), os.Getenv("DB_PWD")
}
DB, err = gorm.Open("mysql", fmt.Sprintf("%s:%s@/qor_example?charset=utf8&parseTime=True&loc=Local", dbuser, dbpwd))
if err != nil {
panic(err)
}
DB.AutoMigrate(&User{}, &CreditCard{}, &Address{}, &Role{}, &Language{}, &Product{}, &Collection{}, &Order{}, &OrderItem{}, &admin.AssetManager{})
Publish = publish.New(&DB)
Publish.AutoMigrate(&Product{})
l10n.RegisterCallbacks(&DB)
var AdminRole Role
DB.FirstOrCreate(&AdminRole, Role{Name: "admin"})
DB.FirstOrCreate(&Role{}, Role{Name: "dev"})
DB.FirstOrCreate(&Role{}, Role{Name: "customer_support"})
DB.FirstOrCreate(&User{}, User{Name: "admin", RoleID: AdminRole.ID})
DB.FirstOrCreate(&User{}, User{Name: "global_admin", RoleID: AdminRole.ID})
DB.FirstOrCreate(&Language{}, Language{Name: "CN"})
DB.FirstOrCreate(&Language{}, Language{Name: "JP"})
DB.FirstOrCreate(&Language{}, Language{Name: "EN"})
DB.FirstOrCreate(&Language{}, Language{Name: "DE"})
DB.LogMode(true)
}
