from sqlalchemy.sql import text
app = Flask(__name__)
photos = UploadSet('photos', IMAGES)
app.config.from_object(
'config'
) # link config.py to this file(with all databse file paths, image upload paths)
configure_uploads(app, photos)
db = SQLAlchemy(app)
bootstrap = Bootstrap(app)
em_cart = ShoppingCart()
em_cart.total = 0
@app.route('/')
def home():
items = Retailer.query.all()
w_items = Wholeseller.query.all()
govt = Government.query.all()
retailer_list = ['kiran', 'raju', 'mani', 'jayanthi', 'naresh']
best_retailer = random.choice(retailer_list)
connection = engine.connect()
s = text("SELECT SUM(price) FROM Retailer WHERE region=:r")
total_revenue = 450
return render_template('pages/index.html',
items=items,
govt=govt,
