#!/usr/bin/env python3
# -*- coding: utf-8 -*-
"""
查询第17句的字幕内容
"""

import sqlite3

db_path = r"\\ll\\d\\xtrssvjj\\dpd.db"
conn = sqlite3.connect(db_path)
cur = conn.cursor()

cur.execute("SELECT idx, cn FROM srts WHERE adid=8404 AND idx=17")
result = cur.fetchone()

if result:
    print(f"idx: {result[0]}")
    print(f"cn: {result[1]}")
    print(f"cn长度: {len(result[1])}")

conn.close()