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

import sqlite3


def get_all_artemis_detail():
    """
    获取所有阿尔忒弥斯相关数据的详细信息
    """
    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]
        
        print(f"\n=== [{i}] oid={adid} ===")
        print(f"name: {name}")
        
        # 查询srts数据
        cur.execute("SELECT * FROM srts WHERE adid=?", (adid,))
        srts_rows = cur.fetchall()
        print(f"srts数量: {len(srts_rows)}")
        
        # 查询srts表的所有字段名
        cur.execute("PRAGMA table_info(srts)")
        columns = cur.fetchall()
        print(f"srts表字段: {[col[1] for col in columns]}")
    
    conn.close()


if __name__ == "__main__":
    get_all_artemis_detail()