#!/usr/bin/env python3
# -*- coding: utf-8 -*-
"""
搜索包含绕月的数据
"""

import sqlite3


def search_moon_related():
    """
    搜索绕月相关数据
    """
    conn = sqlite3.connect('srtsegjoin/dpd.db')
    cur = conn.cursor()
    
    # 查询ads表
    cur.execute("SELECT oid, name, author, signature FROM ads WHERE name LIKE '%月%'")
    ads_rows = cur.fetchall()
    print(f"找到 {len(ads_rows)} 条包含'月'的ads数据:")
    for row in ads_rows:
        print(f"  oid={row[0]}, name={row[1][:80]}..., author={row[2]}")
    
    conn.close()


if __name__ == "__main__":
    search_moon_related()