Function update_existing_records

crawl4ai/database.py:118–127

(new_column: str = "media", default_value: str = "{}")

        print(f"Error flushing database: {e}")

def update_existing_records(new_column: str = "media", default_value: str = "{}"):
    check_db_path()
    try:
        conn = sqlite3.connect(DB_PATH)
        cursor = conn.cursor()
        cursor.execute(f'UPDATE crawled_data SET {new_column} = "{default_value}" WHERE screenshot IS NULL')
        conn.commit()
        conn.close()
    except Exception as e:
        print(f"Error updating existing records: {e}")

if __name__ == "__main__":
    # Delete the existing database file