26 lines
No EOL
642 B
Python
26 lines
No EOL
642 B
Python
"""
|
|
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() |