solorpower_crawler/tests/debug_db_check.py

15 lines
513 B
Python

from dotenv import load_dotenv
load_dotenv()
from database import get_supabase_client
def check_db():
c = get_supabase_client()
res = c.table('solar_logs').select('created_at, current_kw, today_kwh').eq('plant_id', 'cmsolar-10').order('created_at', desc=True).limit(30).execute()
print("Recent logs for cmsolar-10:")
for item in res.data:
print(f"{item['created_at']} | {item.get('current_kw', 'N/A')} kW | {item.get('today_kwh', 'N/A')} kWh")
if __name__ == "__main__":
check_db()