From 973370074414ad5ab8f2c401001793294822bf16 Mon Sep 17 00:00:00 2001
From: ivarlovlie <git@ivarlovlie.no>
Date: Mon, 5 Dec 2022 14:03:54 +0900
Subject: feat: WIP! radio series details

---
 src/RadioIndexDb.cs | 21 +++++++++++++++++++++
 1 file changed, 21 insertions(+)

(limited to 'src/RadioIndexDb.cs')

diff --git a/src/RadioIndexDb.cs b/src/RadioIndexDb.cs
index 6b629a7..3418891 100644
--- a/src/RadioIndexDb.cs
+++ b/src/RadioIndexDb.cs
@@ -58,6 +58,27 @@ select last_insert_rowid();", new {
         return db.QueryFirstOrDefault<RadioSeries>(@"select * from series where nrk_id=@nrkId", new {nrkId});
     }
 
+    public static RadioSeries GetSeriesById(int id) {
+        using var db = new SqliteConnection(ConnectionString);
+        if (!db.TableExists("series")) return default;
+        return db.QueryFirstOrDefault<RadioSeries>(@"select * from series where id=@id", new {id});
+    }
+
+    public static SeriesDetails GetSeriesDetailsById(int id) {
+        using var db = new SqliteConnection(ConnectionString);
+        if (!db.TableExists("series")) return default;
+        return db.QueryFirstOrDefault<SeriesDetails>(@"
+    select id as s_id, name as s_name from seasons where series_id=1;
+    select id as e_id, name as e_name, source_url as e_source from episodes where series_id=1;
+", new {id});
+    }
+
+    public class SeriesDetails
+    {
+        public List<RadioSeason> Seasons { get; set; }
+        public List<RadioEpisode> Episodes { get; set; }
+    }
+
     public static RadioSeason GetSeasonByNrkId(string nrkId) {
         using var db = new SqliteConnection(ConnectionString);
         if (!db.TableExists("seasons")) return default;
-- 
cgit v1.3