def search_page():
context = request.context
search = request.args.get('s', '')
if search != '':
wildcard = '%' + search + '%'
query = """SELECT USER_PATH_ID FROM users WHERE username LIKE (?);"""
users = query_db(query, (wildcard,))
context['users'] = encoder.encode_qry(users)
context['query'] = encoder.encode(search)
return render_template('search_results.html', **context)
return redirect('/')
def index():
posts = query_db(
'SELECT posts.creator,posts.date,posts.title,posts.content,users.name,users.username,users.USER_PATH_ID FROM '
'posts JOIN users ON posts.creator=users.userid ORDER BY date DESC LIMIT 10')
def fix(item):
item['date'] = datetime.datetime.fromtimestamp(item['date']).strftime('%Y-%m-%d %H:%M')
item['content'] = '%s...' % (item['content'][:200])
return item
context = request.context
context['posts'] = map(fix, encoder.encode_qry(posts))
return render_template('index.html', **context)
def users_posts_by_user_path_id(user_path_id=None):
cid = query_db('SELECT userid FROM users WHERE USER_PATH_ID=%s' % (user_path_id))
if len(cid) < 1:
return 'No such user'
query = 'SELECT date,title,content, USER_PATH_ID FROM POSTS NATURAL JOIN USERS WHERE USER_PATH_ID=%s ORDER BY ' \
'date DESC' % user_path_id
context = request.context
def fix(item):
item['date'] = datetime.datetime.fromtimestamp(item['date']).strftime('%Y-%m-%d %H:%M')
return item
results = query_db(query)
context['posts'] = map(fix, encoder.encode_qry(results))
return render_template('user_posts.html', **context)