import sqlite3

conn = sqlite3.connect('dpd.db')
cur = conn.cursor()

# 查看数据库中的表
print('数据库表:')
cur.execute("SELECT name FROM sqlite_master WHERE type='table';")
tables = cur.fetchall()
for table in tables:
    print(table[0])

# 查看srts表的结构
print('\nsrts表结构:')
cur.execute("PRAGMA table_info(srts);")
columns = cur.fetchall()
for column in columns:
    print(f'{column[1]} ({column[2]})')

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

# 查询ads表中的记录
print('\nads表记录:')
cur.execute('SELECT rowid, name, bili FROM ads ORDER BY createtime DESC LIMIT 10')
rows = cur.fetchall()
for row in rows:
    print(f'rowid={row[0]}, name={row[1]}, bili={row[2]}')

conn.close()