Spaces:
Sleeping
Sleeping
Download run-migration.py from umarwaqar/full-stack-todo: direct link, hf CLI and curl.
- Browser
- Download file 1.85 kB
-
https://huggingface.co/spaces/umarwaqar/full-stack-todo/resolve/main/run-migration.py
- Command line
-
hf download hf://spaces/umarwaqar/full-stack-todo/run-migration.py
-
curl -L -o run-migration.py https://huggingface.co/spaces/umarwaqar/full-stack-todo/resolve/main/run-migration.py
1.85 kB
| """ | |
| Script to migrate tasks table user_id from INTEGER to TEXT | |
| """ | |
| import psycopg2 | |
| import os | |
| from dotenv import load_dotenv | |
| load_dotenv() | |
| def run_migration(): | |
| """Run the user_id conversion migration""" | |
| database_url = os.getenv('DATABASE_URL') | |
| if not database_url: | |
| print("ERROR: DATABASE_URL not found in environment variables") | |
| return False | |
| try: | |
| # Read the SQL file | |
| with open('migrations/convert-user-id-to-text.sql', 'r') as f: | |
| sql = f.read() | |
| # Connect to database | |
| print("Connecting to database...") | |
| conn = psycopg2.connect(database_url) | |
| cursor = conn.cursor() | |
| # Execute migration | |
| print("Running user_id conversion migration...") | |
| print("WARNING: This will delete all existing tasks!") | |
| print("Press Ctrl+C to cancel, or Enter to continue...") | |
| input() | |
| cursor.execute(sql) | |
| conn.commit() | |
| print("SUCCESS: Migration completed successfully!") | |
| print("\nVerifying migration...") | |
| # Verify the change | |
| cursor.execute(""" | |
| SELECT column_name, data_type, is_nullable | |
| FROM information_schema.columns | |
| WHERE table_name = 'tasks' AND column_name = 'user_id'; | |
| """) | |
| result = cursor.fetchone() | |
| if result: | |
| print(f"Column: {result[0]}, Type: {result[1]}, Nullable: {result[2]}") | |
| else: | |
| print("ERROR: user_id column not found!") | |
| # Close connection | |
| cursor.close() | |
| conn.close() | |
| return True | |
| except Exception as e: | |
| print(f"ERROR: Migration failed: {e}") | |
| return False | |
| if __name__ == "__main__": | |
| print("=" * 50) | |
| print("Tasks Table Migration") | |
| print("Convert user_id from INTEGER to TEXT") | |
| print("=" * 50) | |
| run_migration() | |