How to create a Python Script for Sign Up/Log In System with a prompt of 'user already exist' ?

Question

Python Script for Log In and Sign Up

Answer 1

Hi, Appreciate your response, but my strategy on creating such is by doing it using if else condition.

I have the data stored on SQL. The Else Condition will show a prompt that 'User Already Exist'

The If Condition will proceed if the If Condition is satisfied.

Feel free to suggest any strategy I can use.

Answer 2

#this for a mock up sign up/log in single button

data1 == database
data2 == database

if data1 != database:
x = input()
print("data is not yet encoded")
else:
print("user exist!")
if data2 != database:
y = input()
print("data is not yet encoded")
else:
print("user exist!")

# x and y here are Text Boxes needed to be filled up, Try Ignition 8.0 to test this with your created Database on MySql 2019

Answer 3

(This may be a inefficient solution tho) You can store all usernames (or something like that, use user id system thingy if usernames can be same) on a list, and code the logic for checking if the username already exists on the sign up section (and change username section, if you have one)

Though you can use sets but i entirely forgot how to program in python after months of not coding, also im not familiar with SQL

Answer 4

Thanks for the advise, for now, Im configuring the data to be stored in My SQL Management Studios 2019. These data will be pulled via Python Code at Ignition 8.0 ..

found these scripts

system.db