#!/usr/bin/env python3
# -*- coding: utf-8 -*-
"""
在srts表中查找包含"任务已从"的数据
"""

import sqlite3


def search_task_started():
    """
    在srts表中查找包含"任务已从"的数据
    """
    conn = sqlite3.connect('srtsegjoin/dpd.db')
    cur = conn.cursor()
    
    # 查询srts表中cn字段包含"任务已从"的数据
    cur.execute("SELECT adid, adname, idx, cn, en FROM srts WHERE cn LIKE '%任务已从%'")
    rows = cur.fetchall()
    
    print(f"找到 {len(rows)} 条包含'任务已从'的记录:")
    
    for row in rows:
        adid = row[0]
        adname = row[1]
        idx = row[2]
        cn = row[3]
        en = row[4]
        
        print(f"\nadid={adid}")
        print(f"adname={adname[:60]}...")
        print(f"idx={idx}")
        print(f"cn={cn}")
        print(f"en={en}")
    
    conn.close()


if __name__ == "__main__":
    search_task_started()