Download realtime_ai_character/database/connection.py from MasterDee/RealChar: direct link, hf CLI and curl.
- Browser
- Download file 1.1 kB
-
https://huggingface.co/spaces/MasterDee/RealChar/resolve/main/realtime_ai_character/database/connection.py
- Command line
-
hf download hf://spaces/MasterDee/RealChar/realtime_ai_character/database/connection.py
-
curl -L -o connection.py https://huggingface.co/spaces/MasterDee/RealChar/resolve/main/realtime_ai_character/database/connection.py
1.1 kB
| from sqlalchemy import create_engine | |
| from sqlalchemy.orm import sessionmaker, scoped_session | |
| from dotenv import load_dotenv | |
| import os | |
| load_dotenv() | |
| SQLALCHEMY_DATABASE_URL = os.getenv("DATABASE_URL") | |
| connect_args = {"check_same_thread": False} if SQLALCHEMY_DATABASE_URL.startswith( | |
| "sqlite") else {} | |
| engine = create_engine( | |
| SQLALCHEMY_DATABASE_URL, connect_args=connect_args | |
| ) | |
| SessionLocal = sessionmaker( | |
| autocommit=False, autoflush=False, bind=engine) | |
| def get_db(): | |
| db = SessionLocal() | |
| try: | |
| yield db | |
| finally: | |
| db.close() | |
| if __name__ == "__main__": | |
| print(SQLALCHEMY_DATABASE_URL) | |
| from realtime_ai_character.models.user import User | |
| from realtime_ai_character.models.interaction import Interaction | |
| with SessionLocal() as session: | |
| print(session.query(User).all()) | |
| session.delete(User(name="Test", email="text@gmail.com")) | |
| session.commit() | |
| print(session.query(User).all()) | |
| session.query(User).filter(User.name == "Test").delete() | |
| session.commit() | |
| print(session.query(User).all()) | |