#!/usr/bin/env python3
# -*- coding: utf-8 -*-
"""
查询srts表的数据
"""

import sqlite3


def check_srts_table():
    """
    检查srts表的数据
    """
    conn = sqlite3.connect('srtsegjoin/dpd.db')
    cur = conn.cursor()
    
    # 查询srts表的总记录数
    cur.execute("SELECT COUNT(*) FROM srts")
    total = cur.fetchone()[0]
    print(f"srts表总记录数: {total}")
    
    if total > 0:
        # 查询前10条记录
        cur.execute("SELECT * FROM srts LIMIT 10")
        rows = cur.fetchall()
        print(f"\n前10条记录:")
        for i, row in enumerate(rows):
            print(f"\n[{i}]")
            print(f"  adid={row[0]}")
            print(f"  adname={row[1]}")
            print(f"  idx={row[2]}")
            print(f"  cn={row[5][:50]}")
            print(f"  en={row[6][:50]}")
    
    conn.close()


if __name__ == "__main__":
    check_srts_table()