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)