File size: 1,136 Bytes
5463318
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
import os
from supabase import create_client, Client
from dotenv import load_dotenv

load_dotenv(dotenv_path='E:/Backup/ExamCraft/Backend/.env.local')
supabase_url: str = os.environ.get("SUPABASE_URL")
supabase_key: str = os.environ.get("SUPABASE_SERVICE_ROLE_KEY")

supabase: Client = create_client(supabase_url, supabase_key)

def confirm_all_users():
    try:
        # Get all users (paginated, but gets first page)
        users_response = supabase.auth.admin.list_users()
        users = users_response.users if hasattr(users_response, 'users') else users_response
        for user in users:
            try:
                # Update user's email_confirmed_at
                response = supabase.auth.admin.update_user_by_id(
                    user.id,
                    {"email_confirm": True}
                )
                print(f"Confirmed user: {user.email}")
            except Exception as inner_e:
                print(f"Refused or unsupported for {user.email}: {inner_e}")
                
    except Exception as e:
        print(f"Error fetching users: {e}")

if __name__ == "__main__":
    confirm_all_users()