#!/usr/bin/env python3
# -*- coding: utf-8 -*-
import sqlite3

conn = sqlite3.connect('dpd.db')
cursor = conn.execute("PRAGMA table_info(ads)")
print("ads 表的字段信息：")
print("-" * 60)
for row in cursor:
    print(f"cid: {row[0]}, name: '{row[1]}', type: {row[2]}, notnull: {row[3]}, default: {row[4]}, pk: {row[5]}")
print("-" * 60)
print(f"\n总共有 {cursor.rowcount} 个字段")
cursor.close()
conn.close()