// UserByEmail gets user information from email func UserByEmail(email string) (User, error) { var err error result := User{} switch database.ReadConfig().Type { case database.TypeMySQL: err = database.SQL.Get(&result, "SELECT id, password, status_id, first_name FROM user WHERE email = ? LIMIT 1", email) case database.TypeMongoDB: if database.CheckConnection() { session := database.Mongo.Copy() defer session.Close() c := session.DB(database.ReadConfig().MongoDB.Database).C("user") err = c.Find(bson.M{"email": email}).One(&result) } else { err = ErrUnavailable } case database.TypeBolt: err = database.View("user", email, &result) if err != nil { err = ErrNoResult } default: err = ErrCode } return result, standardizeError(err) }
// UserCreate creates user func UserCreate(firstName, lastName, email, password string) error { var err error now := time.Now() switch database.ReadConfig().Type { case database.TypeMySQL: _, err = database.SQL.Exec("INSERT INTO user (first_name, last_name, email, password) VALUES (?,?,?,?)", firstName, lastName, email, password) case database.TypeMongoDB: if database.CheckConnection() { session := database.Mongo.Copy() defer session.Close() c := session.DB(database.ReadConfig().MongoDB.Database).C("user") user := &User{ ObjectID: bson.NewObjectId(), FirstName: firstName, LastName: lastName, Email: email, Password: password, StatusID: 1, CreatedAt: now, UpdatedAt: now, Deleted: 0, } err = c.Insert(user) } else { err = ErrUnavailable } case database.TypeBolt: user := &User{ ObjectID: bson.NewObjectId(), FirstName: firstName, LastName: lastName, Email: email, Password: password, StatusID: 1, CreatedAt: now, UpdatedAt: now, Deleted: 0, } err = database.Update("user", user.Email, &user) default: err = ErrCode } return standardizeError(err) }