func GorpInit() { db.Init() Dbm = &gorp.DbMap{Db: db.Db, Dialect: gorp.PostgresDialect{}} ub := Dbm.AddTable(models.UserBase{}).SetKeys(true, "UserId") ub.ColMap("Email").Unique = true setColumnSizes(ub, map[string]int{ "UserName": 32, "Email": 64, }) Dbm.AddTable(models.UserVolatile{}).SetKeys(true, "UserId") Dbm.AddTable(models.UserAuth{}).SetKeys(true, "UserId") Dbm.TraceOn("[gorp]", log.New(GLogger{glog.Info}, "", 0)) Dbm.CreateTablesIfNotExists() if fill { now := time.Now().UnixNano() demoUser := &models.UserBase{0, "demo", "*****@*****.**"} errU := Dbm.Insert(demoUser) checkFail(errU) demoVolatile := &models.UserVolatile{demoUser.UserId, now, 0, 0, 0, now} errV := Dbm.Insert(demoVolatile) checkFail(errV) demoPassword, _ := bcrypt.GenerateFromPassword([]byte("demo"), bcrypt.DefaultCost) demoAuth := &models.UserAuth{demoUser.UserId, demoPassword, "", 0, 0, 0, 0} errA := Dbm.Insert(demoAuth) checkFail(errA) } }
func InitDB() { db.Init() Dbm = &gorp.DbMap{Db: db.Db, Dialect: gorp.PostgresDialect{}} Dbm.AddTableWithName(models.Account{}, "accounts").SetKeys(true, "Id") Dbm.TraceOn("[gorp]", log.New(os.Stdout, "sql:", log.Lmicroseconds)) }