Working on getting migrations run in prod

le717 · Oct 28, 2021 · 6116f9a · 6116f9a
1 parent 17509df
commit 6116f9a
Show file tree

Hide file tree

Showing 7 changed files with 57 additions and 57 deletions.
diff --git a/.dockerignore b/.dockerignore
@@ -3,11 +3,8 @@
 .vscode/
 .mypy_cache/
 __pycache__/
-database/
-db/
 tests/
 testing/
 node_modules/
 *.md
-.env
-database.db
+*.db
diff --git a/.env b/.env
@@ -1,6 +1,9 @@
 PYTHONPATH="."
+
 FLASK_APP="wsgi.py"
 FLASK_ENV="development"
 SYS_VARS_PATH="./secrets"
+SECRET_KEY="temporary secret key"
+
 ENABLE_DISCORD_LOGGING="false"
 DB_PATH="./database/database.db"
diff --git a/Dockerfile b/Dockerfile
@@ -5,8 +5,7 @@ ENV PYTHONPATH=/app \
     SYS_VARS_PATH=/app/secrets \
     FLASK_APP=wsgi.py \
     TIMES_FAILED_THRESHOLD=10 \
-    ENABLE_DISCORD_LOGGING=false \
-    DB_PATH=./database/database.db
+    ENABLE_DISCORD_LOGGING=false
 
 # Copy the app files into the container
 RUN mkdir -p /app

diff --git a/docker-compose.yml b/docker-compose.yml
@@ -7,9 +7,10 @@ services:
     restart: unless-stopped
     volumes:
       - ./log:/app/log
-      - ./database:/app/db
+      - ./database:/app/database
     ports:
       - 127.0.0.1:5000:80
     environment:
       - FLASK_ENV=production
       - TIMES_FAILED_THRESHOLD=5
+      - DB_PATH=/app/database/database.db
diff --git a/poetry.lock b/poetry.lock
diff --git a/run-app.sh b/run-app.sh
@@ -1,2 +1,3 @@
 #!/usr/bin/env bash
+flask db migrate
 gunicorn --bind 0.0.0.0:80 --workers 2 --log-level error --access-logfile /app/log/access.log --error-logfile /app/log/error.log wsgi:app
diff --git a/src/core/database/schema.py b/src/core/database/schema.py
@@ -17,7 +17,8 @@ class WebLink(db.Model):
     description = Column(String, nullable=False)
     url = Column(String, nullable=False)
     date_added = Column(DateTime, nullable=False)
-    rotted = Column(String, nullable=False, server_default="no")
+    is_dead = Column(Integer, nullable=False, server_default="0")
+    is_web_archive = Column(Integer, nullable=False, server_default="0")
 
 
 class RottedLinks(db.Model):