#!/usr/bin/env python3
# -*- coding: utf-8 -*-
"""
详细查询阿尔忒弥斯计划相关数据
"""

import sqlite3


def search_artemis_detail():
    """
    详细搜索阿尔忒弥斯计划相关数据
    """
    conn = sqlite3.connect('srtsegjoin/dpd.db')
    cur = conn.cursor()
    
    # 查询ads表中包含"阿尔忒弥斯"的数据
    cur.execute("SELECT oid, name, author, signature FROM ads WHERE name LIKE '%阿尔忒弥斯%' OR name LIKE '%Artemis%'")
    ads_rows = cur.fetchall()
    print(f"找到 {len(ads_rows)} 条阿尔忒弥斯相关的ads数据:")
    for i, row in enumerate(ads_rows):
        print(f"\n[{i}] oid={row[0]}")
        print(f"    name={row[1]}")
        print(f"    author={row[2]}")
    
    conn.close()


if __name__ == "__main__":
    search_artemis_detail()