def search_tag(tag):
tag = tag.replace("'", "")
filters = []
if tag != "":
filters.append(Contains("tags", tag))
posts = Post.select(filters, [("pid", GuessSetting, "pid"), ("poster", User, "sid")])
posts = Post.prepare_view(current_user, posts)
return render_template("main.html", **{"posts": posts})
def search_pid(pid):
filters = []
pid = pid.replace("'", "")
if pid != "":
filters.append(Equal("pid", pid))
posts = Post.select(filters, [("pid", GuessSetting, "pid"), ("poster", User, "sid")])
posts = Post.prepare_view(current_user, posts)
return render_template("main.html", **{"posts": posts})
def search_user(user):
filters = []
user = user.replace("'", "")
if user != "":
filters.append(Equal("tagged", "'%s'" %user, GuessSetting.table))
posts = Post.select(filters, [("pid", GuessSetting, "pid"), ("poster", User, "sid")])
posts = Post.prepare_view(current_user, posts)
return render_template("main.html", **{"posts": posts})
def own_posts():
filters = []
user = current_user
filters.append(Equal("poster", user.sid))
filters.append(Equal("is_anonymous", False))
filters = Filter.and_reduce(filters)
posts = Post.select(filters, [("pid", GuessSetting, "pid"), ("poster", User, "sid")])
posts = Post.prepare_view(user, posts)
return render_template("main.html", **{"posts": posts})
def index(alert=None):
"""
User.create_table()
Post.create_table()
Comment.create_table()
GuessSetting.create_table()
Like.create_table()
"""
user = current_user
posts = Post.get_all([("pid", GuessSetting, "pid"), ("poster", User, "sid")])
posts = Post.prepare_view(user, posts)
return render_template("main.html", **{"posts": posts, "alert": alert})
def search():
text = request.json.replace("'", "")
pid = request.form.get("post_id", "").replace("'", "").replace(";", "")
contains = request.form.get("contains", "").replace("'", "").replace(";","")
tagged = request.form.get("tagged", "").replace("'", "").replace(";", "")
tags = request.form.get("tags", "").replace("'", "").replace(";", "")
filters = []
search_text = contains if contains != "" else text
if pid != "":
pid_filter = Equal("pid", int(pid))
filters.append(pid_filter)
if search_text != "" and search_text is not None:
filters.append(Contains("post_body", search_text))
if tagged != "" and tagged is not None:
filters.append(Contains("post_body", tagged))
for tag in [x for x in tags.split(",") if not x == ""]:
tag = tag.strip()
filters.append(Contains("tags", tag))
filters = Filter.and_reduce(filters)
posts = Post.select(filters, [("pid", GuessSetting, "pid"), ("poster", User, "sid")])
posts = Post.prepare_view(current_user, posts)
return render_template("main.html", **{"posts": posts})
