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

if __name__ == "__main__":
    print("Attempting to create tables...")
    create_tables()
    if os.path.exists("localfood.db"):
        print("SUCCESS: localfood.db created.")
        print(f"Size: {os.path.getsize('localfood.db')} bytes")
    else:
        print("FAILURE: localfood.db not found in current directory.")
        # Check absolute path
        abs_path = os.path.abspath("localfood.db")
        print(f"Looked at: {abs_path}")