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()
