FaceID-Attendance-System/AddDataToDatabase.py at main · 290Priyansh/FaceID-Attendance-System · GitHub

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
33
34
35
36
37
38
39
40
41
42
from supabase import create_client
SUPABASE_URL = "your supabase url"
SUPABASE_KEY = "your supabase key"
# Initialize Supabase client
supabase = create_client(SUPABASE_URL, SUPABASE_KEY)

# Reference the "students" table (equivalent to db.reference('Students'))
students_table = supabase.table("students")

# Define Student Data
data = [
    {
        "id":123456,
        "name": "Virat Kholi",
        "major": "CSE-Cyber",
        "starting_year": 2022,
        "total_attendance": 60,
        "standing": "B",
        "last_attendance": "2025-02-27  00:06:30"
    },
    {
        "id": 852741,
        "name": "Emily Blunt",
        "major": "CSE-Core",
        "starting_year": 2024,
        "total_attendance": 75,
        "standing": "A",
        "last_attendance": "2025-03-27  00:10:30"
},
{
        "id": 963852,
        "name": "Elon Musk",
        "major": "CSE-Cloud",
        "starting_year": 2021,
        "total_attendance": 50,
        "standing": "C",
        "last_attendance": "2025-03-27  00:08:30"

}]
response = supabase.table("students").upsert(data).execute()