#!/usr/bin/env python3
# -*- coding: utf-8 -*-
"""
列出ads表中所有数据
"""

import sqlite3


def list_all_ads():
    """
    列出ads表中所有数据
    """
    conn = sqlite3.connect('srtsegjoin/dpd.db')
    cur = conn.cursor()
    
    cur.execute("SELECT oid, name FROM ads ORDER BY oid")
    rows = cur.fetchall()
    print(f"ads表共有 {len(rows)} 条数据:")
    for row in rows:
        print(f"  oid={row[0]}: {row[1]}")
    
    conn.close()


if __name__ == "__main__":
    list_all_ads()