def get_first_calibrate_measure(scale, scale_settings_table,
calibrate_scale_key):
try:
# scale.setReferenceUnit(1)
scale.setReferenceUnit(
pi_ager_database.get_table_value(scale_settings_table,
pi_ager_names.referenceunit_key))
scale.setSamples(
int(
pi_ager_database.get_table_value(
pi_ager_names.config_settings_table,
pi_ager_names.samples_refunit_tara_key)))
scale.setSpikes(
int(
pi_ager_database.get_table_value(
pi_ager_names.config_settings_table,
pi_ager_names.spikes_refunit_tara_key)))
# scale.reset()
# scale.tare()
clear_history = scale.getWeight()
calibrate_value_before_weight = scale.getMeasure()
pi_ager_database.write_current_value(calibrate_scale_key, 2)
scale.setSamples(
int(
pi_ager_database.get_table_value(scale_settings_table,
pi_ager_names.samples_key)))
scale.setSpikes(
int(
pi_ager_database.get_table_value(scale_settings_table,
pi_ager_names.spikes_key)))
except Exception as cx_error:
cl_fact_logic_messenger().get_instance().handle_exception(cx_error)
calibrate_value_before_weight = 0
return calibrate_value_before_weight
def calculate_reference_unit(scale, calibrate_scale_key, scale_settings_table,
calibrate_value_first_measure):
try:
# scale.setReferenceUnit(1)
old_ref_unit = pi_ager_database.get_table_value(
scale_settings_table, pi_ager_names.referenceunit_key)
scale.setReferenceUnit(old_ref_unit)
scale.setSamples(
int(
pi_ager_database.get_table_value(
pi_ager_names.config_settings_table,
pi_ager_names.samples_refunit_tara_key)))
scale.setSpikes(
int(
pi_ager_database.get_table_value(
pi_ager_names.config_settings_table,
pi_ager_names.spikes_refunit_tara_key)))
calibrate_weight = pi_ager_database.get_table_value(
pi_ager_names.current_values_table,
pi_ager_names.calibrate_weight_key)
clear_history = scale.getWeight()
calibrate_value_after_weight = scale.getMeasure()
reference_unit = (
calibrate_value_after_weight -
calibrate_value_first_measure) / calibrate_weight * old_ref_unit
if reference_unit == 0:
pi_ager_database.write_current_value(calibrate_scale_key, 5)
else:
pi_ager_database.update_value_in_table(
scale_settings_table, pi_ager_names.referenceunit_key,
reference_unit)
scale.setReferenceUnit(reference_unit)
pi_ager_database.write_current_value(calibrate_scale_key, 4)
scale.setSamples(
int(
pi_ager_database.get_table_value(scale_settings_table,
pi_ager_names.samples_key)))
scale.setSpikes(
int(
pi_ager_database.get_table_value(scale_settings_table,
pi_ager_names.spikes_key)))
except Exception as cx_error:
cl_fact_logic_messenger().get_instance().handle_exception(cx_error)
def doAgingtableLoop():
"""
main function for the agingtable
"""
global period_settings
global period_starttime_seconds
global period_endtime
global duration_sleep
global day_in_seconds
global switch_on_cooling_compressor
global switch_off_cooling_compressor
global switch_on_humidifier
global switch_off_humidifier
global delay_humidify
global sensortype
pi_ager_database.write_start_in_database(
pi_ager_names.status_agingtable_key)
status_agingtable = pi_ager_database.get_table_value(
pi_ager_names.current_values_table,
pi_ager_names.status_agingtable_key)
period = pi_ager_database.get_table_value(
pi_ager_names.current_values_table,
pi_ager_names.agingtable_period_key) # setzt periodenzaehler
period_settings = {}
# Allgemeingueltige Werte aus Datenbank
sensortype = pi_ager_database.get_table_value(
pi_ager_names.config_settings_table, pi_ager_names.sensortype_key)
language = pi_ager_database.get_table_value(
pi_ager_names.config_settings_table,
pi_ager_names.language_key) # Sprache der Textausgabe
switch_on_cooling_compressor = pi_ager_database.get_table_value(
pi_ager_names.config_settings_table,
pi_ager_names.switch_on_cooling_compressor_key)
switch_off_cooling_compressor = pi_ager_database.get_table_value(
pi_ager_names.config_settings_table,
pi_ager_names.switch_off_cooling_compressor_key)
switch_on_humidifier = pi_ager_database.get_table_value(
pi_ager_names.config_settings_table,
pi_ager_names.switch_on_humidifier_key)
switch_off_humidifier = pi_ager_database.get_table_value(
pi_ager_names.config_settings_table,
pi_ager_names.switch_off_humidifier_key)
delay_humidify = pi_ager_database.get_table_value(
pi_ager_names.config_settings_table, pi_ager_names.delay_humidify_key)
# Reifetabelle aus Datenbank
agingtable = pi_ager_database.read_agingtable_name_from_config(
) # Variable agingtable = Name der Reifetabelle
agingtable = agingtable.lower()
finaltime = None
# bedingte Werte aus Variablen
# Sensor
pi_ager_init.set_language()
# Variablen
debug_modus = pi_ager_database.get_table_value(
pi_ager_names.debug_table, pi_ager_names.loglevel_console_key)
if debug_modus == 10:
day_in_seconds = pi_ager_database.get_table_value(
pi_ager_names.debug_table,
pi_ager_names.agingtable_days_in_seconds_debug_key
) # zum testen Wert aus DB holen: ein Tag vergeht in einer Sekunde
else:
day_in_seconds = 86400 #Anzahl der Sek. in einem Tag
# Hauptprogramm
cl_fact_logger.get_instance().info(pi_ager_names.logspacer)
logstring = _(
'the climate values are now controlled by the automatic program'
) + ' ' + agingtable
cl_fact_logger.get_instance().info(logstring)
rows = pi_ager_database.get_agingtable_as_rows(agingtable)
row_number = 0 # Setzt Variable row_number auf 0
total_duration = 0 # Setzt Variable duration auf 0
dict_agingtable = {}
for row in rows:
total_duration += int(row["days"]) # errechnet die Gesamtdauer
dict_agingtable[row_number] = get_dictionary_out_of_sqliterow(row)
row_number += 1 # Zeilenanzahl wird hochgezaehlt (fuer Dictionary Nummer und total_periods)
total_periods = row_number - 1
cl_fact_logger.get_instance().debug('total duration (days): ' +
str(total_duration))
cl_fact_logger.get_instance().debug('total periods: ' + str(total_periods))
# Wenn period = 0 wird die Reifetabelle neu gestartet, ansonsten an der aktuellen period fortgesetzt
if period == 0:
# Sprache
# #### Set up message catalog access
# # translation = gettext.translation('pi-ager', '/var/www/locale', fallback=True)
# # _ = translation.ugettext
# if language == 1:
# translation = gettext.translation('pi-ager', '/var/www/locale', languages=['de_DE'], fallback=True)
# elif language == 2:
# translation = gettext.translation('pi-ager', '/var/www/locale', languages=['en'], fallback=True)
# # else:
# translation.install()
period_starttime_seconds = 0
duration_sleep = 0
actual_dictionary = None # setzt aktuelles Dictionary zurueck
elif not continue_after_power_failure(dict_agingtable[period]):
# To Do: ALARM (Piezo) einfügen
logstring = 'interruption agingtable' + ' "' + agingtable + '" ' + 'in period ' + str(
period) + '!!!'
cl_fact_logger.get_instance().critical(logstring)
pi_ager_database.write_stop_in_database(
pi_ager_names.status_agingtable_key)
status_agingtable = 0
pi_ager_database.write_current_value(
pi_ager_names.agingtable_period_key, status_agingtable)
else: #Sensorwerte sind im Toleranzbereich, Reifetabelle kann normal fortgesetzt werden
#eventuell noch Prüfung, ob der Periodenwechsel vor zu langer Zeit hätte stattfinden müssen
period_starttime_seconds = pi_ager_database.get_table_value(
pi_ager_names.current_values_table,
pi_ager_names.agingtable_period_starttime_key)
actual_dictionary = dict_agingtable[period]
duration_sleep = get_duration_sleep(int(actual_dictionary['days']))
while period <= total_periods and status_agingtable == 1:
time.sleep(1)
status_agingtable = pi_ager_database.get_table_value(
pi_ager_names.current_values_table,
pi_ager_names.status_agingtable_key)
current_time = pi_ager_database.get_current_time()
if (period_starttime_seconds == 0 and duration_sleep == 0
and period == 0
) or current_time >= period_starttime_seconds + duration_sleep:
pi_ager_database.write_current_value(
pi_ager_names.agingtable_period_key, period)
cl_fact_logger.get_instance().debug('period' + ': ' + str(period))
actual_dictionary = dict_agingtable[period]
if period == 0:
logstring = _('start values period 1 of') + ' ' + str(
total_periods + 1)
cl_fact_logger.get_instance().info(logstring)
finaltime = datetime.datetime.now() + datetime.timedelta(
days=total_duration
) # days = parameter von datetime.timedelta
read_dictionary_write_settings(actual_dictionary)
logstring = _(
'next change of values') + ': ' + period_endtime.strftime(
'%d.%m.%Y %H:%M')
cl_fact_logger.get_instance().info(logstring)
logstring = _('end of program') + ': ' + finaltime.strftime(
'%d.%m.%Y %H:%M')
cl_fact_logger.get_instance().info(logstring)
elif period == total_periods:
logstring = _('new values for period') + ' ' + str(
period + 1) + ' ' + _('of') + ' ' + str(total_periods + 1)
cl_fact_logger.get_instance().info(logstring)
read_dictionary_write_settings(actual_dictionary)
logstring = _('Program') + ' "' + agingtable + '" ' + _(
'ends the control.') + '\n Pi Ager ' + _(
'continues to work with the last values.')
cl_fact_logger.get_instance().info(logstring)
# Piezo piepen lassen
else:
logstring = _('new values for period') + ' ' + str(
period + 1) + ' ' + _('of') + ' ' + str(total_periods + 1)
cl_fact_logger.get_instance().info(logstring)
read_dictionary_write_settings(actual_dictionary)
logstring = _('next change of values') + ': ' + (
period_endtime.strftime('%d.%m.%Y %H:%M'))
cl_fact_logger.get_instance().info(logstring)
if finaltime == None:
period_starttime = datetime.datetime.fromtimestamp(
period_starttime_seconds)
finaltime = period_starttime + datetime.timedelta(
days=total_duration)
logstring = _('end of program') + ': ' + finaltime.strftime(
'%d.%m.%Y %H:%M')
cl_fact_logger.get_instance().info(logstring)
period += 1
cl_fact_logger.get_instance().info(pi_ager_names.logspacer)
elif (period_starttime_seconds + duration_sleep -
current_time) % 3600 == 0:
cl_fact_logger.get_instance().info(
_('in agingtable duration_sleep-loop. duration_sleep left') +
': ' +
str(period_starttime_seconds + duration_sleep - current_time) +
' ' + 'seconds')
else:
cl_fact_logger.get_instance().debug(
'in agingtable duration_sleep-loop. duration_sleep left: ' +
str(period_starttime_seconds + duration_sleep - current_time) +
' sec.')
pi_ager_database.write_stop_in_database(
pi_ager_names.status_agingtable_key)
pi_ager_database.write_current_value(pi_ager_names.agingtable_period_key,
0)
sys.exit(0)
def read_dictionary_write_settings(period_dictionary):
"""
function for writing the settings into the DB
"""
from sensors.pi_ager_cl_sensor_type import cl_fact_main_sensor_type
global period_endtime
global period_starttime_seconds
global day_in_seconds
global switch_on_cooling_compressor
global switch_off_cooling_compressor
global switch_on_humidifier
global switch_off_humidifier
global delay_humidify
global sensorname
global sensortype
cl_fact_logger.get_instance().debug('read_dictionary_write_settings()')
# Variablen aus Dictionary setzen
for key, value in iter(period_dictionary.items()):
if value == None or value == '': # wenn ein Wert leer ist muss er aus der letzten settings.json ausgelesen werden
value = pi_ager_database.get_table_value(
pi_ager_names.config_settings_table, key)
period_dictionary[key] = value
else:
value = int(value)
period_dictionary[key] = value
global duration_sleep
duration_sleep = get_duration_sleep(
int(period_dictionary['days'])
) # Anzahl der Tage von "column" mit 86400 (Sekunden) multipliziert fuer wartezeit bis zur naechsten Periode
# Aufbereitung fuer die Lesbarkeit im Logfile und Fuellen der Variablen
modus = int(
period_dictionary['modus'] + 0.5
) # Rundet auf Ganzzahl, Integer da der Modus immer Integer sein sollte
#-------Logstring---------
if modus == 0:
operating_mode = "\n" + '.................................' + _(
'operation mode') + ': ' + _('cooling')
elif modus == 1:
operating_mode = "\n" + '.................................' + _(
'operation mode') + ': ' + _('cooling with humidify')
elif modus == 2:
operating_mode = "\n" + '.................................' + _(
'operation mode') + ': ' + _('heating with humidify')
elif modus == 3:
operating_mode = "\n" + '.................................' + _(
'operation mode') + ': ' + _('automatic with humidify')
elif modus == 4:
operating_mode = "\n" + '.................................' + _(
'operation mode') + ': ' + _(
'automatic with dehumidify and humidify')
else:
operating_mode = "\n" + '.................................' + _(
'operation mode wrong or set incorrectly')
setpoint_temperature_logstring = "\n" + '.................................' + _(
'setpoint temperature') + ": " + str(
period_dictionary['setpoint_temperature']) + " C"
switch_on_cooling_compressor_logstring = "\n" + '.................................' + _(
'switch-on value temperature') + ": " + str(
switch_on_cooling_compressor) + " C"
switch_off_cooling_compressor_logstring = "\n" + '.................................' + _(
'switch-off value temperature') + ": " + str(
switch_off_cooling_compressor) + " C"
setpoint_humidity_logstring = "\n" + '.................................' + _(
'setpoint humidity') + ": " + str(
period_dictionary['setpoint_humidity']) + "%"
switch_on_humidifier_logstring = "\n" + '.................................' + _(
'switch-on value humidity') + ": " + str(switch_on_humidifier) + "%"
switch_off_humidifier_logstring = "\n" + '.................................' + _(
'switch-off value humidity') + ": " + str(switch_off_humidifier) + "%"
delay_humidify_logstring = "\n" + '.................................' + _(
'humidification delay') + ": " + str(delay_humidify) + ' ' + _(
"minutes")
circulation_air_period_format = int(
period_dictionary['circulation_air_period']) / 60
circulation_air_period_logstring = "\n" + '.................................' + _(
'timer circulation air period every') + ": " + str(
circulation_air_period_format) + ' ' + _("minutes")
circulation_air_duration_format = int(
period_dictionary['circulation_air_duration']) / 60
circulation_air_duration_logstring = "\n" + '.................................' + _(
'timer circulation air') + ": " + str(
circulation_air_duration_format) + ' ' + _("minutes")
exhaust_air_period_format = int(
period_dictionary['exhaust_air_period']) / 60
exhaust_air_period_logstring = "\n" + '.................................' + _(
'timer exhaust air period every') + ": " + str(
exhaust_air_period_format) + ' ' + _("minutes")
exhaust_air_duration_format = int(
period_dictionary['exhaust_air_duration']) / 60
exhaust_air_duration_logstring = "\n" + '.................................' + _(
'timer exhausting air') + ": " + str(
exhaust_air_duration_format) + ' ' + _("minutes")
period_days_logstring = "\n" + '.................................' + _(
'duration') + ": " + str(period_dictionary['days']) + ' ' + _('days')
sensor_logstring = '.................................' + _(
'sensortype') + ": " + cl_fact_main_sensor_type().get_instance(
)._get_type_ui()
pi_ager_database.write_settings(
modus, period_dictionary['setpoint_temperature'],
period_dictionary['setpoint_humidity'],
period_dictionary['circulation_air_period'],
period_dictionary['circulation_air_duration'],
period_dictionary['exhaust_air_period'],
period_dictionary['exhaust_air_duration'])
period_starttime_seconds = pi_ager_database.get_current_time()
pi_ager_database.write_current_value(
pi_ager_names.agingtable_period_starttime_key,
period_starttime_seconds)
period_endtime = datetime.datetime.now() + datetime.timedelta(
days=period_dictionary['days']
) # days = parameter von datetime.timedelta
logstring = _(
'values'
) + ': ' + operating_mode + setpoint_temperature_logstring + switch_on_cooling_compressor_logstring + switch_off_cooling_compressor_logstring + "\n" + setpoint_humidity_logstring + switch_on_humidifier_logstring + switch_off_humidifier_logstring + delay_humidify_logstring + "\n" + circulation_air_period_logstring + circulation_air_duration_logstring + "\n" + exhaust_air_period_logstring + exhaust_air_duration_logstring + "\n" + period_days_logstring + "\n" + sensor_logstring + "\n"
cl_fact_logger.get_instance().info(logstring)
from main.pi_ager_cl_logger import cl_fact_logger
import agingtable_loop
import pi_ager_database
import pi_ager_names
#global logger
# logger = pi_ager_logging.create_logger('agingtable')
# logger.debug('logging initialised')
cl_fact_logger.get_instance().debug(
('logging initialised __________________________'))
try:
agingtable_loop.doAgingtableLoop()
except KeyboardInterrupt:
pi_ager_database.write_current_value(pi_ager_names.agingtable_period_key,
0)
#logger.warning(_('KeyboardInterrupt'))
cl_fact_logger.get_instance().warning(_('KeyboardInterrupt'))
pass
except Exception as e:
logstring = _('exception occurred') + '!!!'
#logger.exception(logstring, exc_info = True)
cl_fact_logger.get_instance().exception(logstring, exc_info=True)
pass
finally:
pi_ager_database.write_stop_in_database(
pi_ager_names.status_agingtable_key)
try:
cl_fact_logger.get_instance().debug('logging initialised __________________________')
# logger.info("Start scale loop")
cl_fact_logger.get_instance().info("Start scale loop")
scale_loop.doScaleLoop()
except KeyboardInterrupt:
logger.warning('KeyboardInterrupt')
pass
except Exception as cx_error:
#Create factory for messanger, get from factory the instance of the messenger, send messages in one line
#exception_known = cl_fact_logic_messenger().get_instance().send(cx_error, "Error in doScaleLoop()")
cl_fact_logic_messenger().get_instance().handle_exception(cx_error)
pi_ager_database.write_current_value(pi_ager_names.calibrate_scale1_key,0)
pi_ager_database.write_current_value(pi_ager_names.calibrate_scale2_key,0)
pi_ager_database.write_current_value(pi_ager_names.calibrate_weight_key,0)
pi_ager_database.write_current_value(pi_ager_names.status_tara_scale1_key,0)
pi_ager_database.write_current_value(pi_ager_names.status_tara_scale2_key,0)
finally:
if exception_known == False:
pi_ager_init.loopcounter = 0
pi_ager_database.write_stop_in_database(pi_ager_names.status_pi_ager_key)
os.system('sudo /var/sudowebscript.sh pkillscale &')
os.system('sudo /var/sudowebscript.sh pkillmain &')
pi_ager_organization.goodbye()