def register():
if request.method == 'POST' and 'first_name' in request.form and 'last_name' in request.form and 'email' in request.form and 'phone_no' in request.form and 'password' in request.form and 'street' in request.form and 'street_no' in request.form and 'zipcode' in request.form and 'city' in request.form:
first_name = request.form['first_name']
last_name = request.form['last_name']
email = request.form['email']
phone_no = request.form['phone_no']
password = request.form['password']
street = request.form['street']
street_no = request.form['street_no']
zipcode = request.form['zipcode']
city = request.form['city']
# country_code =
# geo_lat =
# geo_long =
con = api.connect_to_DB()
cursor = con.cursor()
query1 = f"INSERT INTO users (first_name, last_name, email, phone_number, password, street, street_nr, zip, city, country_code, geo_lat, geo_long) VALUES ('{first_name}', '{last_name}', '{email}', '{phone_no}', '{password}', '{street}', '{street_no}', {zipcode}, '{city}', 'DE', 4, 5)"
cursor.execute(query1)
con.commit()
con.close()
return render_template('you_are_registered.html')
else:
return render_template('register.html')
def login():
msg=""
if request.method == "POST" and "email" in request.form and "password" in request.form:
username = request.form["email"]
password = request.form["password"]
con = api.connect_to_DB()
cursor = con.cursor()
try:
cursor.execute(f"SELECT * FROM users WHERE email = '{username}' AND password = '******'")
except mariadb.Error as e:
print(f"Error: {e}")
account = cursor.fetchone()
if account:
session["loggedin"] = True
session['id'] = account[0]
session['username'] = account[3]
msg = 'Logged in successfully !'
print(session["id"])
return redirect(url_for('/dashapp/'))
else:
msg = 'Incorrect username / password !'
return render_template('index.html', msg = msg)
return render_template('index.html', msg = msg)
def clean_Data():
con = api.connect_to_DB()
df = pd.read_sql_query("SELECT * from Test_Data", con)
con.close()
df["id"] = pd.to_datetime(df["timestamp"])
df = df.set_index(["id"])
df.sort_index(inplace=True, ascending=True)
return df
def register():
def check_register(attribut, msg_list, form_correct):
return_value = ""
if attribut in request.method:
return_value = request.form['attribut']
else:
msg_list.append("please insert a " + attribut)
form_correct.status = False
return return_value
class Checker:
def __init__(self):
status = True
form_correct = Checker()
msg_list = []
if request.method == 'POST':
first_name = check_register('first_name', msg_list, form_correct)
last_name = check_register('last_name', msg_list, form_correct)
email = check_register('email', msg_list, form_correct)
phone_no = check_register('phone_no', msg_list, form_correct)
password = check_register('password', msg_list, form_correct)
street = check_register('street', msg_list, form_correct)
street_no = check_register('street_no', msg_list, form_correct)
zipcode = check_register('zipcode', msg_list, form_correct)
city = check_register('city', msg_list, form_correct)
con = api.connect_to_DB()
cursor = con.cursor()
if not form_correct.status:
return render_template('register.html', msg_list=msg_list)
else:
query1 = f"INSERT INTO Test_User (first_name, last_name, email, phone_no, password, street, street_no, zipcode, city) VALUES ('{first_name}', '{last_name}', '{email}', '{phone_no}', '{password}', '{street}', '{street_no}', {zipcode}, '{city}')"
cursor.execute(query1)
con.commit()
con.close()
return render_template('you_are_registered.html')
else:
return render_template('register.html')
def register():
if request.method == 'POST':
first_name = request.form['first_name']
last_name = request.form['last_name']
email = request.form['email']
phone_no = request.form['phone_no']
password = request.form['password']
street = request.form['street']
street_no = request.form['street_no']
zipcode = request.form['zipcode']
city = request.form['city']
con = api.connect_to_DB()
cursor = con.cursor()
query1 = f"INSERT INTO Test_User (first_name, last_name, email, phone_no, password, street, street_no, zipcode, city) VALUES ('{first_name}', '{last_name}', '{email}', '{phone_no}', '{password}', '{street}', '{street_no}', {zipcode}, '{city}')"
cursor.execute(query1)
con.commit()
con.close()
return redirect("/")
return render_template('register.html')