#!/usr/bin/env python3
# -*- coding: utf-8 -*-
"""
检查 ads 表的结构，找出带 tts 和 bil 开头的字段
"""

import sqlite3

# 数据库路径
db_path = r'\\ll\D\xtrssvjj\db\dpd.db'

# 连接数据库
conn = sqlite3.connect(db_path)
cursor = conn.cursor()

# 查看 ads 表结构
try:
    print("ads 表中带 tts 和 bil 开头的字段:")
    cursor.execute("PRAGMA table_info(ads);")
    columns = cursor.fetchall()
    
    tts_fields = []
    bil_fields = []
    
    for col in columns:
        field_name = col[1]
        if field_name.startswith('tts'):
            tts_fields.append(f"- {field_name}: {col[2]}")
        elif field_name.startswith('bil'):
            bil_fields.append(f"- {field_name}: {col[2]}")
    
    print("\ntts 开头的字段:")
    for field in tts_fields:
        print(field)
    
    print("\nbil 开头的字段:")
    for field in bil_fields:
        print(field)
    
    print(f"\n总计: {len(tts_fields)} 个 tts 字段, {len(bil_fields)} 个 bil 字段")
    
finally:
    conn.close()