reprogl

1
package repositories
2

3
import (
4
	"database/sql"
5
	"errors"
6

7
	"xelbot.com/reprogl/models"
8
)
9

10
type SystemParametersRepository struct {
11
	DB *sql.DB
12
}
13

14
func (sp *SystemParametersRepository) FindByKey(key string) (string, error) {
15
	query := `
16
		SELECT
17
			sp.value
18
		FROM sys_parameters AS sp
19
		WHERE sp.optionkey = ?`
20

21
	var value string
22

23
	err := sp.DB.QueryRow(query, key).Scan(&value)
24
	if err != nil {
25
		if errors.Is(err, sql.ErrNoRows) {
26
			return value, models.RecordNotFound
27
		} else {
28
			return value, err
29
		}
30
	}
31

32
	return value, nil
33
}
34