#!/usr/bin/env python3
"""
check_srts_adid.py - 检查 srts 表中指定 adid 的记录
"""

import sqlite3

def check_srts_adid(adid):
    db_path = r'\\ll\D\xtrssvjj\db\dpd.db'
    
    try:
        print(f"正在连接数据库: {db_path}")
        conn = sqlite3.connect(db_path, timeout=60.0)
        conn.row_factory = sqlite3.Row
        
        print(f"正在查询 srts 表中 adid={adid} 的记录...")
        
        query = "SELECT * FROM srts WHERE adid = ?"
        cursor = conn.execute(query, (adid,))
        
        records = cursor.fetchall()
        
        if records:
            print(f"找到 {len(records)} 条记录:")
            print("=" * 80)
            
            # 显示前10条记录
            for i, record in enumerate(records[:10]):
                print(f"\n记录 {i+1}:")
                print("-" * 80)
                
                # 显示所有字段
                for key in record.keys():
                    value = record[key]
                    if value is None:
                        value = "NULL"
                    print(f"  {key}: {value}")
            
            if len(records) > 10:
                print(f"\n... 还有 {len(records) - 10} 条记录未显示")
            
            print("=" * 80)
            
            # 检查 ads 表中是否存在对应记录
            print(f"\n检查 ads 表中 rowid={adid} 的记录...")
            ad_query = "SELECT * FROM ads WHERE rowid = ?"
            ad_cursor = conn.execute(ad_query, (adid,))
            ad_record = ad_cursor.fetchone()
            
            if ad_record:
                print("找到对应记录:")
                print(f"  rowid: {ad_record['rowid']}")
                print(f"  name: {ad_record['name']}")
                print(f"  tts: {ad_record['tts']}")
                print(f"  ttscnt: {ad_record['ttscnt']}")
                print(f"  totsrts: {ad_record['totsrts']}")
            else:
                print("未找到对应记录")
            
        else:
            print(f"未找到 srts 表中 adid={adid} 的记录")
        
        conn.close()
        print("数据库连接已关闭")
        
    except Exception as e:
        print(f"错误: {e}")
        import traceback
        traceback.print_exc()

if __name__ == "__main__":
    import sys
    if len(sys.argv) > 1:
        adid = int(sys.argv[1])
    else:
        adid = 8647
    check_srts_adid(adid)