Differences

This shows you the differences between two versions of the page.

--- python:python-data-struct [23/01/2024 10:46] – created - external edit 127.0.0.1
+++ python:python-data-struct [05/11/2025 11:55] (current) – [Boolean True of False] andrew
@@ Line 169: / Line 169: @@
-        # Add user to user_model table, sql code to add new row OR update existing one:-
-        # https://stackoverflow.com/questions/15383852/sql-if-exists-update-else-insert-into
-        user_model_sql = f'''
-        insert into user_model(highside_user_id, login_status)
-        values ('{hsusername}', true)
-        on duplicate key
-        update highside_user_id = values(highside_user_id), login_status = values(login_status);
-        '''
-mysql_query = f"SELECT IF(login_status, 'true', 'false') from user_model WHERE highside_user_id = '{sessionname}'; "