def get_user_by_name(nome_completo): return Users().select_like("nome_completo", nome_completo)
def addUser(): userObj = request.get_json() newUser = Users(email=userObj["email"], id=userObj["id"]) db.session.add(newUser) db.session.commit() return "User added"
def get_user(key_value): return Users().select(key_value)[0]
def get_user_all(): return Users().select_all()
def delete_user(key_value): Users().delete(key_value)
def update_user(key_value, nome_completo, CPF): Users().update(key_value, [nome_completo, CPF])
def insert_user(nome_completo, CPF): return Users().insert([nome_completo, CPF])
db.drop_all() db.create_all() thread = Threads('Is there liquid water on Mars?') db.session.add(thread) thread = Threads('Why so many programming languages out there?') db.session.add(thread) thread = Threads('All about ketogenic diet') db.session.add(thread) thread = Threads("Don't go to scholl, watch YouTube") db.session.add(thread) user = Users("martian1999", "*****@*****.**", hashlib.sha1("martian".encode('utf-8')).hexdigest()) db.session.add(user) user = Users("doubledunder", "*****@*****.**", hashlib.sha1("2dunder".encode('utf-8')).hexdigest()) db.session.add(user) user = Users("urdans", "*****@*****.**", hashlib.sha1("urdis".encode('utf-8')).hexdigest()) db.session.add(user) user = Users("theKnight", "*****@*****.**", hashlib.sha1("knight".encode('utf-8')).hexdigest()) db.session.add(user) post = Posts(
db.session.commit() item_demo3 = Merchandise("Cake", "Desert", 30, 5, 1, "static/assets/test3.jpg") db.session.add(item_demo3) db.session.commit() item_demo4 = Merchandise("Haagen-Dazs", "Desert", 100, 8, 0.8, "static/assets/test4.jpg") db.session.add(item_demo4) db.session.commit() # table users(8): # userID(p-key), username, password, first_name, last_name, # email, address1, address2, balance # insert 3 demo-users user_demo1 = Users("liqi", "1234", "Li", "Qi", "*****@*****.**", "apt262", "Birmingham", 1000) db.session.add(user_demo1) db.session.commit() user_demo2 = Users("wenda", "1234", "Wenda", "Zhao", "*****@*****.**", "apt123", "Birmingham", 1000) db.session.add(user_demo2) db.session.commit() user_demo3 = Users("daniel", "1234", "Daniel", "Chiang", "*****@*****.**", "apt231", "Birmingham", 1000) db.session.add(user_demo3) db.session.commit()