Repository navigation
Expand file tree
/
Copy pathsettings.go
More file actions
98 lines (83 loc) · 2.45 KB
/
Copy pathsettings.go
File metadata and controls
98 lines (83 loc) · 2.45 KB
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
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
package models
import (
"database/sql"
"time"
)
// AppSetting represents an application-wide setting
type AppSetting struct {
ID int64 `json:"id"`
Key string `json:"key"`
Value string `json:"value"`
Description string `json:"description"`
CreatedAt time.Time `json:"created_at"`
UpdatedAt time.Time `json:"updated_at"`
}
// GetAppSetting retrieves an application setting by key
func GetAppSetting(db *sql.DB, key string) (*AppSetting, error) {
var setting AppSetting
err := db.QueryRow(
"SELECT id, key, value, description, created_at, updated_at FROM app_settings WHERE key = ?",
key,
).Scan(&setting.ID, &setting.Key, &setting.Value, &setting.Description, &setting.CreatedAt, &setting.UpdatedAt)
if err != nil {
if err == sql.ErrNoRows {
return nil, nil
}
return nil, err
}
return &setting, nil
}
// GetAppSettingValue retrieves just the value of an application setting by key
func GetAppSettingValue(db *sql.DB, key string) (string, error) {
var value string
err := db.QueryRow(
"SELECT value FROM app_settings WHERE key = ?",
key,
).Scan(&value)
if err != nil {
if err == sql.ErrNoRows {
return "", nil
}
return "", err
}
return value, nil
}
// GetAppSettingBool retrieves a boolean application setting by key
func GetAppSettingBool(db *sql.DB, key string) (bool, error) {
value, err := GetAppSettingValue(db, key)
if err != nil {
return false, err
}
return value == "true", nil
}
// UpdateAppSetting updates an application setting
func UpdateAppSetting(db *sql.DB, key, value string) error {
_, err := db.Exec(
"UPDATE app_settings SET value = ?, updated_at = CURRENT_TIMESTAMP WHERE key = ?",
value, key,
)
return err
}
// GetAllAppSettings retrieves all application settings
func GetAllAppSettings(db *sql.DB) ([]AppSetting, error) {
rows, err := db.Query(
"SELECT id, key, value, description, created_at, updated_at FROM app_settings ORDER BY key",
)
if err != nil {
return nil, err
}
defer rows.Close()
var settings []AppSetting
for rows.Next() {
var setting AppSetting
if err := rows.Scan(&setting.ID, &setting.Key, &setting.Value, &setting.Description, &setting.CreatedAt, &setting.UpdatedAt); err != nil {
return nil, err
}
settings = append(settings, setting)
}
return settings, nil
}
// IsRegistrationEnabled checks if user registration is enabled
func IsRegistrationEnabled(db *sql.DB) (bool, error) {
return GetAppSettingBool(db, "registration_enabled")
}