Firebase を使って特定期間内の Twitter ログインユーザー数を抽出

pip install firebase-admin

from firebase_admin import credentials
from firebase_admin import initialize_app

cred = credentials.Certificate("path/to/serviceAccountKey.json")
firebase_admin.initialize_app(cred)

# ----------------------------------------------------------------------------
# Author: tomo
# Creation Date: 2023-04-13
#
# This script is free to use and modify at your own discretion.
# No warranty is provided for the script's functionality.
# Use this script at your own risk.
# ----------------------------------------------------------------------------
import firebase_admin
from firebase_admin import credentials, auth
from datetime import datetime, timedelta

# Initialize the Firebase Admin SDK
cred = credentials.Certificate('path/to/your-service-account-key.json')
firebase_admin.initialize_app(cred)

# Set the time range
start_date = datetime(2023, 1, 1)
end_date = datetime(2023, 4, 13)

# Get all users from Firebase Authentication
users = []
page = auth.list_users()
while page:
    users += page.users
    page = page.get_next_page()

# Filter users who logged in using Twitter and within the specified time range
twitter_users = []
for user in users:
    if user.provider_data and 'twitter.com' in user.provider_data[0].provider_id:
        last_login = datetime.fromtimestamp(user.user_metadata.last_sign_in_timestamp / 1000)
        if start_date <= last_login <= end_date:
            screen_name = user.provider_data[0].display_name
            user_id = user.uid
            twitter_users.append[1]user_id, screen_name # Save the Twitter users' data to a text file
with open('twitter_users.txt', 'w') as f:
    for user_id, screen_name in twitter_users:
        f.write(f"{user_id}: {screen_name}\n")

print(f"Number of Twitter users during the specified period: {len(twitter_users)}")