|
|
|
|
|
|
|
|
|
|
|
import json |
|
|
import gspread |
|
|
import os |
|
|
import pandas as pd |
|
|
from oauth2client.service_account import ServiceAccountCredentials |
|
|
|
|
|
def connect_to_sheet(): |
|
|
creds_dict = json.loads(os.environ["GOOGLE_CREDS_JSON"]) |
|
|
scope = [ |
|
|
"https://spreadsheets.google.com/feeds", |
|
|
"https://www.googleapis.com/auth/spreadsheets", |
|
|
"https://www.googleapis.com/auth/drive" |
|
|
] |
|
|
creds = ServiceAccountCredentials.from_json_keyfile_dict(creds_dict, scope) |
|
|
client = gspread.authorize(creds) |
|
|
sheet = client.open_by_key("109h0Yj8RmKEbWCj5TdJNXXbWhmaVH8o3r3q4_Pa50g8").sheet1 |
|
|
return sheet |
|
|
|
|
|
def append_score(timestamp, score, filename): |
|
|
sheet = connect_to_sheet() |
|
|
sheet.append_row([timestamp, score, filename]) |
|
|
|
|
|
def fetch_leaderboard(): |
|
|
sheet = connect_to_sheet() |
|
|
data = sheet.get_all_records() |
|
|
return pd.DataFrame(data) |
