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

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

conn = sqlite3.connect(DATABASE_PATH)
conn.row_factory = sqlite3.Row
cursor = conn.cursor()

print('=== 用户数据 ===')
cursor.execute('SELECT * FROM users')
users = cursor.fetchall()
for user in users:
    print(dict(user))

print('\n=== 任务数据 ===')
cursor.execute('SELECT * FROM tasks')
tasks = cursor.fetchall()
for task in tasks:
    print(dict(task))

print('\n=== 更新任务ID 48的acceptor_id ===')
# 我们假设当前登录的用户是ID 2（从之前的数据看）
# 让我们更新任务48的acceptor_id为2
cursor.execute('UPDATE tasks SET acceptor_id = ? WHERE id = ?', (2, 48))
conn.commit()

print('任务48的acceptor_id已更新为2')

conn.close()
print('\n检查完成!')