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 +++++++++ 1 file changed, 9 insertions(+) (limited to 'internal/dbmigrations.go') 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);") -- cgit v1.2.3