def insert_in_alert_definition_notification_time(
notification_id, alert_definition_id, notification_datetime: datetime):
query = insert_query_construction(
compo=ALERT_DEFINITION_NOTIFICATION_TIME_COMPO,
name=ALERT_DEFINITION_NOTIFICATION_TIME)
params = [notification_id, alert_definition_id, notification_datetime]
return my_sql.execute_and_close(query=query, params=params, return_id=True)
def insert_random_data_in_BI_COMPTAGE_DONNEE_table():
insert_base = insert_query_construction(compo=COMPTAGE_COMPO,
name=HandleDataFromDB.table_name)
def get_comptage(comptage):
if comptage > 100:
return comptage - comptage / 10
elif comptage > 20:
return comptage + comptage - comptage / 2
else:
return 20 + comptage % 3
def __generate_values():
start_day = datetime.today() - timedelta(days=10)
meters_id = [1, 2, 3]
values = list()
comptage = 20
while len(values) < 10:
comptage = get_comptage(comptage)
start_day += timedelta(days=1)
values.append((comptage, random.choice(meters_id), start_day))
return values
values = __generate_values()
for value in values:
my_sql.execute_and_close(query=insert_base, params=value)
def insert_in_alert_definition(name, category, description, level, status,
notification_id, calculator_id):
query = insert_query_construction(compo=DEFINITION_COMPO,
name=DEFINITION_TABLE_NAME)
params = [
name, category, description, level, status, notification_id,
calculator_id
]
return my_sql.execute_and_close(query=query, params=params, return_id=True)
def insert_in_calculator(operator, comparator, data_period_type,
data_period_quantity, data_period_unit, value_type,
value_number, value_period_type, hour_start, hour_end,
acceptable_diff):
query = insert_query_construction(compo=CALCULATOR_COMPO,
name=CALCULATOR_NAME)
params = [
operator, comparator, data_period_type, data_period_quantity,
data_period_unit, value_type, value_number, value_period_type,
hour_start, hour_end, acceptable_diff
]
return my_sql.execute_and_close(query=query, params=params, return_id=True)
def insert_in_notification(period_unit: str, period_quantity: int, email: str,
days_flags: int, hours_flags: int):
query = insert_query_construction(compo=NOTIFICATION_COMPO,
name=NOTIFICATION_NAME)
params = [
period_unit,
period_quantity,
email,
days_flags,
hours_flags,
]
return my_sql.execute_and_close(query=query, params=params, return_id=True)
def add_notification_in_db(self, time: datetime):
query = utils.insert_query_construction(
name=ALERT_DEFINITION_NOTIFICATION_TIME,
compo=ALERT_DEFINITION_NOTIFICATION_TIME_COMPO)
params = [self.notification.id, self.id, time]
print("query", query)
print("params", params)
cursor = my_sql.generate_cursor()
cursor.execute(operation=query, params=params)
my_sql.commit()
def insert_data_to_test_in_BI_COMPTAGE_DONNEE_table():
insert_base = insert_query_construction(compo=COMPTAGE_COMPO,
name=HandleDataFromDB.table_name)
meter_id = 4
values = list()
comptage_list = [3, 2, 5, 1, 4]
start_day = datetime.today() - timedelta(days=1)
for comtage in comptage_list:
start_day += timedelta(hours=1)
values.append((comtage, meter_id, start_day))
for value in values:
my_sql.execute_and_close(query=insert_base, params=value)
def insert_in_bi_compteurs_data():
select_base = insert_query_construction(compo=METER_TABLE_COMPO,
name=METER_TABLE_NAME)
print(select_base)
def __generate_values():
values = list()
my_bool = [0, 1]
i = 1
while len(values) < 10:
values.append(("name_{}".format(i), random.choice(my_bool)))
i += 1
return values
values = __generate_values()
for value in values:
print(value)
insert_in_bi_compteurs(name=value[0], is_index=value[1])
def insert_in_bi_comptage_donnees(donnee_comptage_value, meter_id, time):
query = insert_query_construction(compo=COMPTAGE_COMPO,
name=HandleDataFromDB.table_name)
params = [donnee_comptage_value, meter_id, time]
my_sql.execute_and_close(query=query, params=params)
def insert_in_alert_manager(launch_datetime: datetime):
query = insert_query_construction(compo=ALERT_MANAGER_TABLE_COMPO,
name=ALERT_MANAGER_TABLE_NAME)
params = [launch_datetime]
return my_sql.execute_and_close(query=query, params=params, return_id=True)
def insert_in_bi_objectifs(objectif_value: float, time_unit: str, meter_id):
query = insert_query_construction(compo=OBJECTIF_TABLE_COMPO,
name=OBJECTIF_TABLE_NAME)
params = [objectif_value, time_unit, meter_id]
return my_sql.execute_and_close(query=query, params=params, return_id=True)
def insert_in_bi_compteurs(name, is_index: bool):
query = insert_query_construction(compo=METER_TABLE_COMPO,
name=METER_TABLE_NAME)
params = [name, is_index]
print("params", params)
return my_sql.execute_and_close(query=query, params=params, return_id=True)