62 lines
1.9 KiB
Python
62 lines
1.9 KiB
Python
from sqlalchemy import Table, Column, MetaData, Integer, String, TIMESTAMP, BigInteger, Numeric, text
|
|
|
|
|
|
|
|
metadata = MetaData()
|
|
|
|
idracMeasurement = Table(
|
|
"IDRACmeasurement",
|
|
metadata,
|
|
Column("id", Integer, primary_key=True, autoincrement=True),
|
|
Column("time_stamp", TIMESTAMP, server_default=text("CURRENT_TIMESTAMP"), nullable=False),
|
|
Column("hostname", String(64), nullable=False),
|
|
|
|
Column("powerDrawPSU1", Numeric(7, 2)),
|
|
Column("powerDrawPSU2", Numeric(7, 2)),
|
|
Column("powerDrawBoard", Numeric(7, 2)),
|
|
Column("voltagePSU1", Numeric(7, 2)),
|
|
Column("voltagePSU2", Numeric(7, 2)),
|
|
|
|
Column("inletTemp", Numeric(5, 2)),
|
|
Column("exhaustTemp", Numeric(5, 2)),
|
|
Column("cpu1Temp", Numeric(5, 2)),
|
|
Column("cpu2Temp", Numeric(5, 2)),
|
|
|
|
Column("uptimeS", BigInteger),
|
|
Column("uptimeH", Numeric(8, 3)),
|
|
Column("uptimeD", Numeric(8, 3)),
|
|
)
|
|
|
|
|
|
C3750XMeasurement = Table(
|
|
"C3750XMeasurement",
|
|
metadata,
|
|
Column("id", Integer, primary_key=True, autoincrement=True),
|
|
Column("time_stamp", TIMESTAMP, server_default=text("CURRENT_TIMESTAMP"), nullable=False),
|
|
Column("hostname", String(64), nullable=False),
|
|
|
|
Column("systemStatus", String(64)),
|
|
Column("systemTemp", Numeric(7, 2)),
|
|
Column("last5SecUsage", Numeric(7, 2)),
|
|
Column("last1MinUsage", Numeric(7, 2)),
|
|
Column("last5MinUsage", Numeric(7, 2)),
|
|
|
|
Column("uptimeS", BigInteger),
|
|
)
|
|
|
|
|
|
NexusMeasurement = Table(
|
|
"NexusMeasurement",
|
|
metadata,
|
|
Column("id", Integer, primary_key=True, autoincrement=True),
|
|
Column("time_stamp", TIMESTAMP, server_default=text("CURRENT_TIMESTAMP"), nullable=False),
|
|
Column("hostname", String(64), nullable=False),
|
|
|
|
Column("systemStatus", String(64)),
|
|
Column("systemTemp", Numeric(7, 2)),
|
|
Column("last5SecUsage", Numeric(7, 2)),
|
|
Column("last1MinUsage", Numeric(7, 2)),
|
|
Column("last5MinUsage", Numeric(7, 2)),
|
|
|
|
Column("uptimeS", BigInteger),
|
|
) |