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 obj except Exception: db_session.rollback() return 'fail'
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()