StoreItems.py

from app4 import app, db, Product

inventory = [
        { "name": "Cross Beaded Necklace", "price": 8, "description": "Gothic style cross on a black beaded necklace with hanging chain detailing", "image": "crossNecklace.jpg"},
        { "name": "Safety Pin Industrial Bar", "price": 5, "description": "Silver safety pin style industrial piercing bar - ear safe surgical steel","image": "safetyPinEarring.jpg"},
        { "name": "Watch Ring", "price": 10, "description": "Vintage silver mini watch rings, adjustable - batteries not included", "image": "watchRings.jpg"},
        { "name": "Zip Style Earrings", "price": 5, "description": "Silver zip style earrings with dangly chain and heart charms.", "image": "zipEarrings.jpg"},
        { "name": "Star Buckle Bracelet", "price": 4, "description": "Think silver plated chain link bracelet with a hammered detailed star shaped buckle enclosure", "image": "starBracelet.jpg"}
    ]

with app.app_context():
    db.create_all()

    for item in inventory:
        newItem = Product(name = item["name"], price = item["price"], description = item["description"], image = item["image"])
        db.session.add(newItem)
    
    db.session.commit()