ref: Move to a MVC like approach

Before everything was dumped into the controller file, now it is spread
out a bit.

It is still far from good, like the controller is not really a
controller... baby steps I guess

The refactored was based on this post:

https://www.alexedwards.net/blog/organising-database-access

1 files changed, 33 insertions, 2 deletions

diff --git a/db/model.go b/db/model.go
index 6f35cd0..4b814f9 100644
--- a/db/model.go
+++ b/db/model.go
@@ -1,11 +1,42 @@
 package db
 
-import "gorm.io/gorm"
+import (
+	"gorm.io/gorm"
+)
 
-type YdlEntry struct {
+type Entry struct {
 	gorm.Model
 	Title        string
 	Link         string
 	Format       string
 	OutputFolder string
 }
+
+type EntryModel struct {
+	DB *gorm.DB
+}
+
+func (m EntryModel) Find(id string) Entry {
+	var entry Entry
+	where := "id = " + id
+	m.DB.Where(where).FirstOrInit(&entry)
+	return entry
+}
+
+func (m EntryModel) All() []Entry {
+	var entries []Entry
+	m.DB.Find(&entries)
+	return entries
+}
+
+func (m EntryModel) Create(entry Entry) {
+	m.DB.Create(&entry)
+}
+
+func (m EntryModel) Update(entry Entry) {
+	m.DB.Save(&entry)
+}
+
+func (m EntryModel) Delete(id string) {
+	m.DB.Delete(&Entry{}, id)
+}