Nc ddl}|jjj}|jj}d} t j |d}|j}|jd|fg}|jD]6}|\} } } } } t| }t| }|j| ||| | f8||r|jSS#t$rG}ddl}td|d|d||j!gcYd}~|r|jSSd}~wwxYw#|r|jwwxYw) u( 从数据库获取字幕信息 rNg$@timeoutzt SELECT idx, start, end, cn, en FROM srts WHERE adid = ? ORDER BY idx 错误 [函数: , 行号: ]: 操作失败: )inspect currentframef_codeco_namef_linenosqlite3connectcursorexecutefetchallintappendclose Exception tracebackprint print_exc)adiddb_pathr func_nameline_noconnr subtitlesrowidxstartendcnenstart_msend_msers 7c:\dev\xtrs\vdcb\srtsegjoin\generate_bilingual_video.py get_subtitlesr*sF$$&--55I""$--G Dw5 W    ??$C&) #CR5zHXF   c8VR< = %  JJL     :gY>OPQsST  JJL    JJL s1BC D0))D+D0D3+D00D33Ec `ddl}|jjj}|jj}d} t j |d}|j}|jd|f|j}|r|d|r|jSSd||r|jSS#t$rJ}ddl } td|d|d || jd|cYd}~|r|jSSd}~wwxYw#|r|jwwxYw) u" 从数据库获取adname rNrz7SELECT DISTINCT adname FROM srts WHERE adid = ? LIMIT 1adid_rrr)r r r r r rrrrfetchonerrrrr) rrr rrrrresultr(rs r) get_adnamer04s$$$&--55I""$--G Dw4PSWRYZ" !9  JJL tf~  JJL     :gY>OPQsSTtf~  JJL    JJL s7AC*C D ,D7D8DDDD-c d}t||}|d}tjjdd|}t ||}tjjd|d}d}||}g} t |D]\} \} } } }}| dkDr || dz d nd}| dkDr| |z nd}| t |dz kr|| dzd}|| z }n|}|| kDr|| z nd}| dk(rd}n|| zd z}| t |dz k(r|dz }n| |zd z}| dk(rd}nd | |z z }|dkrd}| t |dz k(rd}nd || z z }|dkrd}tjj|d | d d |d |d}tj|}d}|r2|d}t |dz }t |dz }|||} t|}tjj|d| dd} tj| }!d}"|!r&| dzstd|!d||!d}#|#dz }"||z|z|"z}$| j| |$f| S#t$r}td|gcYd}~cSd}~wwxYw)u" 读取双语时间信息 \\ll\D\xtrssvjj\db\dpd.db _cn_audioz\\ll\D\xtrssvjjttsz.mp3c ddddddddd |g }tj|d d }|jd k(r/tt |j j d zSy )Nffprobez-vquietz -show_entrieszformat=durationz-ofz"default=noprint_wrappers=1:nokey=1-ifile:T)capture_outputtextr) subprocessrun returncoderfloatstdoutstrip) file_pathcmdr/s r)get_file_durationz-get_bilingual_time..get_file_durationdsw9JESwy}AFGPFQRSDtD    !uV]]0023d:; ;riseg03d-z-*.mp3xxxNz*-04d u使用网络TTS文件: gffffff?) r0ospathjoinr* enumeratelenglobrrrr)%rradname cn_audio_dir en_tts_dirr audio_filerEaudio_durationbilingual_timesir!r"r#r$r%prevendstartgap nextstartendgapstartposendposaddstartaddend cn_audio_filecn_files cn_durationcn_filefilenamestartposidxfilenameendposidxdurstrexen_tts_patternen_files en_durationoriginal_durationbilingual_times% r)get_bilingual_timersOs +Gg &FXY'L0%@JdG,I0VHD/BJ 'z2NO(1)(<$ $CR'(1u)AaC.#!&'!e57? s9~a !!A#q)I_F'I(6( 1(1+ > +c1K"K/&8;F^45O)=R + eB  s+ H== I  II I c^d}t||}td||d}tjj |std|yt |}tdt |d|s tdytj5}g}|D]\}}tjj|d |d d } tjj | std | Y|d z } tjj|d|d d} ddddd| dddddddddddt| d | g} tj| d!"tjj | s|j| td#t |d$|std% d&d&d&ytjj|d'} t| d(d)*5}|D]4}|jd+tjj!|d,6 d&d&d&tjj||d-} ddd.d/d0d1d| d2d3| g } td4tj| d!"}|j"d5k(rtd6|  d&d&d&y! |j$j'd)d78}td:| d&d&d&y#1swYxYw# |j$j'd9d78}n#t|j$}YnxYwYcxYw#1swYy&xYw);" 生成完整的视频流 r2adname: _images&错误：字幕图片目录不存在: F找到  句双语时间信息$错误：未找到双语时间信息vertical_subtitle_rJ.png 警告：图片文件不存在: r< fragment_.mp4ffmpeg-y-loop1r8-c:vlibx264-tune stillimage-c:aaac-b:a192k-pix_fmtyuv420p-t -shortestTr: 生成了  个视频片段$错误：未生成任何视频片段N filelist.txtwutf-8encodingfile '' _bilingual_video.mp4-fconcat-safe0-ccopy开始拼接视频流...r拼接完成！输出文件: replaceerrorsgbk拼接失败！错误信息: )r0rrQrRexistsrsrUtempfileTemporaryDirectoryrSstrr=r>ropenwriteabspathr?stderrdecode)rrrW image_dirr\temp_dirvideo_fragmentsr! duration_ms image_file duration_sec output_filerD filelist_pathffragmentr/ error_msgs r) make_bili_vdrs) +Gg &F HVH ('"I 77>>) $ 6ykBC).O GC())? @A  45  $ $ &( / Ci3Ec#Yd1STJ77>>*-8 EF'-L'',,x9SIT1JKK$j Ic,' C NN3t 4ww~~k*&&{3A!0D  3/00@AB 8 9U ' &Z X~> -w 71+&!: ;3?@,8 ggll98L.MN d ( S - &    ()D9    ! 1+? @G ' &L 3"MM000K 1)= >] ' &^8 72 33 & 4 4U9 4 MI3 #FMM 2IY ' &sbCL#39L#5.L##:KA8L# K!=L#K L#!L $LL LL L##L,cTd}tj|d|j}|S)Nz\s*[(_-]\d+[)]?$)resubrB)rWpatterncleaneds r)clean_filename_suffixr+s&"GffWb&,,.1G NrFcfd}t|}tjj||d}t j|}t d||r't |tjj}|St dt tjjty)N y:\xtrssvjjz*.jpgzsearch_pattern:keyu❌ 未找到封面图) rrQrRrSrVrmaxgetmtimebasename__file__)filemain cover_dircover_imgfilenamemainsearch_pattern found_covers image_paths r)calccoverimgfilenamer5sI/9WW\\)0E/Fe-LMN99^,L N+277+;+;<  "# "''  8 $%rFcd}tjj|}tjj|\}}|}t d| tj |}g}|D]V}||vs|j jds(|jtjj||X|r5t|tjj} t d| | S t dt tjjty#t$r} t d| Yd} ~ Td} ~ wwxYw)Nru)[DEBUG_RAW] 正在绝对匹配关键词: z.jpgru%🎯 【大捷】成功捞出封面: u❌ 目录读取失败: u.❌ 纯文本过滤后依然未找到封面图)rQrRrsplitextrlistdirlowerendswithrrSrrrr) rr base_namename_without_ext_ core_keyword all_filesrrrr(s r)rrCs(I  *I''**95a$L 5l^ DE.JJy)  Aq QWWY%7%7%?##BGGLLA$>? \rww/?/?@J 9*F G   :; "''  8 $%  . (,--.s% D76D7A'D77 EEE)Pathctt|j}|d}d}ddddddd |d d d d dt|ddddddddddddd|g} tj|d}|j dk(rt d|y|jjdd !}t d"|y#t$r}t d#|Yd}~yd}~wwxYw)$N _cover.mp4rGrr -hide_bannerrrr8r9rrrrrrr-vfz!scale=trunc(iw/2)*2:trunc(ih/2)*2rlavfi0anullsrc=channel_layout=stereo:sample_rate=44100rrrrrTrru✅ 封面视频已生成: rignoreru#❌ 生成失败！错误详情： u💥 脚本崩溃: ) rrresolver=r>r?rrrr) rW coverimgfile img_abs_path output_videorrDr/rr(s r)create_cover_videorjstL)1134LXZ(LL $ l^$  c,I 2 gtO C$ )D9    ! / ~> ? ,,WX,FI 8 D E ) #A3'(()s4B5 +B55 C>CCcd}|d}ddddddd d d dd d d ddddddddddddd|g} t|d5}|j}dddtj|tjtjtj}|j \}} |j dk(rSddl} | jj|r| j|| j||td|ytd| jd d!"y#1swYxYw#t$r} td#| Yd} ~ yd} ~ wwxYw)$Ntemp_safe_cover.mp4rrrrrrr image2piper8rKrrrz0scale=trunc(iw/2)*2:trunc(ih/2)*2,format=yuv420prrrrrrrrrrrbstdinrArinputru✅ 真正成功了：u❌ 还是报错：rrr 💥 崩溃: rreadr=PopenPIPE communicater?rQrRrremoverenamerrr rWr temp_output final_outputrDrimg_dataprocessrArrQr(s r)create_cover_video_perfectrsX'KXZ(L $ l c gtO A  c C # , %vvxH&""3joojoo^h^m^mn ,,8,<    " ww~~l+YRYY|-D BIIk< 0 *<.9 : ' gh (O'PQ R& % # aS!""#5 D1D%CD1D1%D.*D11 E:E  Ecd}|d}ddddddd d d dd d d ddddddddddddd|g} t|d5}|j}dddtj|tjtjtj}|j \}} |j dk(rSddl} | jj|r| j|| j||td|ytd| jd d!"y#1swYxYw#t$r} td#| Yd} ~ yd} ~ wwxYw)$Nrrrrrrrrrr8rKrrrzscale=960:544,format=yuv420prrrrrrrrrrrrrru"✅ 完美生成 544x960 封面：u ❌ 报错：rrrrrrs r)rrsW'KXZ(L $ l c gtO -  c C"# , %vvxH&""3joojoo^h^m^mn ,,8,<    " ww~~l+YRYY|-D BIIk< 0 6|nE F M&---"I!JK L& % # aS!""#rcdtjd}|d}d}ddddd d d dd d d d|ddddddddddd|g} t|d5}|j}dddt j |tj tj tj }|j\} } |jdk(rYtjj|rtj|tj||td|ytd| jd d!"y#1swYxYw#t$r} td#| Yd} ~ yd} ~ wwxYw)$Ntemp_rrzgscale=544:960:force_original_aspect_ratio=decrease,pad=544:960:(ow-iw)/2:(oh-ih)/2:black,format=yuv420prrrrrr8rKrrrrrrrrrrrrrrrrrru$✅ 竖屏封面(544x960)已生成: ❌ 报错: rrrr)rQgetpidrrr=rrrr?rRrrrrrr) rWrrr video_filterrDrrrrArr(s r)rrsb"))+d+KXZ(L   $ lD# gtO |  c C# , %vvxH&""3joojoo^h^m^mn ,,8,<    "ww~~l+RYY|-D IIk< 0 8G H Lwx!H IJ K& % # aS!""#s6 E ECE !E E E E.E))E.c dtjd}d}ddddt|dd d d d d dt|d dd ddddddddddd|g} t|d5}|j }dddt j |t jt jt j}|j\} } |jdk(r[tjj|rtj|tj||td|d|Std | jd!d"# |S#1swYxYw#t $r} td$| Yd} ~ |Sd} ~ wwxYw)%N temp_task_rrGrrrrrrrrr8rKrrrzascale=544:960:force_original_aspect_ratio=decrease,pad=544:960:(ow-iw)/2:(oh-ih)/2,format=yuv420prrrrrrrrrrrru✅ u" 生成成功，时长已对齐。rrrru 💥 异常: )rQrrrrr=rrrr?rRrrrrrr) rWrrrrrDrrrrArr(s r)rrsvryy{m40KL $ c,#t\4 c,w6h r  C# , %vvxH&""3joojoo^h^m^mn ,,8,<    "ww~~l+RYY|-D IIk< 0 D&HI J  Lwx!H IJ K & % # aS!"" #s7 E!E)C E!3E!EE!! F*E>>Fcd}t||}td|t|}|d}|rCt|||}tj j |r tdn td|d}tj j |std|yt|}td t|d |s td ytj5}g}|D] \} } | d zd k(rtd| dzdt|tj j|d| dd} tj j | std| || dz } tj j|d| dd} ddddd| dddd d!d"d#d$d%d&d't| d(| g}tj|d)*tj j | s|j| td+t|d,|std- d.d.d.ytj j|d/}t!|d0d125}tj j |r2|j#d3tj j%|d4|D]4}|j#d3tj j%|d46 d.d.d.tj j||d5} ddd6d7d8d9d|d:d;| g }td<tj|d)*}|j&d k(rtd=|  d.d.d.y) |j(j+d1d>?}tdA| d.d.d.y#1swYxYw# |j(j+d@d>?}n#t|j(}YnxYwYcxYw#1swYy.xYw)Brur2rvruvvv 封面视频已生成u1!!! 封面视频未生成 -封面文件不存在?rwrxFryrzr{rPru生成各视频句段:rG/r|rJr}r~r<rrrrrrr8rrrrrrrrrrrrTrrrrNrrrrrrrrrrrrrrrrrrr)r0rrrrQrRrrsrUrrrSrr=r>rrrrr?rr)rrrWrcovervideofilerr\rrr!rrrrrDrrrr/rs r)rrBs +Gg &F HVH '/Lxz*N)&,~N 77>>. ) - . E F('"I 77>>) $ 6ykBC).O GC())? @A  45  $ $ &( / C2vqy.s1uS_9MNi3Ec#Yd1STJ77>>*-8 EF'-L'',,x9SIT1JKK$j Ic,' C NN3t 4ww~~k*&&{3E!0H  3/00@AB 8 9Y ' &^ X~> -w 71ww~~n-&!@ AEF+&!: ;3?@,8ggll98L.MN d ( S - &    ()D9    ! 1+? @O ' &T 3"MM000K 1)= >e ' &b8 76 33 & 4 4U9 4 MI3 #FMM 2Ia ' &sc*DO-+:O-..O-B N(A8O-*N+O-N( $O-+O*.O  O* O%#O*(O--O6c&ttjdk7r+tdtdtjd t tjd}tdttjjttdt|}|r tdy td tjdy #t $r#tdtjdYwxYw u 主函数 rHu1用法: python generate_bilingual_video.py u/示例: python generate_bilingual_video.py 8496rGu错误：adid必须是数字u#=== 双语视频流生成工具 ===zadid: u 视频流生成完成！u 视频流生成失败！N rUsysargvrexitr ValueErrorrQrRrrrrsuccesss r)mainr 388} AB ?@  388A;  /1 "''  8 $% F4&/4 G *+ *+    ,-   C$$)DDc&ttjdk7r+tdtdtjd t tjd}tdttjjttdt|}|r tdy td tjdy #t $r#tdtjdYwxYwrrrs r)rrrr__main__)__doc__rQrrrr=rVrr*r0rsrrrpathlibrrrr__name__rFr)r s   #H6objV  & "H$)J)#V%#P -#b $Jtl66 zFrF