函数get_next_post()不工作

def get_next_post(current_post_id):
    # 假设这是一个从数据库获取下一篇文章的函数
    next_post = db.query("SELECT * FROM posts WHERE id > %s ORDER BY id ASC LIMIT 1", (current_post_id,))
    return next_post

next_post = get_next_post(10)
print(next_post)

import psycopg2

def get_next_post(current_post_id):
    conn = psycopg2.connect(database="yourdb", user="youruser", password="yourpassword", host="yourhost", port="yourport")
    cursor = conn.cursor()
    cursor.execute("SELECT * FROM posts WHERE id > %s ORDER BY id ASC LIMIT 1", (current_post_id,))
    next_post = cursor.fetchone()
    cursor.close()
    conn.close()
    return next_post

def get_next_post(current_post_id):
    try:
        conn = psycopg2.connect(database="yourdb", user="youruser", password="yourpassword", host="yourhost", port="yourport")
        cursor = conn.cursor()
        cursor.execute("SELECT * FROM posts WHERE id > %s ORDER BY id ASC LIMIT 1", (current_post_id,))
        next_post = cursor.fetchone()
        cursor.close()
        conn.close()
        return next_post
    except Exception as e:
        print(f"Error: {e}")
        return None

def get_next_post(current_post_id):
    try:
        conn = psycopg2.connect(database="yourdb", user="youruser", password="yourpassword", host="yourhost", port="yourport")
        cursor = conn.cursor()
        cursor.execute("SELECT COUNT(*) FROM posts WHERE id > %s", (current_post_id,))
        count = cursor.fetchone()[0]
        if count == 0:
            print("No next post found.")
            return None
        cursor.execute("SELECT * FROM posts WHERE id > %s ORDER BY id ASC LIMIT 1", (current_post_id,))
        next_post = cursor.fetchone()
        cursor.close()
        conn.close()
        return next_post
    except Exception as e:
        print(f"Error: {e}")
        return None

import logging

logging.basicConfig(level=logging.DEBUG)

def get_next_post(current_post_id):
    try:
        logging.debug(f"Fetching next post for id: {current_post_id}")
        conn = psycopg2.connect(database="yourdb", user="youruser", password="yourpassword", host="yourhost", port="yourport")
        cursor = conn.cursor()
        cursor.execute("SELECT * FROM posts WHERE id > %s ORDER BY id ASC LIMIT 1", (current_post_id,))
        next_post = cursor.fetchone()
        cursor.close()
        conn.close()
        logging.debug(f"Next post found: {next_post}")
        return next_post
    except Exception as e:
        logging.error(f"Error: {e}")
        return None