Exemplo n.º 1
0
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)
Exemplo n.º 2
0
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))
Exemplo n.º 3
0
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)
Exemplo n.º 4
0
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))
Exemplo n.º 5
0
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),
    )
Exemplo n.º 6
0
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))
Exemplo n.º 7
0
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)
Exemplo n.º 8
0
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)
Exemplo n.º 9
0
def home():
    db = getattr(g, 'db', None).cursor(mdb.cursors.DictCursor)
    return render_template('home.html',
                           all_category_rows=get_all_categories(db))
Exemplo n.º 10
0
def home():
    db = getattr(g, 'db', None).cursor(mdb.cursors.DictCursor)
    return render_template('home.html', all_category_rows=get_all_categories(db))
Exemplo n.º 11
0
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))
Exemplo n.º 12
0
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)