aboutsummaryrefslogtreecommitdiffstats
path: root/apply_migrations.py
blob: 4ade81eb99cae1178721a7c688f5e61fa991b309 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
from dotenv import load_dotenv
load_dotenv()

import os
import db

migrations_dir = 'migrations'  # Relative directory path

# Get all migration files
migration_files = sorted(os.listdir(migrations_dir))

# Apply migrations in alphabetical order
for migration_file in migration_files:
  migration_path = os.path.join(migrations_dir, migration_file)
  print(f"* Applying migration: {migration_path}")

  with open(migration_path, 'r') as f:
    migration_sql = f.read()

  print(migration_sql)

  db.apply_migration(migration_sql)
  print(f"* Migration applied: {migration_path}")

print(f"* {len(migration_files)} migrations applied.")