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)
