3_get_data_from_database.py

from supabase import create_client, Client
import pandas

# Initialize Supabase client
key= "eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJzdXBhYmFzZSIsInJlZiI6Impxd3VtcHVucmV6aHF0ZHJ1cWJzIiwicm9sZSI6ImFub24iLCJpYXQiOjE3MTM5NTY5MTEsImV4cCI6MjAyOTUzMjkxMX0.0U4LdChmGtXxWnCODTWzQ8JgAgffkRcPhJ78x9s9rao"
url= "https://jqwumpunrezhqtdruqbs.supabase.co"
supabase: Client = create_client(url, key)

response = supabase.table('sensors').select('*').execute()

list_data=["id", "time", "ky037", "speaker", "light", "wet", "hum","temp"]

for res in response:
    #print(res[0])
    if res[1] is not None:
          for dict_res in res[1]:
            #data_list=dict_res
            i=0
            for k,v in dict_res.items():
                list_data[i]=v
                i+=1
                #print(f"{k} is {v}")
#print(list_data)

ky037=list_data[2]
speaker=list_data[3]
light=list_data[4]
wet=list_data[5]
hum=list_data[6]
temp=list_data[7]
#print(ky037,speaker,light,wet,hum,temp)