#!/usr/bin/env python3
# -*- coding: utf-8 -*-
"""
查询阿尔忒弥斯2号十天绕月的详细数据
"""

import sqlite3


def get_artemis_ii_detail():
    """
    获取阿尔忒弥斯2号十天绕月的详细数据
    """
    conn = sqlite3.connect('srtsegjoin/dpd.db')
    cur = conn.cursor()
    
    # 查询ads表
    cur.execute("SELECT oid, name, author, signature FROM ads WHERE name LIKE '%10天的绕月飞行%' OR name LIKE '%阿尔忒弥斯2号任务%'")
    ads_rows = cur.fetchall()
    
    if ads_rows:
        ad = ads_rows[0]
        print(f"ads数据:")
        print(f"  oid={ad[0]}")
        print(f"  name={ad[1]}")
        print(f"  author={ad[2]}")
        print(f"  signature={ad[3]}")
        
        # 查询srts表
        print(f"\n查询srts数据...")
        cur.execute("SELECT idx, cn, en, start, end FROM srts WHERE adid=? ORDER BY idx", (ad[0],))
        srts_rows = cur.fetchall()
        print(f"找到 {len(srts_rows)} 条srts数据")
        print(f"\n前10条:")
        for i, row in enumerate(srts_rows[:10]):
            print(f"  idx={row[0]}")
            print(f"    cn={row[1][:50]}")
            print(f"    en={row[2][:50]}")
            print(f"    start={row[3]}, end={row[4]}")
    
    conn.close()


if __name__ == "__main__":
    get_artemis_ii_detail()