def __adjust_log_df_to_selected_items__(self):
if self._process_column != '' and self._selected_log_process != '':
self._log_df = self._log_df[self._log_df[self._process_column] == self._selected_log_process]
if self._process_step_column != '' and self._selected_log_process_step != '':
self._log_df = self._log_df[self._log_df[self._process_step_column] == self._selected_log_process_step]
if self._log_df.shape[0] > 0:
if self._selected_date_range != DTRG.ALL:
date_obj = MyDate.get_offset_date_for_date_range(self._selected_date_range)
offset_ts = MyDate.get_offset_time_stamp_for_date_range(self._selected_date_range)
if self._date_column == DC.WAVE_END_TS:
self._log_df = self._log_df[self._log_df[self._date_column] >= offset_ts]
elif self._date_column == DC.TS_PATTERN_TICK_LAST:
self._log_df = self._log_df[self._log_df[self._date_column] >= offset_ts]
else:
self._log_df = self._log_df[self._log_df[self._date_column] >= str(date_obj)]
def __get_where_clause_from_selected_date_range__(self):
if self._selected_date_range == '':
return ''
column_date = self._db_table.column_date
column_time_stamp = self._db_table.column_time_stamp
if column_date != '':
date_obj = MyDate.get_offset_date_for_date_range(
self._selected_date_range)
if date_obj is not None:
return "{} >= '{}'".format(column_date, str(date_obj))
elif column_time_stamp != '':
offset_time_stamp = MyDate.get_offset_time_stamp_for_date_range(
self._selected_date_range)
if offset_time_stamp > 0:
return "{} >= {}".format(column_time_stamp,
str(offset_time_stamp))
return ''
