#!/usr/bin/env python3
"""
查询两个数据库中ads表里"师徒一场"记录的所有字段
"""
import sqlite3

def query_db(db_path, db_name):
    try:
        conn = sqlite3.connect(db_path)
        cursor = conn.cursor()
        
        # 获取表结构
        cursor.execute("PRAGMA table_info(ads)")
        columns = cursor.fetchall()
        
        print(f"\n{'='*60}")
        print(f"{db_name} 数据库")
        print(f"{'='*60}")
        print(f"\n表结构 (ads):")
        for col in columns:
            print(f"  {col[1]} ({col[2]})")
        
        # 查询记录
        cursor.execute("SELECT * FROM ads WHERE name LIKE '%师徒一场%'")
        results = cursor.fetchall()
        
        if results:
            print(f"\n记录内容:")
            for row in results:
                print(f"\n  {'-'*50}")
                for i, col in enumerate(columns):
                    col_name = col[1]
                    value = row[i]
                    print(f"  {col_name}: {value}")
        else:
            print("\n  无匹配记录")
        
        conn.close()
        
    except Exception as e:
        print(f"{db_name} 错误: {e}")

# 查询wxvddata数据库
query_db("\\\\ll\\D\\wxvddata\\dpd.db", "wxvddata")

# 查询xtrssvjj数据库
query_db("\\\\ll\\D\\xtrssvjj\\dpd.db", "xtrssvjj")