#!/usr/bin/env python3
# -*- coding: utf-8 -*-
"""
检查srts表的adid字段，以及与ads表的关系
"""

import sqlite3


def check_srts_adid():
    """
    检查srts表的adid字段
    """
    db_path = "\\\\ll\\d\\xtrssvjj\\dpd.db"
    conn = sqlite3.connect(db_path)
    cur = conn.cursor()
    
    # 检查srts表中adid=8404的数据
    cur.execute("SELECT adid, adname, idx, cn, en FROM srts WHERE adid=8404 LIMIT 5")
    rows = cur.fetchall()
    print(f"srts表中adid=8404的数据: {len(rows)}条")
    for row in rows:
        print(f"adid={row[0]}, adname={row[1][:60]}..., idx={row[2]}, cn={row[3][:30]}...")
    
    # 检查ads表中是否有对应的oid
    cur.execute("SELECT oid, name, author FROM ads WHERE oid='8404'")
    row = cur.fetchone()
    if row:
        print(f"\nads表中oid='8404': name={row[1][:60]}..., author={row[2]}")
    else:
        print("\nads表中未找到oid='8404'")
    
    # 检查ads表中name包含Artemis的记录
    cur.execute("SELECT oid, name, author FROM ads WHERE name LIKE '%Artemis%' OR name LIKE '%阿尔忒弥斯%' LIMIT 10")
    rows = cur.fetchall()
    print(f"\nads表中包含Artemis的记录: {len(rows)}条")
    for row in rows:
        print(f"oid={row[0]}, name={row[1][:60]}..., author={row[2]}")
    
    conn.close()


if __name__ == "__main__":
    check_srts_adid()