From b300ad869f424cdd26bcfc78635a27656836ca96 Mon Sep 17 00:00:00 2001
From: GrailFinder <wohilas@gmail.com>
Date: Wed, 12 Jun 2024 09:13:05 +0300
Subject: Feat: add cron and defaults table

---
 internal/database/repos/defaults.go | 25 +++++++++++++++++++++++++
 1 file changed, 25 insertions(+)
 create mode 100644 internal/database/repos/defaults.go

(limited to 'internal/database/repos/defaults.go')

diff --git a/internal/database/repos/defaults.go b/internal/database/repos/defaults.go
new file mode 100644
index 0000000..e0b5e52
--- /dev/null
+++ b/internal/database/repos/defaults.go
@@ -0,0 +1,25 @@
+package repos
+
+type DefaultsRepo interface {
+	DBGetDefaultsMap() (map[string]string, error)
+}
+
+func (p *Provider) DBGetDefaultsMap() (map[string]string, error) {
+	rows, err := p.db.Queryx(`SELECT key, value
+        FROM defaults;
+    `)
+	if err != nil {
+		return nil, err
+	}
+	res := make(map[string]string)
+	for rows.Next() {
+		keyval, err := rows.SliceScan()
+		if err != nil {
+			return nil, err
+		}
+		key := keyval[0].(string)
+		value := keyval[1].(string)
+		res[key] = value
+	}
+	return res, nil
+}
-- 
cgit v1.2.3