postgres.go

// GetByID returns an Account instance given its id which is either:
// username or email.
func (r *RepoPostgres) GetByID(id string) (*Account, error) {
	a := new(account)
	err := r.db.Get(a, "SELECT * FROM accounts WHERE username = $1 OR email = $1", id)
	if err != nil {
		return nil, translateError(err)
	}

	a.Account.PictureURL, _ = url.Parse(a.PictureURL)
	a.Account.Type = AccountType(a.Type)
	a.Account.Status = StatusType(a.Status)
	return &(a.Account), nil
}