34 lines
1.2 KiB
Python
34 lines
1.2 KiB
Python
#!/usr/bin/env python3
|
||
"""Add muted column to playlist_content table."""
|
||
from app.app import create_app
|
||
from app.extensions import db
|
||
|
||
def add_muted_column():
|
||
"""Add muted column to playlist_content association table."""
|
||
app = create_app()
|
||
|
||
with app.app_context():
|
||
try:
|
||
# Check if column already exists
|
||
result = db.session.execute(db.text("PRAGMA table_info(playlist_content)")).fetchall()
|
||
columns = [row[1] for row in result]
|
||
|
||
if 'muted' in columns:
|
||
print("ℹ️ Column 'muted' already exists in playlist_content table")
|
||
return
|
||
|
||
# Add muted column with default value True (muted by default)
|
||
db.session.execute(db.text("""
|
||
ALTER TABLE playlist_content
|
||
ADD COLUMN muted BOOLEAN DEFAULT TRUE
|
||
"""))
|
||
db.session.commit()
|
||
print("✅ Successfully added 'muted' column to playlist_content table")
|
||
print(" Default: TRUE (videos will be muted by default)")
|
||
except Exception as e:
|
||
db.session.rollback()
|
||
print(f"❌ Error adding column: {e}")
|
||
|
||
if __name__ == '__main__':
|
||
add_muted_column()
|