def display_asset(asset_id): db = getattr(g, 'db', None).cursor(mdb.cursors.DictCursor) db.execute('select * from Asset where idAsset=%s', [asset_id]) asset_rows = db.fetchall() nav_category_id = asset_rows[0]['Category_idCategory'] db.execute('select name from Category where idCategory=(%s)', [nav_category_id]) nav_category_name = db.fetchall()[0]['name'] db.execute('select * from Review where Asset_idAsset=(%s)', [asset_id]) review_rows = db.fetchall() reviews = [] current_user_review = None for row in review_rows: review = Review(db, row) if not current_user.is_anonymous and long( current_user.user_id) == long(row['User_idUser']): current_user_review = review else: reviews.append(review) return render_template('asset_page.html', all_category_rows=get_all_categories(db), nav_category_id=nav_category_id, nav_category_name=nav_category_name, asset_row=asset_rows[0], reviews=reviews, current_user_review=current_user_review)
def display_category(category_id=None, order_by='name', order='asc', error_message=None): db = getattr(g, 'db', None).cursor(mdb.cursors.DictCursor) try: long(category_id) except: category_id = None if not category_id: db.execute('select * from Category order by name asc limit 1') first_category = db.fetchall() category_id = first_category[0]["idCategory"] db.execute('select name from Category where idCategory=(%s)', [category_id]) nav_category_name = db.fetchall()[0]['name'] nav_category_id = category_id order_by = validate_order_by(order_by) order = validate_order(order) db.execute('select * from Asset where Category_idCategory=%s order by %s %s' % (nav_category_id, order_by, order)) nav_category_asset_row_list = db.fetchall() return render_template('browse.html', error_message=error_message, order=order, order_by=order_by, nav_category_id=nav_category_id, nav_category_name=nav_category_name, nav_category_asset_row_list=nav_category_asset_row_list, all_category_rows=get_all_categories(db))
def signup(message=None): db = getattr(g, 'db', None).cursor(mdb.cursors.DictCursor) db.execute('select * from User order by idUser desc') rows = db.fetchall() return render_template('signup.html', all_category_rows=get_all_categories(db), rows=rows, message=message)
def display_basket(user_id=None, selected_prev_basket_id=None): if not user_id_valid(user_id): abort(401) db = getattr(g, 'db', None).cursor(mdb.cursors.DictCursor) active_basket = Basket(db, get_active_basket(user_id)) previous_baskets_rows = get_previous_baskets(user_id) previous_baskets = [] for basket_row in previous_baskets_rows: previous_baskets.append(Basket(db, basket_row)) return render_template('basket.html', active_basket=active_basket, previous_baskets=previous_baskets, selected_prev_basket_id=selected_prev_basket_id, all_category_rows=get_all_categories(db))
def display_basket(user_id=None, selected_prev_basket_id=None): if not user_id_valid(user_id): abort(401) db = getattr(g, "db", None).cursor(mdb.cursors.DictCursor) active_basket = Basket(db, get_active_basket(user_id)) previous_baskets_rows = get_previous_baskets(user_id) previous_baskets = [] for basket_row in previous_baskets_rows: previous_baskets.append(Basket(db, basket_row)) return render_template( "basket.html", active_basket=active_basket, previous_baskets=previous_baskets, selected_prev_basket_id=selected_prev_basket_id, all_category_rows=get_all_categories(db), )
def logout(): db = getattr(g, "db", None).cursor(mdb.cursors.DictCursor) logout_user() return render_template("login.html", all_category_rows=get_all_categories(db))
def login(message=None): db = getattr(g, "db", None).cursor(mdb.cursors.DictCursor) return render_template("login.html", all_category_rows=get_all_categories(db), message=message)
def mypage(message=None): db = getattr(g, 'db', None).cursor(mdb.cursors.DictCursor) db.execute('select * from User order by idUser desc') rows = db.fetchall() return render_template('mypage.html', all_category_rows=get_all_categories(db), rows=rows, message=message)
def home(): db = getattr(g, 'db', None).cursor(mdb.cursors.DictCursor) return render_template('home.html', all_category_rows=get_all_categories(db))
def logout(): db = getattr(g, 'db', None).cursor(mdb.cursors.DictCursor) logout_user() return render_template('login.html', all_category_rows=get_all_categories(db))
def login(message=None): db = getattr(g, 'db', None).cursor(mdb.cursors.DictCursor) return render_template('login.html', all_category_rows=get_all_categories(db), message=message)