def menu_options(option):
if option == 1:
db_functions.connect()
db_functions.list_users()
menu()
elif option == 2:
db_functions.connect()
db_functions.add_user()
menu()
elif option == 3:
db_functions.connect()
db_functions.edit_user()
menu()
elif option == 4:
db_functions.connect()
db_functions.delete_user()
menu()
elif option == 5:
sys.exit('Bye.')
else:
print(str(option) + " is not a valid option. Please try again.")
menu()
def insert_user(user_dict: dict):
""" def add_user(user_id, user_first_name, user_last_name, phone_number, user_name): """
""" ride: {'date': '2019-11-12', 'time': '8:30', 'source': 'Jerusalem', 'destination': 'haifa', 'place': '3'}"""
"""user: {'id': 586475104, 'first_name': 'Mickaël', 'last_name': 'Balensi', 'username': None}"""
user_id, user_first_name, user_last_name, user_name, phone_number = user_dict.values(
) #=>>> ici yaura un pb car jai pas encore le num de telephone
add_user(user_id, user_first_name, user_last_name, phone_number, user_name)
def add_new_user():
form = RegistrationForm()
if form.validate_on_submit():
already_registered = db_functions.find_user(form.email.data)
if already_registered:
flash('Už jsi u nás byl/a, tak se prosím přihlaš.', "danger")
return redirect(url_for('login_bp.login'))
if not form.password.data == form.confirm_password.data:
flash('Hesla se neshodují.', "danger")
return render_template("registration.html", form=form)
id_user = db_functions.add_user(form.username.data, form.surname.data,
form.street.data, form.city.data,
form.postcode.data, form.email.data,
form.phone.data, form.password.data,
form.confirm_password.data)
if id_user:
flash('Vítáme Tě! Teď se prosím přihlaš.', "success")
return redirect(url_for('login_bp.login'))
else:
flash(
'Mrzí nás to, ale registrace se nepovedla. Dej nám pár minut a zkus to znovu.',
"danger")
return render_template("registration.html", form=form)
else:
return render_template("registration.html", form=form)
def signup():
print("in signup")
username = request.form['username']
password = request.form['password']
email = request.form['email']
age = request.form['age']
print("Calling sign up before db")
## user info packet like: ( 'Ishaan', N'Australia', '*****@*****.**', 'Male','20','Hockey, swim, code, gym, food')
info_packet = "'" + username + "'" + "," + "'" + password + "'" + "," + "'Atlanta'" + "," + "'" + email + "'" + "," + "'None'" + "," + "'" + age + "'" + "," + "'default'"
print("Calling sign up", info_packet)
db.add_user(info_packet)
session['username'] = username
return render_template("interests.html")
import st_functions as st
##
## EXAMPLE: test db_functions.py
##
db.mysql_connect()
mv.CONN = db.CONN
st.CONN = db.CONN
db.load_books_from_file(db.BOOKS_BACKUP)
db.load_users_from_file(db.USERS_BACKUP)
db.insert_individual_book("12501","Harry Potter and the Philosopher's stone", "JK Rowling", "UK", "1997", "978-0747532743")
db.insert_individual_book("12502","Harry Potter and the Philosopher's stone", "JK Rowling", "UK", "1997", "978-0747532743")
db.insert_individual_book("12503","Harry Potter and the Philosopher's stone", "JK Rowling", "UK", "1997", "978-0747532743")
db.save_books_to_file(db.BOOKS_BACKUP)
db.print_book_list()
print(db.find_book_by_name("The lord of the rings"))
print(db.find_book_by_name("Harry potter"))
print(db.find_book_by_name("Pride and prejudice"))
db.save_users_to_file(db.USERS_BACKUP)
db.add_user("38819218","Francisco Kovacevich")
db.add_user("11316222","María Inés García")
db.remove_user("38819218")
def addUser(phoneNumber, name):
with mdb.connect('localhost', 'root', 'toor', 'userdb') as cur:
add_user(phoneNumber, name, cur)
set_user_state(phoneNumber, ADDING_USER, cur)