62 lines
1.9 KiB
Go
62 lines
1.9 KiB
Go
package models
|
|
|
|
import (
|
|
"context"
|
|
"database/sql"
|
|
"fmt"
|
|
"time"
|
|
|
|
"github.com/google/uuid"
|
|
"github.com/uptrace/bun"
|
|
)
|
|
|
|
type UserAttributes struct {
|
|
Groups []Group `json:"groups"`
|
|
}
|
|
|
|
type User struct {
|
|
bun.BaseModel `bun:"table:users"`
|
|
|
|
UserID uuid.UUID `bun:"type:uuid,pk,default:gen_random_uuid()" json:"userId"`
|
|
FirstName string `bun:"firstname,notnull" json:"firstname"`
|
|
LastName string `bun:"lastname,notnull" json:"lastname"`
|
|
Email string `bun:"email,unique,notnull" json:"email"`
|
|
Password string `bun:"password,notnull" json:"password,omitempty"`
|
|
Phone string `bun:"phone,notnull" json:"phone"`
|
|
CreatedAt time.Time `bun:"created_at,default:current_timestamp" json:"createdAt"`
|
|
UpdatedAt time.Time `bun:"updated_at,default:current_timestamp" json:"updatedAt"`
|
|
Events []Event `bun:"m2m:events_to_users,join:User=Event" json:"events,omitempty"`
|
|
Articles []*Blog `bun:"rel:has-many,join:user_id=blog_id" json:"articles,omitempty"`
|
|
Attributes UserAttributes `bun:"attributes,type:jsonb" json:"attributes"`
|
|
Roles []Role `bun:"m2m:users_to_roles,join:User=Role" json:"roles,omitempty"`
|
|
}
|
|
|
|
func (u *User) Insert(db *bun.DB, ctx context.Context) (sql.Result, error) {
|
|
return db.NewInsert().
|
|
Model(u).
|
|
Value("password", "crypt(?, gen_salt('bf'))", u.Password).
|
|
Ignore().
|
|
// Returning("user_id").
|
|
Exec(ctx)
|
|
}
|
|
|
|
func Verify(db *bun.DB, ctx context.Context, email, password string) (*User, error) {
|
|
var user User
|
|
count, err := db.NewSelect().
|
|
Model(&user).
|
|
Where("email = ? AND password = crypt(?, password)", email, password).
|
|
Limit(1).
|
|
ScanAndCount(context.Background())
|
|
if count == 0 {
|
|
return nil, fmt.Errorf("invalid email or password")
|
|
}
|
|
if err != nil {
|
|
if err == sql.ErrNoRows {
|
|
return nil, fmt.Errorf("invalid email or password")
|
|
}
|
|
return nil, err
|
|
}
|
|
|
|
return &user, nil
|
|
}
|