#!/usr/bin/env python3
"""
查询srts表中adid=7992的所有记录数量
"""
import sqlite3

# 数据库路径
db_path = "\\\\ll\\D\\xtrssvjj\\dpd.db"

try:
    # 连接数据库
    conn = sqlite3.connect(db_path)
    cursor = conn.cursor()
    
    # 查询adid为7992的记录数量
    cursor.execute("SELECT COUNT(*) FROM srts WHERE adid = 7992")
    count = cursor.fetchone()[0]
    
    print(f"adid=7992 共有 {count} 条记录")
    
    # 查询adname
    cursor.execute("SELECT DISTINCT adname FROM srts WHERE adid = 7992")
    adname = cursor.fetchone()[0]
    print(f"adname: {adname}")
    
    # 关闭连接
    conn.close()
    
except Exception as e:
    print(f"错误: {e}")