def update(self, obj):
try:
db_session.merge(obj)
db_session.commit()
return obj
except Exception:
db_session.rollback()
return 'fail'
def save(self, obj):
try:
db_session.add(obj)
db_session.commit()
return obj
except Exception:
db_session.rollback()
return obj
def update(self, obj):
try:
db_session.merge(obj)
db_session.commit()
return self.findById(obj.id)
except Exception:
db_session.rollback()
return obj
def remove(self, obj):
try:
db_session.delete(obj)
db_session.commit()
return obj
except Exception:
db_session.rollback()
return 'fail'
def inserirusuario(self, obj):
try:
if(obj.authorities_id != 1):
db_session.add(obj)
db_session.commit()
return obj
raise Exception('Não permitido')
except Exception:
db_session.rollback()
return
def remove(self, obj):
try:
documentoLinks = dls.findByLinkId(obj.id)
for dl in documentoLinks:
dls.remove(dl)
db_session.delete(obj)
db_session.commit()
return obj
except Exception:
db_session.rollback()
return obj
def inserirusuario(self, obj):
try:
db_session.add(obj)
db_session.commit()
ur = UserRoles()
ur.user_id = obj.id
ur.role_id = obj.role_id
db_session.add(ur)
db_session.commit()
return obj
except Exception:
db_session.rollback()
return
def remove(self, obj):
try:
links = Link.query.filter_by(host_id=obj.id).all()
for link in links:
doclinks = DocumentoLink.query.filter_by(link_id=link.id).all()
for doclink in doclinks:
db_session.delete(doclink)
db_session.delete(link)
db_session.delete(obj)
db_session.commit()
return obj
except Exception:
db_session.rollback()
return 'fail'
def remove(self, obj):
try:
doclinks = DocumentoLink.query.filter_by(documento_id=obj.id).all()
for doc in doclinks:
db_session.delete(doc)
indInv = IndiceInvertido.query.filter_by(documento_id=obj.id).all()
for ind in indInv:
db_session.delete(ind)
db_session.delete(obj)
db_session.commit()
return obj
except Exception:
db_session.rollback()
return 'fail'
def deleteAllNativeQuery(self):
try:
TermoDocumento.query.delete()
db_session.commit()
except Exception:
db_session.rollback()
def deleteAllNativeQuery(self):
try:
IndiceInvertido.query.delete()
db_session.commit()
except Exception:
db_session.rollback()
