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)