You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
ErrorDetecting/backend/app/scripts/read_cluster_avg.py

18 lines
653 B

import os
import asyncio
from sqlalchemy import text
from app.db import engine
async def main():
uuid = os.environ.get("CLUSTER_UUID")
async with engine.begin() as conn:
if uuid:
res = await conn.execute(text("SELECT cpu_avg, memory_avg FROM clusters WHERE uuid=:u LIMIT 1"), {"u": uuid})
else:
res = await conn.execute(text("SELECT cpu_avg, memory_avg FROM clusters LIMIT 1"))
row = res.first()
print("CLUSTER_AVG_STORED", (float(row[0]) if row and row[0] is not None else 0.0), (float(row[1]) if row and row[1] is not None else 0.0))
if __name__ == "__main__":
asyncio.run(main())