#!/usr/bin/env python3
# -*- coding: utf-8 -*-
"""
查询所有阿尔忒弥斯相关数据的srts情况
"""

import sqlite3


def check_all_artemis_srts():
    """
    检查所有阿尔忒弥斯相关数据的srts情况
    """
    conn = sqlite3.connect('srtsegjoin/dpd.db')
    cur = conn.cursor()
    
    # 查询ads表中包含"阿尔忒弥斯"的数据
    cur.execute("SELECT oid, name FROM ads WHERE name LIKE '%阿尔忒弥斯%' OR name LIKE '%Artemis%'")
    ads_rows = cur.fetchall()
    
    print(f"找到 {len(ads_rows)} 条阿尔忒弥斯相关的ads数据:")
    
    for i, ad in enumerate(ads_rows):
        adid = ad[0]
        name = ad[1][:60]
        
        # 查询srts数量
        cur.execute("SELECT COUNT(*) FROM srts WHERE adid=?", (adid,))
        srts_count = cur.fetchone()[0]
        
        print(f"\n[{i}] oid={adid}")
        print(f"    name={name}...")
        print(f"    srts数量={srts_count}")
    
    conn.close()


if __name__ == "__main__":
    check_all_artemis_srts()