Kuby/check_cols.py

19 lines
562 B
Python
Raw Permalink Normal View History

import sqlite3
import os
db_path = "/home/gameurpro12/Documents/Mes_projets/Discord_bot/backup_kuby/config.db"
if os.path.exists(db_path):
conn = sqlite3.connect(db_path)
cursor = conn.cursor()
try:
cursor.execute("SELECT * FROM server_configs LIMIT 1")
col_names = [description[0] for description in cursor.description]
print(f"Columns: {col_names}")
row = cursor.fetchone()
print(f"Data: {row}")
except Exception as e:
print(f"Error: {e}")
conn.close()
else:
print("Database not found")