from sqlalchemy.pool import PoolProxiedConnection


class CancelamentoProposta:
    def __init__(self, conexao: PoolProxiedConnection) -> None:
        self.conexao = conexao 
        
    def cancelar_no_banco(self, id_processo: str) -> bool:
        cursor = self.conexao.cursor()
        cursor.execute("""
            UPDATE HOLMES_FAT_ESTOQUE
            SET STATUS = 'CANCELADO', DTA_ALTERACAO_STATUS = GETDATE()
            WHERE ID_PROCESSO = ? 
        """, id_processo)
        
        self.conexao.commit()
        return cursor.rowcount > 0