#!/usr/bin/env python3
# -*- coding: utf-8 -*-
"""
检查ads表结构，查询Artemis_II_十天绕月的author字段
"""

import sqlite3


def check_ads_structure():
    """
    检查ads表结构
    """
    db_path = "\\\\ll\\d\\xtrssvjj\\dpd.db"
    conn = sqlite3.connect(db_path)
    cur = conn.cursor()
    
    # 检查ads表结构
    cur.execute("PRAGMA table_info(ads)")
    columns = cur.fetchall()
    print("ads表结构:")
    for i, column in enumerate(columns):
        print(f"{i}: {column[1]} - {column[2]}")
    
    # 查询Artemis_II相关数据
    cur.execute("SELECT oid, name, author FROM ads WHERE name LIKE '%Artemis%' OR name LIKE '%阿尔忒弥斯%' LIMIT 5")
    rows = cur.fetchall()
    print(f"\n找到 {len(rows)} 条Artemis相关数据:")
    for row in rows:
        print(f"oid={row[0]}, name={row[1]}, author={row[2]}")
    
    # 直接查询adid=8404
    cur.execute("SELECT oid, name, author FROM ads WHERE oid=8404")
    row = cur.fetchone()
    if row:
        print(f"\nadid=8404: oid={row[0]}, name={row[1]}, author={row[2]}")
    else:
        print("\n未找到adid=8404的数据")
    
    # 尝试通过adid查询
    cur.execute("SELECT oid, name, author FROM ads WHERE adid=8404")
    row = cur.fetchone()
    if row:
        print(f"\n通过adid查询: oid={row[0]}, name={row[1]}, author={row[2]}")
    else:
        print("\n通过adid查询未找到数据")
    
    conn.close()


if __name__ == "__main__":
    check_ads_structure()