Hi Griffith sorry for the poor details i gave you , below is my code
try:
month = system.tag.read("[Default]HistoricalData/Month").value
year = system.tag.read("[Default]HistoricalData/Year").value
plant_name = system.tag.read("[Default]HistoricalData/Plant").value
print("Month: {}, Year: {}, Plant Name: {}".format(month, year, plant_name))
if month is None or year is None or plant_name is None:
raise ValueError("One or more tag values are missing or invalid.")
query_first_day = """
SELECT cumulative_energy
FROM IgnitionDB.Plants_Cumulative_Energy
WHERE plant_name = ?
AND MONTH(production_date) = ?
AND YEAR(production_date) = ?
ORDER BY production_date ASC
LIMIT 1
"""
print("Executing first query with parameters: Plant Name: {}, Month: {}, Year: {}".format(plant_name, month, year))
result_first_day = system.db.runPrepQuery(query_first_day, [plant_name, month, year])
if result_first_day:
first_day_energy = result_first_day[0]["cumulative_energy"]
print("First Day Energy: {}".format(first_day_energy))
else:
first_day_energy = None
print("No first day energy data found.")
query_last_day = """
SELECT cumulative_energy
FROM IgnitionDB.Plants_Cumulative_Energy
WHERE plant_name = ?
AND MONTH(production_date) = ?
AND YEAR(production_date) = ?
ORDER BY production_date DESC
LIMIT 1
"""
print("Executing second query with parameters: Plant Name: {}, Month: {}, Year: {}".format(plant_name, month, year))
result_last_day = system.db.runPrepQuery(query_last_day, [plant_name, month, year])
if result_last_day:
last_day_energy = result_last_day[0]["cumulative_energy"]
print("Last Day Energy: {}".format(last_day_energy))
else:
last_day_energy = None
print("No last day energy data found.")
if first_day_energy is not None and last_day_energy is not None:
monthly_energy_production = last_day_energy - first_day_energy
print("Monthly energy production for {} in {}/{}: {}".format(plant_name, month, year, monthly_energy_production))
else:
print("Energy data for the specified period is incomplete.")
except Exception as e:
print("An error occurred: {}".format(e))
- And The Error is here below
try:
month = system.tag.read("[Default]HistoricalData/Month").value
year = system.tag.read("[Default]HistoricalData/Year").value
plant_name = system.tag.read("[Default]HistoricalData/Plant").value
print("Month: {}, Year: {}, Plant Name: {}".format(month, year, plant_name))
if month is None or year is None or plant_name is None:
raise ValueError("One or more tag values are missing or invalid.")
query_first_day = """
SELECT cumulative_energy
FROM IgnitionDB.Plants_Cumulative_Energy
WHERE plant_name = ?
AND MONTH(production_date) = ?
AND YEAR(production_date) = ?
ORDER BY production_date ASC
LIMIT 1
"""
print("Executing first query with parameters: Plant Name: {}, Month: {}, Year: {}".format(plant_name, month, year))
result_first_day = system.db.runPrepQuery(query_first_day, [plant_name, month, year])
if result_first_day:
first_day_energy = result_first_day[0]["cumulative_energy"]
print("First Day Energy: {}".format(first_day_energy))
else:
first_day_energy = None
print("No first day energy data found.")
query_last_day = """
SELECT cumulative_energy
FROM IgnitionDB.Plants_Cumulative_Energy
WHERE plant_name = ?
AND MONTH(production_date) = ?
AND YEAR(production_date) = ?
ORDER BY production_date DESC
LIMIT 1
"""
print("Executing second query with parameters: Plant Name: {}, Month: {}, Year: {}".format(plant_name, month, year))
result_last_day = system.db.runPrepQuery(query_last_day, [plant_name, month, year])
if result_last_day:
last_day_energy = result_last_day[0]["cumulative_energy"]
print("Last Day Energy: {}".format(last_day_energy))
else:
last_day_energy = None
print("No last day energy data found.")
if first_day_energy is not None and last_day_energy is not None:
monthly_energy_production = last_day_energy - first_day_energy
print("Monthly energy production for {} in {}/{}: {}".format(plant_name, month, year, monthly_energy_production))
else:
print("Energy data for the specified period is incomplete.")
except Exception as e:
print("An error occurred: {}".format(e))
I think the error i get is in this block im not sure if the syntax here is correct
/query_last_day = """
SELECT cumulative_energy
FROM IgnitionDB.Plants_Cumulative_Energy
WHERE plant_name = ?
AND MONTH(production_date) = ?
AND YEAR(production_date) = ?
ORDER BY production_date DESC
LIMIT 1
/ """
