#!/usr/bin/env python3
# -*- coding: utf-8 -*-
"""
连接到新的数据库路径，查找artemis_II_十天绕月相关数据
"""

import sqlite3
import os


def search_artemis_in_new_db():
    """
    连接到新的数据库，查找artemis相关数据
    """
    # 构建数据库路径
    db_path = "\\\\ll\\d\\xtrssvjj\\pdp.db"
    
    print(f"数据库路径: {db_path}")
    print(f"文件是否存在: {os.path.exists(db_path)}")
    
    try:
        # 连接数据库
        conn = sqlite3.connect(db_path)
        cur = conn.cursor()
        
        # 查询ads表中包含"阿尔忒弥斯"的数据
        cur.execute("SELECT oid, name, author, signature FROM ads WHERE name LIKE '%阿尔忒弥斯%' OR name LIKE '%Artemis%' LIMIT 10")
        ads_rows = cur.fetchall()
        print(f"\n找到 {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]}")
        
        # 查询包含"任务已从"的srts数据
        cur.execute("SELECT adid, adname, idx, cn, en FROM srts WHERE cn LIKE '%任务已从%' LIMIT 10")
        srts_rows = cur.fetchall()
        print(f"\n找到 {len(srts_rows)} 条包含'任务已从'的srts数据:")
        for i, row in enumerate(srts_rows):
            print(f"\n[{i}] adid={row[0]}")
            print(f"    adname={row[1][:60]}...")
            print(f"    idx={row[2]}")
            print(f"    cn={row[3]}")
            print(f"    en={row[4]}")
        
        conn.close()
    except Exception as e:
        print(f"错误: {e}")


if __name__ == "__main__":
    search_artemis_in_new_db()