1 files changed, 14 insertions, 0 deletions
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