"""
Script to check the structure of the settings table in the database.
"""
import sqlite3
import os

# Get the database path
db_path = os.path.join(os.path.dirname(__file__), 'instance', 'podcastrr.db')
print(f"Database path: {db_path}")

# Connect to the database
conn = sqlite3.connect(db_path)
cursor = conn.cursor()

# Check the structure of the settings table
print("Checking settings table structure...")
cursor.execute("PRAGMA table_info(settings)")
columns = cursor.fetchall()

# Print the columns
print("Settings table columns:")
for column in columns:
    print(f"  {column[1]} ({column[2]})")

# Close the connection
conn.close()