async def resolve_get_data(self, info, id):
app_users = crud.get_users()
for user in app_users:
print(user)
if user['id'] == id:
return user
return None
def create_checklist():
"""Create new checklist."""
template_id = request.form.get('template_id')
who_for = request.form.get('who_for')
time_frame = request.form.get('time_frame')
preparer_id = request.form.get('preparer_id')
reviewer_id = request.form.get('reviewer_id')
crud.create_checklist(template_id, who_for, time_frame, preparer_id,
reviewer_id)
flash('Checklist created!')
checklists = crud.get_checklists()
users = crud.get_users()
return render_template('/all_checklists.html',
checklists=checklists,
users=users)
def create_question():
"""Create new question."""
template_id = request.form.get('template_id')
question = request.form.get('question')
yes_text = request.form.get('yes_text')
no_text = request.form.get('no_text')
not_applicable_text = request.form.get('not_applicable_text')
category = request.form.get('category')
primary_driver = request.form.get('primary_driver')
resource_url = request.form.get('resource_url')
help_text = request.form.get('help_text')
crud.create_question(template_id, question, yes_text, no_text,
not_applicable_text, category, primary_driver,
resource_url, help_text)
flash('Question added!')
questions = crud.get_questions()
templates = crud.get_templates()
users = crud.get_users()
return render_template('/all_templates.html',
templates=templates,
questions=questions,
users=users)
def all_users():
"""View all users."""
users = crud.get_users()
return render_template(
'all_users.html',
jinja_users=users) # we changed movies_jinja from movies (in solution)
def read_users(skip: int = 0, limit: int = 100, db: Session = Depends(get_db)):
"""
Read Users.\n
Optional query parameters:
- **skip**: how many records to skip
- **limit**: how many records to read
"""
return crud.get_users(db, skip=skip, limit=limit)
def all_templates():
"""View all templates."""
templates = crud.get_templates()
users = crud.get_users()
return render_template('all_templates.html',
templates=templates,
users=users)
def read_users(limit: int = 100, db: Session = Depends(get_db)):
"""
returns:
all the users in the application
"""
users = crud.get_users(db)
return users
def show_template(template_id):
#Show details on a particular template.
template = crud.get_template_by_id(template_id)
users = crud.get_users()
# isnotcreator=template.created_by!=session.get("user_id")
return render_template('template_details.html',
template=template,
users=users)
def all_checklists():
"""View all checklists."""
checklists = crud.get_checklists()
users = crud.get_users()
return render_template('all_checklists.html',
checklists=checklists,
users=users)
def rating():
all_users = crud.get_users()
all_entries = crud.get_entries()
for n in range(3):
liker = choice(all_users)
entry = choice(all_entries)
crud.create_rating(liker, entry)
model.db.session.commit()
def entry():
all_users = crud.get_users()
all_cities = crud.get_cities()
for n in range(3):
user = choice(all_users)
blog = "entry to be updated"
title = "title to be updated"
city = choice(all_cities)
entry = crud.create_entry(user, blog, city, title)
model.db.session.commit()
def create_template():
"""Create new template."""
template_name = request.form.get('template_name')
created_by = request.form.get('created_by')
created_on = request.form.get('created_on')
crud.create_template(template_name, created_by, created_on)
flash('Template created!')
templates = crud.get_templates()
users = crud.get_users()
return render_template('/all_templates.html',
templates=templates,
users=users)
def photo():
all_users = crud.get_users()
all_entries = crud.get_entries()
all_cities = crud.get_cities()
for n in range(3):
user = choice(all_users)
entry = choice(all_entries)
photo_url = "https://picsum.photos/500/350?nocache"
city = choice(all_cities)
photo = crud.create_photo(user, entry, photo_url, city)
model.db.session.commit()
def profile():
all_users = crud.get_users()
all_cities = crud.get_cities()
for n in range(3):
user = choice(all_users)
profile_photo = "https://picsum.photos/500/350?nocache"
description = "to be updated"
instagram = "to be updated"
twitter = "to be updated"
website = "to be updated"
photo = crud.create_profile(user, profile_photo, description, instagram, twitter, website)
model.db.session.commit()
def get_similar_user():
"""Returns the users that are most similar to the session user."""
# gets session user's info
user_id = session['user']
user = crud.get_user_by_id(user_id)
# get stdev data for user
session_user_attributes = crud.get_song_attributes(user_id)
session_user_stdev = crud.get_stdev(session_user_attributes)
print(session_user_stdev)
# get all users
all_users = crud.get_users()
#stores min difference
min_diff = [1000, '']
# iterate through all users that are not the session user that have recs.
for user_x in all_users:
if user_x.user_id != user.user_id and crud.user_has_song_recs(user_x.user_id):
user_diff = (abs(user.user_valence - user_x.user_valence)/session_user_stdev['valence'])
+ (abs(user.user_speechiness - user_x.user_speechiness)/session_user_stdev['speechiness'])
+ (abs(user.user_acousticness - user_x.user_acousticness)/session_user_stdev['acousticness'])
+ (abs(user.user_energy - user_x.user_energy)/session_user_stdev['energy'])
+ (abs(user.user_danceability - user_x.user_danceability)/session_user_stdev['danceability'])
+ (abs(user.user_loudness - user_x.user_loudness)/session_user_stdev['loudness'])
# if the difference is smaller, update the array with the difference and ID
if user_diff < min_diff[0]:
min_diff = [user_diff, user_x.email]
else:
pass
similar_user_email = min_diff[1]
similar_user = crud.get_user_by_email(similar_user_email)
# adjust loudness for graph
adj_user_loudness = abs(user.user_loudness)/10
adj_similar_user_loudness = abs(similar_user.user_loudness)/10
return jsonify({'similar_user': similar_user_email,
'current_user_info': [user.user_valence, user.user_speechiness,
user.user_acousticness, user.user_energy, user.user_danceability, adj_user_loudness],
'similar_user_info': [similar_user.user_valence, similar_user.user_speechiness,
similar_user.user_acousticness, similar_user.user_energy,
similar_user.user_danceability, adj_similar_user_loudness]}
)
def get_users(): """View all users.""" user_id = session['user'] current_user = crud.get_user_by_id(user_id) # gets all users and jsonifies it users = crud.get_users() users_dict = [] for user in users: #doesn't show current user if user != current_user: x = User.as_dict(user) users_dict.append(x) #users = crud.get_users() return jsonify(users_dict)
def register_recipient():
"""Create a new recipient user."""
user_full_name = request.form.get('user_full_name')
email = request.form.get('email')
password = request.form.get('password')
crud.create_recipient(user_full_name, email, password)
flash('Account created!')
checklists = crud.get_checklists()
users = crud.get_users()
return render_template('all_checklists.html',
users=users,
checklists=checklists)
def all_users():
"""View all users."""
users = crud.get_users()
return render_template('all_users.html', users=users)
def list_users():
"""Return page showing all users"""
users = crud.get_users()
return render_template("all_users.html", users=users)
def get_all_users(skip: int = 0, limit: int = 100, db: Session = Depends(get_db)):
return crud.get_users(db, skip=skip, limit=limit)
def all_users():
users = crud.get_users()
return render_template('all_users.html', users=users)
def read_users(skip: int = 0, limit: int = 100, db: Session = Depends(get_db)):
users = crud.get_users(db, skip=skip, limit=limit)
return users
def get_users(db: Session = Depends(get_db)):
users = crud.get_users(db)
return users
def show_users():
users = crud.get_users()
return render_template('users.html', users=users)
def read_users(db: Session = Depends(get_db)) -> Any:
# return crud.get_users(db)
return paginate(crud.get_users(db))
def get_users(db: Session = Depends(get_db)):
return crud.get_users(db=db)
def show_all_users():
"""get user profile"""
users = crud.get_users()
return render_template("all_users.html", users=users)
def users():
"""Show all users"""
users = crud.get_users()
return render_template('users.html', users=users)
def all_checklistsstats():
"""View all checklists stats."""
checklists = crud.get_checklists()
answer = crud.get_answers()
users = crud.get_users()
questions = crud.get_questions()
# Chart stats check - initial
started_count = Checklist.query.filter(
Checklist.date_complete.is_(None),
Checklist.date_review_completed.is_(None),
Checklist.date_sent_to_review.is_(None)).count()
in_review_count = Checklist.query.filter(
Checklist.date_complete.is_(None),
Checklist.date_review_completed.is_(None),
Checklist.date_sent_to_review.isnot(None)).count()
sent_count = Checklist.query.filter(
Checklist.date_complete.isnot(None),
Checklist.date_complete.isnot(None),
Checklist.date_complete.isnot(None)).count()
reviewed_count = Checklist.query.filter(
Checklist.date_complete.is_(None),
Checklist.date_review_completed.isnot(None),
Checklist.date_sent_to_review.isnot(None)).count()
questions_with_corrections = [
q[0] for q in db.session.query(Answer.question_id).filter(
Answer.reviewer_ready == 'c').group_by(Answer.question_id).all()
]
corrections_by_question_count = [
q[0] for q in db.session.query(db.func.count(Answer.answer_id)).filter(
Answer.reviewer_ready == 'c').group_by(Answer.answer_id).all()
]
questions_requiring_training = [
r.question for r in db.session.query(TemplateQuestion).outerjoin(
Answer, Answer.question_id == TemplateQuestion.question_id).filter(
Answer.reviewer_ready == 'c').all()
]
# 3.0 after grad version
# go back and apply to group by preparer sorted by most to least
return render_template(
'all_checklistsstats.html',
checklists=checklists,
users=users,
answer=answer,
questions=questions,
questions_with_corrections=questions_with_corrections,
corrections_by_question_count=corrections_by_question_count,
questions_requiring_training=questions_requiring_training,
sent_count=sent_count,
reviewed_count=reviewed_count,
in_review_count=in_review_count,
started_count=started_count)
def show_checklist(checklist_id):
# Show details on a particular template.
checklist = crud.get_checklist_by_id(checklist_id)
users = crud.get_users()
answers = crud.get_answers()
questions = crud.get_questions()
# preparer_count=crud.get_preparer_count() # create a helper function to declutter code in server.py
to_do_count = Answer.query.filter(
Answer.checklist_id == checklist_id).filter(
Answer.preparer_answer == 'n').count()
done_count = Answer.query.filter(
Answer.checklist_id == checklist_id).filter(
Answer.preparer_answer == 'y').count()
not_applicable_count = Answer.query.filter(
Answer.checklist_id == checklist_id).filter(
Answer.preparer_answer == 'na').count()
not_answered_count = Answer.query.filter(
Answer.checklist_id == checklist_id).filter(
Answer.preparer_answer == '').count()
# preparer_percent=crud.get_preparer_percent() # create a helper function.
to_do_percent = round(
to_do_count / TemplateQuestion.query.filter(
TemplateQuestion.template_id == checklist.template_id).count() *
100, 2)
done_percent = round(
done_count / TemplateQuestion.query.filter(
TemplateQuestion.template_id == checklist.template_id).count() *
100, 2)
not_applicable_percent = round(
not_applicable_count / TemplateQuestion.query.filter(
TemplateQuestion.template_id == checklist.template_id).count() *
100, 2)
not_answered_percent = round(
not_answered_count / TemplateQuestion.query.filter(
TemplateQuestion.template_id == checklist.template_id).count() *
100, 2)
# reviewer_count=crud.get_reviewer_count() # create a helper function.
to_do_count_reviewer = Answer.query.filter(
Answer.checklist_id == checklist_id).filter(
Answer.reviewer_ready == 'c').count()
done_count_reviewer = Answer.query.filter(
Answer.checklist_id == checklist_id).filter(
Answer.reviewer_ready == 'r').count()
not_applicable_count_reviewer = Answer.query.filter(
Answer.checklist_id == checklist_id).filter(
Answer.reviewer_ready == 'na').count()
not_answered_count_reviewer = Answer.query.filter(
Answer.checklist_id == checklist_id).filter(
Answer.reviewer_ready == '').count()
# reviewer_percent=crud.get_reviewer_percent() # create a helper function.
to_do_percent_reviewer = round(
to_do_count_reviewer / TemplateQuestion.query.filter(
TemplateQuestion.template_id == checklist.template_id).count() *
100, 2)
done_percent_reviewer = round(
done_count_reviewer / TemplateQuestion.query.filter(
TemplateQuestion.template_id == checklist.template_id).count() *
100, 2)
not_applicable_percent_reviewer = round(
not_applicable_count_reviewer / TemplateQuestion.query.filter(
TemplateQuestion.template_id == checklist.template_id).count() *
100, 2)
not_answered_percent_reviewer = round(
not_answered_count_reviewer / TemplateQuestion.query.filter(
TemplateQuestion.template_id == checklist.template_id).count() *
100, 2)
sortparams = {'sortby': 'question_id', 'sortdir': 'asc'}
return render_template(
'checklist_details.html',
sortparams=sortparams,
checklist=checklist,
users=users,
answers=answers,
questions=questions,
to_do_count=to_do_count_reviewer,
done_count=done_count,
not_applicable_count=not_applicable_count,
not_answered_count=not_answered_count,
done_percent=done_percent,
to_do_percent=to_do_percent,
not_applicable_percent=not_applicable_percent,
not_answered_percent=not_answered_percent,
done_count_reviewer=done_count_reviewer,
done_percent_reviewer=done_percent_reviewer,
to_do_count_reviewer=to_do_count_reviewer,
to_do_percent_reviewer=to_do_percent_reviewer,
not_applicable_count_reviewer=not_applicable_count_reviewer,
not_applicable_percent_reviewer=not_applicable_percent_reviewer,
not_answered_count_reviewer=not_answered_count_reviewer,
not_answered_percent_reviewer=not_answered_percent_reviewer)
