#!/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 ORDER BY id')
    users = cursor.fetchall()
    for user in users:
        print(dict(user))
    
    print(f'\n用户总数: {len(users)}')
    
    print('\n=== 会话表数据 ===')
    cursor.execute('SELECT * FROM sessions ORDER BY id')
    sessions = cursor.fetchall()
    for session in sessions:
        print(dict(session))
    
    print(f'\n会话总数: {len(sessions)}')
    
    # 查找重复手机号
    print('\n=== 检查重复手机号 ===')
    cursor.execute('''
        SELECT phone, COUNT(*) as count 
        FROM users 
        GROUP BY phone 
        HAVING COUNT(*) > 1
    ''')
    duplicates = cursor.fetchall()
    if duplicates:
        for dup in duplicates:
            print(f'重复手机号: {dup["phone"]}, 出现次数: {dup["count"]}')
    else:
        print('没有重复手机号')
    
    conn.close()
else:
    print('数据库文件不存在')

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