1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
|
package database
import (
"imageboard/config"
"imageboard/models"
)
func GetUserByUsername(username string) (*models.User, error) {
var user models.User
if err := DB.Where("username = ?", username).First(&user).Error; err != nil {
return nil, err
}
return &user, nil
}
func GetUsersByEmail(email string) ([]models.User, error) {
var users []models.User
err := DB.Where("email = ?", email).Find(&users).Error
return users, err
}
func ListAllUsers() ([]models.User, error) {
var users []models.User
err := DB.Where("is_deleted = ?", false).Order("LOWER(username) ASC").Find(&users).Error
return users, err
}
func ListAllApprovers() ([]models.User, error) {
var users []models.User
err := DB.Where("is_deleted = ? AND level >= ?", false, config.UserLevelJanitor).Order("LOWER(username) ASC").Find(&users).Error
return users, err
}
func GetUserByID(userID uint) (*models.User, error) {
var user models.User
if err := DB.Where("id = ?", userID).First(&user).Error; err != nil {
return nil, err
}
return &user, nil
}
func CreateUser(user *models.User) error {
return DB.Create(user).Error
}
|
