import sqlite3
import os

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

def check_data():
    conn = sqlite3.connect(DATABASE_PATH)
    cursor = conn.cursor()
    
    print('=== 检查系统配置 ===')
    cursor.execute('SELECT * FROM system_config')
    configs = cursor.fetchall()
    print(f'配置数量: {len(configs)}')
    for config in configs:
        print(f'  {config}')
    
    print('\n=== 检查任务数据 ===')
    cursor.execute('SELECT id, title, publisher_id, acceptor_id, status FROM tasks')
    tasks = cursor.fetchall()
    print(f'任务总数: {len(tasks)}')
    for task in tasks:
        print(f'  {task}')
    
    conn.close()

if __name__ == '__main__':
    check_data()