#!/usr/bin/env python3
"""
查询"金身不好玩"（adid=8370）的所有字幕行
"""
import sqlite3

db_path = "\\\\ll\\D\\xtrssvjj\\dpd.db"

conn = sqlite3.connect(db_path)
cursor = conn.cursor()

adid = 8370

# 查询所有字幕，按idx排序
cursor.execute("SELECT idx, cn, en, tts FROM srts WHERE adid = ? ORDER BY idx", (adid,))
subtitles = cursor.fetchall()

print('"金身不好玩" (adid={}) 字幕列表：'.format(adid))
print('共 {} 句字幕'.format(len(subtitles)))
print('-' * 80)
print('{:<5} {:<40} {:<60} {}'.format('idx', '中文', '英文', 'tts'))
print('-' * 80)

for idx, cn, en, tts in subtitles:
    print('{:<5} {:<40} {:<60} {}'.format(idx, cn, en, tts))

print('-' * 80)
conn.close()