# Project: E-commerce Chatbot
# Developed by: Molla Samser
# Team: Rima Khatun (Designer & Tester)
# Website: https://rskworld.in
# Email: support@rskworld.in
# Year: 2026
# "Empowering E-commerce with AI"

from flask_sqlalchemy import SQLAlchemy

db = SQLAlchemy()

def init_db(app):
    db.init_app(app)
    with app.app_context():
        db.create_all()
        # Seed initial data if any core table is empty
        from models import Product, User, Order
        if Product.query.count() == 0 or User.query.count() == 0:
            seed_data()

def seed_data():
    from models import Product, Order, User
    products = [
        Product(name="Eco-Friendly Water Bottle", description="Stainless steel, 500ml", price=25.00, category="Accessories"),
        Product(name="Wireless Noise-Cancelling Headphones", description="Bose QuietComfort 45", price=329.00, category="Electronics"),
        Product(name="Organic Cotton T-Shirt", description="Soft and breathable, variety of colors", price=15.00, category="Clothing"),
        Product(name="Smart Watch with Health Tracking", description="Monitors heart rate, sleep, and activity", price=199.00, category="Electronics"),
        Product(name="Ergonomic Office Chair", description="Adjustable height and lumbar support", price=150.00, category="Furniture")
    ]
    db.session.bulk_save_objects(products)
    
    # Add a sample user with points
    sample_user = User(name="Molla Samser", email="samser@rskworld.in", loyalty_points=500)
    db.session.add(sample_user)
    
    # Add a sample order for tracking demo
    sample_order = Order(order_number="ORD-101", customer_email="samser@rskworld.in", total_amount=479.00, status="Shipped", points_earned=47)
    db.session.add(sample_order)
    
    db.session.commit()