#!/usr/bin/env python3
# -*- coding: utf-8 -*-
"""
重新计算seg003的截取参数
"""

import sqlite3

db_path = r'\\ll\D\xtrssvjj\db\dpd.db'
adid = 8434

try:
    conn = sqlite3.connect(db_path)
    cursor = conn.cursor()
    
    # 查询idx=2,3,4的字幕数据
    cursor.execute("SELECT idx, start, end FROM srts WHERE adid = ? AND idx IN (2,3,4) ORDER BY idx", (adid,))
    subtitles = cursor.fetchall()
    
    for idx, start, end in subtitles:
        print(f"idx={idx}: start={start}ms, end={end}ms")
    
    if len(subtitles) == 3:
        idx2, start2, end2 = subtitles[0]
        idx3, start3, end3 = subtitles[1]
        idx4, start4, end4 = subtitles[2]
        
        print(f"\n计算seg003 (idx=3) 的截取参数:")
        
        # 开始时间
        start_time = (end2 + start3) // 2
        print(f"start_time = ({end2} + {start3}) // 2 = {start_time}ms")
        
        # 结束时间
        end_time = (end3 + start4) // 2
        print(f"end_time = ({end3} + {start4}) // 2 = {end_time}ms")
        
        # 音频片段时长
        audio_segment_duration = end_time - start_time
        print(f"audio_segment_duration = {end_time} - {start_time} = {audio_segment_duration}ms")
        
        # 字幕时长
        subtitle_duration = end3 - start3
        print(f"subtitle_duration = {end3} - {start3} = {subtitle_duration}ms")
        
        # 前gap和后gap
        prev_gap = start3 - end2
        next_gap = start4 - end3
        print(f"prev_gap = {start3} - {end2} = {prev_gap}ms")
        print(f"next_gap = {start4} - {end3} = {next_gap}ms")
        
        print(f"\n预期文件名: seg003-v-{prev_gap}-{audio_segment_duration}-{subtitle_duration}-{next_gap}-v.mp3")
        print(f"实际文件名: seg003-v-300-1190-900-280-v.mp3")
    
    conn.close()
    
except Exception as e:
    print(f"错误: {e}")