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

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

print('=== 检查任务和用户数据 ===')

if os.path.exists(DATABASE_PATH):
    print(f'数据库文件存在: {DATABASE_PATH}')
    conn = sqlite3.connect(DATABASE_PATH)
    conn.row_factory = sqlite3.Row
    cursor = conn.cursor()
    
    print('\n=== 用户数据 ===')
    cursor.execute('SELECT * FROM users ORDER BY id')
    users = cursor.fetchall()
    for user in users:
        print(dict(user))
    
    print('\n=== 任务数据 ===')
    cursor.execute('SELECT * FROM tasks ORDER BY id')
    tasks = cursor.fetchall()
    for task in tasks:
        print(dict(task))
    
    conn.close()
else:
    print('数据库文件不存在')

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