From 32ca159147b460e9c494df2013c4b0596809ef20 Mon Sep 17 00:00:00 2001
From: Chris Fulljames <christianfulljames@gmail.com>
Date: Sun, 30 Mar 2025 08:27:26 -0400
Subject: [PATCH] Move sql files to subdir

---
 main.py                                    | 2 +-
 schema.sql => sql/schema.sql               | 2 +-
 schema_revert.sql => sql/schema_revert.sql | 0
 schema_update.sql => sql/schema_update.sql | 0
 test/test_offline.py                       | 2 +-
 5 files changed, 3 insertions(+), 3 deletions(-)
 rename schema.sql => sql/schema.sql (99%)
 rename schema_revert.sql => sql/schema_revert.sql (100%)
 rename schema_update.sql => sql/schema_update.sql (100%)

diff --git a/main.py b/main.py
index 4c81b24..0f3de7d 100644
--- a/main.py
+++ b/main.py
@@ -1074,7 +1074,7 @@ def get_db():
         user_version = query_db("pragma user_version", one=True)[0]
 
         # Run update script if DB is out of date
-        schema_update_script = SCRIPT_DIR / 'schema_update.sql'
+        schema_update_script = SCRIPT_DIR / 'sql' / 'schema_update.sql'
         if user_version < DB_VERSION and schema_update_script.exists():
             with app.open_resource(schema_update_script, mode='r') as f:
                 db.cursor().executescript(f.read())
diff --git a/schema.sql b/sql/schema.sql
similarity index 99%
rename from schema.sql
rename to sql/schema.sql
index 5d09331..51057b6 100644
--- a/schema.sql
+++ b/sql/schema.sql
@@ -9,7 +9,7 @@ CREATE TABLE users (
     bgcolor TEXT,
     fgcolor TEXT,
     accolor TEXT,
-    threadid INTEGER,
+    threadid INTEGER
 );
 CREATE INDEX users_by_name ON users(username);
 
diff --git a/schema_revert.sql b/sql/schema_revert.sql
similarity index 100%
rename from schema_revert.sql
rename to sql/schema_revert.sql
diff --git a/schema_update.sql b/sql/schema_update.sql
similarity index 100%
rename from schema_update.sql
rename to sql/schema_update.sql
diff --git a/test/test_offline.py b/test/test_offline.py
index 1a2d54f..e6cf3ed 100644
--- a/test/test_offline.py
+++ b/test/test_offline.py
@@ -25,7 +25,7 @@ def app():
         # Initialize Database
         with main.app.app_context():
             db = sqlite3.connect(main.DATA_DIR / "database.db")
-            with main.app.open_resource('schema.sql', mode='r') as f:
+            with main.app.open_resource('sql/schema.sql', mode='r') as f:
                 db.cursor().executescript(f.read())
             db.commit()
             db.close()
-- 
2.39.5