Jun-dev
f699a29a85
- Add main application files (main.py, models.py, schemas.py, etc.) - Add routers for all features (waiting, attendance, members, etc.) - Add HTML templates for admin and user interfaces - Add migration scripts and utility files - Add Docker configuration - Add documentation files - Add .gitignore to exclude database and cache files 🤖 Generated with [Claude Code](https://claude.com/claude-code) Co-Authored-By: Claude Sonnet 4.5 <noreply@anthropic.com>
36 lines
1.1 KiB
Python
36 lines
1.1 KiB
Python
|
|
from sqlalchemy import create_engine
|
|
from sqlalchemy.orm import sessionmaker, joinedload
|
|
from models import Store, WaitingList, Member
|
|
|
|
SQLALCHEMY_DATABASE_URL = "sqlite:///./waiting_system.db"
|
|
engine = create_engine(SQLALCHEMY_DATABASE_URL, connect_args={"check_same_thread": False})
|
|
SessionLocal = sessionmaker(autocommit=False, autoflush=False, bind=engine)
|
|
db = SessionLocal()
|
|
|
|
def check_class_info():
|
|
target_date = "2025-12-08"
|
|
store_name = "서울목동지점"
|
|
missing_number = 5
|
|
|
|
store = db.query(Store).filter(Store.name == store_name).first()
|
|
|
|
entry = db.query(WaitingList).options(joinedload(WaitingList.member)).filter(
|
|
WaitingList.store_id == store.id,
|
|
WaitingList.waiting_number == missing_number,
|
|
).order_by(WaitingList.registered_at.desc()).first()
|
|
|
|
if entry:
|
|
print(f"entry ID: {entry.id}")
|
|
print(f"Waiting Number: {entry.waiting_number}")
|
|
print(f"Class ID: {entry.class_id}")
|
|
print(f"Status: {entry.status}")
|
|
|
|
if __name__ == "__main__":
|
|
try:
|
|
check_class_info()
|
|
except Exception as e:
|
|
print(f"Error: {e}")
|
|
finally:
|
|
db.close()
|