#!/usr/bin/env python
# -*- coding: utf-8 -*-
import sqlite3
import os

DATABASE_PATH = os.path.join(os.path.dirname(__file__), '../database/app.db')

def get_db():
    conn = sqlite3.connect(DATABASE_PATH)
    conn.row_factory = sqlite3.Row
    return conn

print('=== 数据库检查 ===')

if os.path.exists(DATABASE_PATH):
    print(f'数据库文件存在: {DATABASE_PATH}')
    conn = get_db()
    cursor = conn.cursor()
    
    print('\n=== 用户表数据 ===')
    cursor.execute('SELECT * FROM users')
    users = cursor.fetchall()
    for user in users:
        print(dict(user))
    
    print('\n=== 会话表数据 ===')
    cursor.execute('SELECT * FROM sessions')
    sessions = cursor.fetchall()
    for session in sessions:
        print(dict(session))
    
    print('\n=== 清空脏数据 ===')
    cursor.execute('DELETE FROM users')
    cursor.execute('DELETE FROM sessions')
    conn.commit()
    print('已清空所有用户和会话数据')
    
    conn.close()
else:
    print('数据库文件不存在')

print('\n检查完成!')