def top_products()

in sql_implementation/__init__.py [0:0]

• 17 lines of code
• 2 McCabe index (conditional complexity)

def top_products():
    db = current_app.config["sqldb"]
    sold_amount = func.sum(OrderLine.amount).label('sold')
    product_list = db.session.query(
        Product.id,
        Product.sku,
        Product.name,
        Product.stock,
        sold_amount
    ).outerjoin(OrderLine).group_by(Product.id).order_by(sold_amount.desc()).limit(3)
    return jsonify([{
        'id': p.id,
        'sku': p.sku,
        'name': p.name,
        'stock': p.stock,
        'sold': p.sold,
    } for p in product_list])