def check_name(name, user_id): if len(name) < 2 or len(name) > 35: return "Nimen tulee sisältää 2-35 merkkiä" if users.check_exist(name) > 0: if name != users.get_username(user_id): return "Nimi on jo käytössä, valitse toinen nimi" return "ok"
def get_book_reviews(isbn): book_id = get_book_id(isbn) reviews_query = db.execute( "SELECT * FROM reviews WHERE book_id = :book_id", { "book_id": book_id }).fetchall() if reviews_query == []: return None reviews = [] for review in reviews_query: reviews.append({ "id": review.id, "reviewer_name": get_user_fullname(get_username(review.user_id)), "rating": review.rating, "review_body": review.review, "pub_date": f"{review.pub_date.year}/{review.pub_date.month}/{review.pub_date.day}" }) return reviews
def get(self): user = self.check_loggedin() context = {} if user: context['username'] = users.get_username(user) self.redirect('/') else: self.render_response('login.html', **context)
def get(self): context = { 'login_state': 'Login', 'url': '/login' } user = self.check_loggedin() if user: context['username'] = users.get_username(user) self.redirect('/') else: self.render_response('signup.html', **context)
def get(self, page_name): user = self.check_loggedin() username = users.get_username(user) edits = wikipage.get_all_edits(page_name) context = { 'page_name': page_name, 'edits' : edits, 'username' : username } self.render_response('history.html', **context)
def get_chat(chat_id): chat = {} sql = """SELECT title, created_at, privated, closed, campaign_id FROM chats WHERE id=:chat_id""" result = db.session.execute(sql, {"chat_id":chat_id}).fetchone() chat["id"] = chat_id chat["title"] = result[0] chat["time"] = result[1] chat["private"] = result[2] chat["closed"] = result[3] chat["campaign_id"] = result[4] participants = get_chatters(chat_id) chatters = [users.get_username(chatter_id) for chatter_id in participants] chat["chatters"] = chatters chat["messages"] = get_messages(chat_id) return chat
def recipe(id): recipe, msg = recipes.get_recipe(id) if not recipe: return render_template("error.html", error=msg) creator = users.get_username(recipe[1]) ingredients = recipes.get_recipe_ingredients(id) tags = recipes.get_recipe_tags(id) favourite = recipes.is_favourite(id) average = reviews.get_average(id) comments = reviews.get_comments(id) return render_template("recipe.html", creator=creator, recipe=recipe, tags=tags, ingredients=ingredients, comments=comments, average=average, favourite=favourite)
def get(self, page_name): user = self.check_loggedin() # page = wikipage.latest_version(page_name) version = self.request.get('v') if not version: try: r = webapp2.Request.blank(self.request.referer) version = r.get('v') except TypeError: version = None if user: username = users.get_username(user) page = wikipage.get_version_or_create(page_name, version) context = { 'page': page, 'page_name': page_name, 'username': username } self.render_response('edit.html', **context) else: self.redirect('/login')
def get(self, page_name): user = self.check_loggedin() version = self.request.get('v') page = wikipage.get_version_or_latest(page_name, version) if not page: self.redirect('/_edit%s'%page_name) # allpages = wikipage.get_all_pages() context = { 'page': page, 'page_name': page_name, 'pages': allpages } if user: username = users.get_username(user) context['username'] = username if not username: self.logout() self.render_response("page.html", **context)
def index(): username = "" if "user_id" in session: username = users.get_username(session["user_id"]) return render_template("index.html", username=username)
def show_messages(): m = messages.get_messages() name = users.get_username() print(name) return render_template('show_messages.html', messages=m, name=name)