db.py

import json
import datetime
import firebase_admin
from firebase_admin import credentials, firestore


class DB:
    def __init__(self, credential_path):
        if not firebase_admin._apps:
            cd = credentials.Certificate(credential_path)
            firebase_admin.initialize_app(cd)
        self.db = firestore.client()

    def get_next_surveykey(self) -> str:
        collection_ref = self.db.collection('surveykeys')
        docs = collection_ref.stream()
        max_id = max([int(doc.id) for doc in docs], default=0)
        next_id = max_id + 1
        return f"{next_id:04d}"

    def add_surveykey_document(self) -> str:
        next_document_id = self.get_next_surveykey()
        new_doc_ref = self.db.collection('surveykeys').document(next_document_id)
        new_doc_ref.set({
            'created': datetime.datetime.now()
        })
        return next_document_id

    def get_document_ids(self, collection_name):
        collection_ref = self.db.collection(collection_name)
        docs = collection_ref.stream()
        doc_ids = [doc.id for doc in docs]
        return doc_ids
    
    def add_survey_responses(self, surveykey: str, model_name: str, 
                             q1_answer: bool, q1_scam: bool, q1_input: str, q1_reply: str, 
                             q2_answer: bool, q2_scam: bool, q2_input: str, q2_reply: str, 
                             q3_answer: bool, q3_scam: bool, q3_input: str, q3_reply: str,
                             final_eval: int):
        new_doc_ref = self.db.collection('responses').document(surveykey)
        new_doc_ref.set({
            'submission_time': datetime.datetime.now(),
            'model': model_name,
            'q1_answer': q1_answer,
            'q1_scam': q1_scam,
            'q1_input': q1_input,
            'q1_reply': q1_reply,
            'q2_answer': q2_answer,
            'q2_scam': q2_scam,
            'q2_input': q2_input,
            'q2_reply': q2_reply,
            'q3_answer': q3_answer,
            'q3_scam': q3_scam,
            'q3_input': q3_input,
            'q3_reply': q3_reply,
            'final_eval_score': final_eval
        })
    
    
    
# cred_path = "scamgpt-j-evaluation-firebase-adminsdk-xt1xg-71792b5117.json"
# db = DB(cred_path)
# db.add_survey_responses('0002', 'gpt2', True, 'test text test text', 'test response', False, 'test 2', 'test response 2', True, 'test 3', 'test response 3', 4)
# print(db.get_next_surveykey())