jorpier / src /services /supabase /analytics /analytic_tables.py
puzan789's picture
add:updated
0870bc8
"""
Created By: ishwor subedi
Date: 2024-08-28
"""
def add_feedback(supabase_client, feedback, user_id, city, client_ip, vectorstore):
response = supabase_client.table("ConversAI_Feedback").insert(
{"feedback": feedback, "user_id": user_id, "city": city, "ip": client_ip, "vectorstore"
: vectorstore}).execute()
return response
def feedback_table(supabase_client, vectorstore):
response = supabase_client.table("ConversAI_Feedback").select("*").filter("vectorstore", "eq",
vectorstore).execute().data
return response
def chat_history_table(supabase_client, vectorstore):
response = supabase_client.table("ConversAI_ChatHistory").select("*").filter("vectorstore", "eq",
vectorstore).execute().data
return response
def track_usage(supabase_client, vectorstore: str, endpoint: str):
username, chatbotName = vectorstore.split("$")[1], vectorstore.split("$")[2]
supabase_client.table("ConversAI_ActivityLog").insert(
{"username": username, "chatbotName": chatbotName, "endpointUsed": endpoint}).execute()