def update_entry(entry: Entry) -> bool: """ Update an entry in the database with new values, return whether update was success """ if not entry_exists_by_obj(entry): print(f"Entry in {entry.table} with id {entry.id} does not exist") return False col_list, val_list = entry.get_attr_rep_lists() set_str = ",".join( [f"{col} = {val}" for col, val in zip(col_list, val_list)]) query = f"UPDATE {entry.table} SET {set_str} WHERE id = '{entry.id}'" conn.execute(query) conn.commit() return True