import sys
import os
sys.path.insert(0, os.path.dirname(os.path.dirname(__file__)))
from database import search_foods_by_name

if __name__ == "__main__":
    for query in ["egg", "bacon", "salmon", "beef"]:
        results = search_foods_by_name(query)
        print(f"Results for '{query}':")
        for r in results:
            print(f" - {r['name']} (Category: {r['category']})")
        if not results:
            print(" - NO RESULTS")