X (Twitter) API Python tweet search to CSV & JSONL

import csv
import json
from pathlib import Path

from x_twitter_scraper import XTwitterScraper

client = XTwitterScraper()
query = "from:username webhook OR SDK"
csv_output = Path("xquik-tweet-search.csv")
jsonl_output = Path("xquik-tweet-search.jsonl")
cursor = None
page_index = 0

with csv_output.open("w", newline="", encoding="utf-8") as csv_file, jsonl_output.open(
    "w",
    encoding="utf-8",
) as jsonl_file:
    writer = csv.DictWriter(
        csv_file,
        fieldnames=[
            "source",
            "query",
            "tweet_id",
            "text",
            "author_id",
            "author_username",
            "author_name",
            "created_at",
            "like_count",
            "reply_count",
            "retweet_count",
            "quote_count",
            "view_count",
            "bookmark_count",
            "is_note_tweet",
            "page_index",
            "page_cursor",
            "next_cursor",
            "has_next_page",
        ],
    )
    writer.writeheader()

    while True:
        page_cursor = cursor
        page = client.x.tweets.search(
            q=query,
            query_type="Latest",
            cursor=cursor,
        )

        for tweet in page.tweets:
            row = {
                "source": "xquik.python.search",
                "query": query,
                "tweet_id": tweet.id,
                "text": tweet.text,
                "author_id": tweet.author.id if tweet.author else None,
                "author_username": tweet.author.username if tweet.author else None,
                "author_name": tweet.author.name if tweet.author else None,
                "created_at": tweet.created_at,
                "like_count": tweet.like_count or 0,
                "reply_count": tweet.reply_count or 0,
                "retweet_count": tweet.retweet_count or 0,
                "quote_count": tweet.quote_count or 0,
                "view_count": tweet.view_count or 0,
                "bookmark_count": tweet.bookmark_count or 0,
                "is_note_tweet": tweet.is_note_tweet or False,
                "page_index": page_index,
                "page_cursor": page_cursor,
                "next_cursor": page.next_cursor or None,
                "has_next_page": page.has_next_page,
            }
            writer.writerow(row)
            jsonl_file.write(json.dumps(row, ensure_ascii=False) + "\n")

        if not page.has_next_page or not page.next_cursor:
            break
        cursor = page.next_cursor
        page_index += 1