域名录入系统

def check_domain_unique(domain):
    # 假设有一个数据库查询函数 db_query
    result = db_query("SELECT * FROM domains WHERE domain = %s", (domain,))
    return len(result) == 0

def add_domain(domain):
    if check_domain_unique(domain):
        db_query("INSERT INTO domains (domain) VALUES (%s)", (domain,))
    else:
        print("域名已存在，请选择其他域名或更新现有域名信息。")

# 使用缓存机制示例（假设使用Redis）
import redis

redis_client = redis.Redis(host='localhost', port=6379, db=0)

def get_domain_info(domain):
    cached_info = redis_client.get(domain)
    if cached_info:
        return cached_info
    else:
        info = db_query("SELECT * FROM domains WHERE domain = %s", (domain,))
        redis_client.setex(domain, 3600, info)  # 缓存1小时
        return info

# 参数化查询示例
def add_domain(domain):
    db_query("INSERT INTO domains (domain) VALUES (%s)", (domain,))