from app import create_app, db
from app.models import Category, Item, ContactInfo

app = create_app()

with app.app_context():
    db.drop_all()  # Be careful! This will delete all existing data
    db.create_all()
    
    # Add some default categories
    categories = [
        Category(name='Furniture'),
        Category(name='Electronics'),
        Category(name='Clothing'),
        Category(name='Books'),
        Category(name='Kitchen'),
        Category(name='Toys'),
        Category(name='Miscellaneous')
    ]
    
    db.session.add_all(categories)
    
    # Add default contact info
    contact_info = ContactInfo(
        email="your-email@example.com",
        signal="Your Signal username or number",
        donation_link="https://example.com/donate"
    )
    
    db.session.add(contact_info)
    db.session.commit()
    
    print("Database initialized successfully!")