Changeset cc841a5 for docker-entrypoint.sh

Timestamp:

12/27/25 20:00:37 (7 months ago)

Author:

Tome <gjorgievtome@…>

Branches:

main

Children:

9137793

Parents:

05361b8

Message:

Add migration check

File:

• docker-entrypoint.sh (modified) (1 diff)

docker-entrypoint.sh

@@ -8 +8 @@
 done
 
-echo "Generating migrations..."
-npm run drizzle:generate
+echo "Checking if database needs migration..."
+TABLE_COUNT=$(psql -h db -U app -d postgres -t -c "SELECT COUNT(*) FROM information_schema.tables WHERE table_schema='public';" 2>/dev/null || echo "0")
 
-echo "Running migrations..."
-npm run drizzle:migrate
+if [ "$TABLE_COUNT" -eq "0" ]; then
+  echo "Database is empty, running migrations..."
+  npm run drizzle:generate
+  npm run drizzle:migrate
 
-echo "Seeding database..."
-npm run drizzle:seed
+  echo "Seeding database..."
+  npm run drizzle:seed
+else
+  echo "Database already initialized (found $TABLE_COUNT tables), skipping migrations and seed"
+fi
 
 echo "Starting application..."