| from sqlmodel import Session, select | |
| from database import engine | |
| from models import User | |
| def check_users(): | |
| try: | |
| with Session(engine) as session: | |
| users = session.exec(select(User)).all() | |
| print(f"Users found: {len(users)}") | |
| for user in users: | |
| print(f"User: {user.email}, ID: {user.id}") | |
| except Exception as e: | |
| print(f"Error checking users: {e}") | |
| def test_create_user(): | |
| try: | |
| with Session(engine) as session: | |
| print("Attempting to create user...") | |
| # Simulate the register logic | |
| user = User( | |
| email="test_manual@example.com", | |
| password_hash="dummyhash", | |
| full_name="Manual Test" | |
| ) | |
| session.add(user) | |
| session.commit() | |
| print("User created successfully!") | |
| # Clean up | |
| session.delete(user) | |
| session.commit() | |
| except Exception as e: | |
| import traceback | |
| traceback.print_exc() | |
| print(f"Error creating user: {e}") | |
| if __name__ == "__main__": | |
| check_users() | |
| test_create_user() | |