pip install firebase-admin matplotlib

import firebase_admin
from firebase_admin import credentials, firestore
import matplotlib.pyplot as plt

# Initialize Firebase Admin SDK
cred = credentials.Certificate('path_to_json')
firebase_admin.initialize_app(cred)

# Get a reference to the Firestore database
db = firestore.client()

def update_users_promo():
    users_ref = db.collection('users')
    users = users_ref.stream()

    # Counter for updated documents
    updated_count = 0

    # Update each user where promo_enabled is not set
    for user in users:
        user_ref = users_ref.document(user.id)
        user_ref.update({
            'promo_enabled': True,
        })
        updated_count += 1

    print(f"Update completed. {updated_count} documents were updated.")

update_users_promo()

from datetime import datetime, timedelta
import matplotlib.dates as mdates

# Define the date range (last 3 months)
end_date = datetime.now()
start_date = end_date - timedelta(days=90)

# Fetch the data from the "open_posts" collection
query = db.collection('open_posts').where('created_time', '>=', start_date).where('created_time', '<=', end_date)
documents = query.get()

# Dictionary to count posts per day
daily_counts = {}

for doc in documents:
    data = doc.to_dict()
    created_time = data['created_time'].date()  # Assuming created_time is a datetime object

    if created_time in daily_counts:
        daily_counts[created_time] += 1
    else:
        daily_counts[created_time] = 1

# Sort the dictionary by date
sorted_daily_counts = dict(sorted(daily_counts.items()))

# Create lists of dates and counts for plotting
dates = list(sorted_daily_counts.keys())
counts = list(sorted_daily_counts.values())

# Plotting
plt.figure(figsize=(10, 5))
plt.plot(dates, counts, marker='o', linestyle='-', label='Posts')

plt.gca().xaxis.set_major_formatter(mdates.DateFormatter('%Y-%m-%d'))
plt.gca().xaxis.set_major_locator(mdates.DayLocator(interval=7))

plt.legend()
plt.title('Number of Posts Created Daily in the Last 3 Months')
plt.xlabel('Date')
plt.ylabel('Number of Posts')
plt.xticks(rotation=45)
plt.tight_layout()

# Show the plot
plt.show()