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)