From c72dfab37fd6f0d739ea70d42779b2a8c85e9915 Mon Sep 17 00:00:00 2001 From: Samuel Johnson Date: Wed, 26 Nov 2025 00:58:34 -0500 Subject: Add Youtube RSS parser --- internal/dbmigrations.go | 9 +++++++++ internal/models/feed.go | 8 ++++++++ 2 files changed, 17 insertions(+) create mode 100644 internal/models/feed.go (limited to 'internal') diff --git a/internal/dbmigrations.go b/internal/dbmigrations.go index 50badc0..7d520ba 100644 --- a/internal/dbmigrations.go +++ b/internal/dbmigrations.go @@ -40,6 +40,15 @@ func Migrate(db *sql.DB, webmaster string, passOne string, passTwo string) { } } + _, table_check = db.Query("SELECT * FROM feeds;") + if table_check != nil { + _, err := db.Exec("CREATE TABLE feeds (id SERIAL PRIMARY KEY, name VARCHAR(50) NOT NULL, user_id INTEGER REFERENCES logins(id), url VARCHAR(255) NOT NULL);") + if err != nil { + fmt.Fprintf(os.Stderr, "Unable to create feeds table: %v\n", err) + os.Exit(1) + } + } + _, table_check = db.Query("SELECT * FROM cookies;") if table_check != nil { _, err := db.Exec("CREATE TABLE cookies (id SERIAL PRIMARY KEY, content VARCHAR(255) NOT NULL, user_id INTEGER REFERENCES logins(id), expiration TIMESTAMP);") diff --git a/internal/models/feed.go b/internal/models/feed.go new file mode 100644 index 0000000..9c68adb --- /dev/null +++ b/internal/models/feed.go @@ -0,0 +1,8 @@ +package models + +type Feed struct { + Id int + Name string + User string + Url string +} -- cgit v1.2.3