def update_expired_place(place: Place):
args = (place.name, place.latitude, place.longitude, place.address,
place.created)
update_qry = """
UPDATE cache
SET name = ?, latitude = ?, longitude = ?, address = ?, cached_stamp = ?
WHERE place_id = ? """
db.execute_query(update_qry, args)
def build_cache(location: tuple, radius: int):
place_list = get_places(location, radius)
for p in place_list:
new_qry = "INSERT INTO cache (name, place_id, latitude, longitude, address) VALUES (?, ?, ?, ?, ?)"
db.execute_query(new_qry, p.get_database_args())
new_type_qry = "INSERT INTO cached_type (place_id, type_id) VALUES (?, ?)"
for t in p.types:
if t in type_strings:
t_id = type_strings.index(t) + 1
db.execute_query(new_type_qry, (p.place_id, t_id))
def create(form_user):
email = form_user["email"]
if is_unique(email):
first = form_user["first"]
last = form_user["last"]
hashed = secrets.hashpw(form_user["password"])
nonce = secrets.generate_nonce()
nonce_time = time.time()
create_qry = "INSERT INTO users (email, first_name, last_name, hash, nonce, nonce_timestamp) " \
"VALUES ( ?, ?, ?, ?, ?, ? )"
db.execute_query(create_qry,
(email, first, last, hashed, nonce, nonce_time))
user = get_user(email)
start_session(user)
return {"error": False, "message": "account created"}
else:
return {"error": True, "message": "email is taken"}
def update_password(email, password):
""" updates the password hash in the db for a given username """
hashed = secrets.hashpw(password)
update_qry = "UPDATE users SET hash = ? WHERE email = ?"
print(hashed)
db.execute_query(update_qry, (hashed, email))
def add_favorite(user_id, place_id):
add_fave_qry = "INSERT INTO favorites (user_id, place_id) VALUES (?, ?)"
db.execute_query(add_fave_qry, (user_id, place_id))