from sqlalchemy.orm import Session
from app.models.smtp import Smtp
from app.schemas.smtp import SmtpCreate, SmtpUpdate
from datetime import datetime
def get_smtp(db: Session, smtp_id: int):
    return db.query(Smtp).filter(Smtp.id == smtp_id).first()

def get_smtp(db: Session, skip: int = 0, limit: int = 10):
    return db.query(Smtp).offset(skip).limit(limit).all()




def update_smtp(db: Session, smtp_id: int, smtp_data: SmtpUpdate):
    db_smtp= db.query(Smtp).filter(Smtp.id == smtp_id).first()
    if db_smtp:
        for key, value in smtp_data.dict().items():
            setattr(db_smtp, key, value)
        db.commit()
        db.refresh(db_smtp)
    return db_smtp