70 lines
1.5 KiB
Go
70 lines
1.5 KiB
Go
|
package dao
|
||
|
|
|
||
|
|
import (
|
||
|
|
"RelationshipManagement-backend/model"
|
||
|
|
"gorm.io/gorm"
|
||
|
|
)
|
||
|
|
|
||
|
|
// UserDAO 用户数据访问对象
|
||
|
|
type UserDAO struct {
|
||
|
|
db *gorm.DB
|
||
|
|
}
|
||
|
|
|
||
|
|
// NewUserDAO 创建用户DAO实例
|
||
|
|
func NewUserDAO(db *gorm.DB) *UserDAO {
|
||
|
|
return &UserDAO{db: db}
|
||
|
|
}
|
||
|
|
|
||
|
|
// Create 创建用户
|
||
|
|
func (dao *UserDAO) Create(user *model.User) error {
|
||
|
|
return dao.db.Create(user).Error
|
||
|
|
}
|
||
|
|
|
||
|
|
// GetByID 根据ID获取用户
|
||
|
|
func (dao *UserDAO) GetByID(id uint) (*model.User, error) {
|
||
|
|
var user model.User
|
||
|
|
err := dao.db.First(&user, id).Error
|
||
|
|
if err != nil {
|
||
|
|
return nil, err
|
||
|
|
}
|
||
|
|
return &user, nil
|
||
|
|
}
|
||
|
|
|
||
|
|
// GetByUsername 根据用户名获取用户
|
||
|
|
func (dao *UserDAO) GetByUsername(username string) (*model.User, error) {
|
||
|
|
var user model.User
|
||
|
|
err := dao.db.Where("username = ?", username).First(&user).Error
|
||
|
|
if err != nil {
|
||
|
|
return nil, err
|
||
|
|
}
|
||
|
|
return &user, nil
|
||
|
|
}
|
||
|
|
|
||
|
|
// GetByEmail 根据邮箱获取用户
|
||
|
|
func (dao *UserDAO) GetByEmail(email string) (*model.User, error) {
|
||
|
|
var user model.User
|
||
|
|
err := dao.db.Where("email = ?", email).First(&user).Error
|
||
|
|
if err != nil {
|
||
|
|
return nil, err
|
||
|
|
}
|
||
|
|
return &user, nil
|
||
|
|
}
|
||
|
|
|
||
|
|
// Update 更新用户
|
||
|
|
func (dao *UserDAO) Update(user *model.User) error {
|
||
|
|
return dao.db.Save(user).Error
|
||
|
|
}
|
||
|
|
|
||
|
|
// Delete 删除用户
|
||
|
|
func (dao *UserDAO) Delete(id uint) error {
|
||
|
|
return dao.db.Delete(&model.User{}, id).Error
|
||
|
|
}
|
||
|
|
|
||
|
|
// List 获取用户列表
|
||
|
|
func (dao *UserDAO) List(offset, limit int) ([]*model.User, error) {
|
||
|
|
var users []*model.User
|
||
|
|
err := dao.db.Offset(offset).Limit(limit).Find(&users).Error
|
||
|
|
return users, err
|
||
|
|
}
|
||
|
|
|