def create_mics(self):
logging.basicConfig(filename='app.log',
filemode='a',
format='%(levelname)s - %(message)s')
logger = logging.getLogger()
logger.setLevel(logging.INFO)
if self.setup_dict['multistate_variables'] == 2:
for row in range(len(self.mic_list)):
try:
sql_statement = f"INSERT INTO OBJECT_V4_MIC (DEV_ID, Object_Name, Object_Identifier, SITE_ID)" \
f"VALUES ({self.setup_dict['device_id']}, {self.mic_list[row]}, " \
f"'{self.setup_dict['site_id']}')"
make_connection(sql_statement)
logger.info(
f"Created Successfully\n\t{self.setup_dict['device_id']}, MIC{self.mic_list[row]}\n"
)
except:
logger.info(
f"!!!!!Failed to create MIC{self.mic_list[row]}!!!!!")
for row in range(len(self.mic_state_text_list)):
idx = self.mic_state_text_list[row][1]
state_text = self.mic_state_text_list[row][2]
mic_instance = self.mic_state_text_list[row][3]
try:
sql_statement = f"Insert Into ARRAY_V4_MIC_STATE_TEXT (DEV_ID, IDX, State_Text, INSTANCE, SITE_ID)" \
f"Values({self.setup_dict['device_id']}, {idx}, '{state_text}',{mic_instance}, " \
f"'{self.setup_dict['site_id']}')"
make_connection(sql_statement)
except:
pass
def create_multistate_variables(self):
logging.basicConfig(filename='app.log',
filemode='a',
format='%(levelname)s - %(message)s')
logger = logging.getLogger()
logger.setLevel(logging.INFO)
if self.setup_dict['multistate_variables'] == 2:
for row in range(len(self.multistate_variables_list)):
try:
sql_statement = f"INSERT INTO OBJECT_V4_MV (DEV_ID, INSTANCE,Object_Name, Type_Reference, SITE_ID) " \
f"VALUES ({self.setup_dict['device_id']},{self.multistate_variables_list[row]}," \
f"'{self.setup_dict['site_id']}') "
make_connection(sql_statement)
logger.info(
f"Created Successfully\n\t"
f"{self.setup_dict['device_id']}, MV{self.multistate_variables_list[row]}\n"
)
except:
logger.info(
f"!!!!!Failed to create MV{self.multistate_variables_list[row]}!!!!!"
)
else:
logger.info(
f"Multistate Variables were not selected for creation.")
def create_points(self):
file_path = self.information_dictionary['file_path']
time = datetime.now().strftime("%B %d, %Y - %H:%M:%S")
logging.basicConfig(filename='app.log',
filemode='a',
format='%(levelname)s - %(message)s')
logger = logging.getLogger()
logger.setLevel(logging.INFO)
logger.info(
f"***************Points creation started for site {self.information_dictionary['site_id']}. "
f"{time}***************")
# Create points
points_list = readCSV.read_csv_file(file_path,
self.information_dictionary)
sql_list = []
# Loop thru points list and execute sql statements
for row in range(len(points_list)):
try:
point = readCSV.determine_point_type(points_list[row][1])
sql_list = points_list[row]
if sql_list[0] != '' and (point == "AO" or point == "AI"
or point == "BO" or point == "BI"):
sql = f"INSERT INTO OBJECT_V4_{point} (DEV_ID, Object_Identifier, Object_Name, Type_Reference, " \
f"SITE_ID) VALUES ({self.information_dictionary['device_id']},'{sql_list[1]}','{sql_list[2]}'" \
f",'{sql_list[3]}', '{self.information_dictionary['site_id']}') "
make_connection(sql)
logger.info(
f"\tDevice: {self.information_dictionary['device_id']}"
f"\n\tPoint Instance: {sql_list[1]}"
f"\n\tPoint Name: {sql_list[2]}"
f"\n\tType Reference: {sql_list[3]}"
f"\n\tSite: {self.information_dictionary['site_id']}"
f"\n******************************")
else:
sql_list.pop()
sql = f"INSERT INTO OBJECT_V4_{point} (DEV_ID, Object_Identifier, Object_Name, SITE_ID) " \
f"VALUES ({sql_list[0]},'{sql_list[1]}','{sql_list[2]}', " \
f"'{self.information_dictionary['site_id']}') "
make_connection(sql)
logger.info(sql_list)
except:
logger.info(
f'\n\t!!!!!Failed to create {sql_list[1]} ,{sql_list[2]}!!!!!'
)