Add more util scripts

[cheatdb.git] / utils / create_migration.sh

diff --git a/utils/create_migration.sh b/utils/create_migration.sh
new file mode 100755 (executable)
index 0000000..910344c
--- /dev/null
+++ b/utils/create_migration.sh
@@ -0,0 +1,9 @@
+#!/bin/bash
+
+# Create a database migration, and copy it back to the host.
+
+docker exec -it contentdb_app_1 sh -c "FLASK_CONFIG=../config.cfg FLASK_APP=app/__init__.py flask db migrate"
+docker exec -u root -it contentdb_app_1 sh -c "cp /home/cdb/migrations/versions/* /source/migrations/versions/"
+
+USER=$(whoami)
+sudo chown -R $USER:$USER migrations/versions