17 lines
No EOL
553 B
Python
17 lines
No EOL
553 B
Python
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 |