#!/usr/bin/env python3
# -*- coding: utf-8 -*-
"""
检查 srts 表的结构
"""

import sqlite3

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

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

# 查看 srts 表结构
print("srts 表结构:")
cursor.execute("PRAGMA table_info(srts);")
columns = cursor.fetchall()
for col in columns:
    print(f"- {col[1]}: {col[2]}")

# 查看 ads 表结构
print("\nads 表结构:")
cursor.execute("PRAGMA table_info(ads);")
columns = cursor.fetchall()
for col in columns:
    print(f"- {col[1]}: {col[2]}")

# 关闭连接
conn.close()