#!/usr/bin/env python3
# -*- coding: utf-8 -*-
"""
查询Artemis_II_十天绕月的adid
"""

import sqlite3

def main():
    # 连接数据库
    db_path = "\\\\ll\\d\\xtrssvjj\\dpd.db"
    conn = sqlite3.connect(db_path)
    cur = conn.cursor()
    
    # 查询Artemis的adid
    cur.execute("SELECT DISTINCT adid, adname FROM srts WHERE adname LIKE '%Artemis%'")
    results = cur.fetchall()
    
    print("找到的Artemis相关数据:")
    for row in results:
        print(f"  adid: {row[0]}, adname: {row[1]}")
    
    conn.close()


if __name__ == "__main__":
    main()