#!/usr/bin/env python3
# -*- coding: utf-8 -*-
"""
检查 srts 表中是否有指定 adid 的记录
"""

import sqlite3

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

# 要检查的 adid
adid = 8549

# 连接数据库
conn = sqlite3.connect(db_path)
cursor = conn.cursor()

# 检查 srts 表中是否有 adid=8549 的记录
print(f"检查 srts 表中 adid={adid} 的记录:")
cursor.execute("SELECT COUNT(*) FROM srts WHERE adid = ?", (adid,))
count = cursor.fetchone()[0]
print(f"找到 {count} 条记录")

if count > 0:
    # 查看前 5 条记录
    print("\n前 5 条记录:")
    cursor.execute("SELECT adid, adname, idx, start, end FROM srts WHERE adid = ? LIMIT 5", (adid,))
    for row in cursor.fetchall():
        print(f"adid: {row[0]}, adname: {row[1]}, idx: {row[2]}, start: {row[3]}, end: {row[4]}")

# 关闭连接
conn.close()