From 623a45d1ec1f7e636defd139b35b615b1a64af91 Mon Sep 17 00:00:00 2001
From: ivarlovlie <git@ivarlovlie.no>
Date: Fri, 2 Dec 2022 12:04:42 +0900
Subject: feat: !WIP nrk radio

---
 src/Utilities/SqliteConnectionHelpers.cs | 14 ++++++++++++++
 1 file changed, 14 insertions(+)
 create mode 100644 src/Utilities/SqliteConnectionHelpers.cs

(limited to 'src/Utilities/SqliteConnectionHelpers.cs')

diff --git a/src/Utilities/SqliteConnectionHelpers.cs b/src/Utilities/SqliteConnectionHelpers.cs
new file mode 100644
index 0000000..59fec5a
--- /dev/null
+++ b/src/Utilities/SqliteConnectionHelpers.cs
@@ -0,0 +1,14 @@
+using Dapper;
+using Microsoft.Data.Sqlite;
+
+namespace I2R.LightNews.Utilities;
+
+public static class SqliteConnectionHelpers
+{
+    public static bool TableExists(this SqliteConnection db, string tableName) {
+        return db.QueryFirstOrDefault<string>(
+            "select name from sqlite_master where type='table' and name=@tableName"
+            , new {tableName}
+        ).HasValue();
+    }
+}
\ No newline at end of file
-- 
cgit v1.3