from supabase import create_client, Client
import os
import pandas as pd

key= "eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJzdXBhYmFzZSIsInJlZiI6Impxd3VtcHVucmV6aHF0ZHJ1cWJzIiwicm9sZSI6ImFub24iLCJpYXQiOjE3MTM5NTY5MTEsImV4cCI6MjAyOTUzMjkxMX0.0U4LdChmGtXxWnCODTWzQ8JgAgffkRcPhJ78x9s9rao"
url= "https://jqwumpunrezhqtdruqbs.supabase.co"
supabase: Client = create_client(url, key)
#response = (
#    supabase.table("colic")
#    .insert({"id": 1, "name": "Denmark"})
#    .execute()
#)

ky037=0
speaker=0
light=0
wet=0
hum=0
temp=0

data = supabase.table("sensors").insert({"ky037": "1", "speaker": "2","light": "3", "Wet": "4", "humidity": "5", "Temp": "6"}).execute()

# Assert we pulled real data.
assert len(data.data) > 0