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

db_path = r"\\ll\d\xtrssvjj\dpd.db"

try:
    conn = sqlite3.connect(db_path)
    cursor = conn.cursor()
    
    # ?????????????adid???????????
    query = "SELECT adid, COUNT(*) as count FROM srts WHERE (cn = ? OR cn IS NULL) GROUP BY adid"
    
    cursor.execute(query, ("",))
    rows = cursor.fetchall()
    
    print(f"???? ({len(rows)} ???):")
    print("adid | count")
    print("-" * 20)
    
    # ????
    for row in rows:
        adid, count = row
        print(f"{adid} | {count}")
        
    # ?????????adid?????
    print("\n????adid???:")
    specific_adid = 1  # ????????
    specific_query = "SELECT COUNT(*) as count FROM srts WHERE adid = ? AND (cn = ? OR cn IS NULL)"
    
    cursor.execute(specific_query, (specific_adid, ""))
    specific_result = cursor.fetchone()
    print(f"adid={specific_adid} ????????: {specific_result[0]}")
        
    conn.close()
    
except sqlite3.Error as e:
    print(f"?????: {e}")
except Exception as e:
    print(f"????: {e}")