def update(self, stat): try: self.db.session.merge(stat) self.db.session.commit() except IntegrityError as e: self.db.session.rollback() raise DBIntegrityError(e)
def save(self, stat): try: self.db.session.add(stat) self.db.session.commit() except IntegrityError as e: self.db.session.rollback() raise DBIntegrityError(e)
def save(self, announcement): self._validate_can_be('saved', announcement) try: self.db.session.add(announcement) self.db.session.commit() except IntegrityError as e: self.db.session.rollback() raise DBIntegrityError(e)
def update(self, projectcoowner): self._validate_can_be('updated', projectcoowner) try: self.db.session.merge(projectcoowner) self.db.session.commit() except IntegrityError as e: self.db.session.rollback() raise DBIntegrityError(e)
def save_category(self, category): self._validate_can_be('saved as a Category', category, klass=Category) try: self.db.session.add(category) self.db.session.commit() except IntegrityError as e: self.db.session.rollback() raise DBIntegrityError(e)
def update_category(self, new_category, caller="web"): self._validate_can_be('updated as a Category', new_category, klass=Category) try: self.db.session.merge(new_category) self.db.session.commit() except IntegrityError as e: self.db.session.rollback() raise DBIntegrityError(e)
def save(self, user): self._validate_can_be('saved', user) try: self.db.session.add(user) self.db.session.commit() except IntegrityError as e: self.db.session.rollback() raise DBIntegrityError(e)
def update(self, result): self._validate_can_be('updated', result) try: self.db.session.merge(result) self.db.session.commit() except IntegrityError as e: self.db.session.rollback() raise DBIntegrityError(e)
def update(self, project): self._validate_can_be('updated', project) try: self.db.session.merge(project) self.db.session.commit() cached_projects.delete_project(project.short_name) except IntegrityError as e: self.db.session.rollback() raise DBIntegrityError(e)
def update(self, project): self._validate_can_be('updated', project) self._empty_strings_to_none(project) try: self.db.session.merge(project) self.db.session.commit() except IntegrityError as e: self.db.session.rollback() raise DBIntegrityError(e)
def save(self, element): self._validate_can_be('saved', element) try: self.db.session.add(element) self.db.session.commit() cached_projects.clean_project(element.project_id) except IntegrityError as e: self.db.session.rollback() raise DBIntegrityError(e)
def update(self, blogpost): self._validate_can_be('updated', blogpost) try: self.db.session.merge(blogpost) self.db.session.commit() clean_project(blogpost.project_id) except IntegrityError as e: self.db.session.rollback() raise DBIntegrityError(e)
def delete(self, user): self._validate_can_be('deleted', user) try: self.fake_user_id(user) self.db.session.delete(user) self.db.session.commit() except IntegrityError as e: self.db.session.rollback() raise DBIntegrityError(e)
def update(self, element): self._validate_can_be(self.UPDATE_ACTION, element) try: self.db.session.merge(element) self.db.session.commit() cached_projects.clean_project(element.project_id) except IntegrityError as e: self.db.session.rollback() raise DBIntegrityError(e)
def save(self, project): self._validate_can_be('saved', project) self._empty_strings_to_none(project) self._creator_is_owner(project) try: self.db.session.add(project) self.db.session.commit() except IntegrityError as e: self.db.session.rollback() raise DBIntegrityError(e)
def save(self, user): self._validate_can_be('saved', user) try: can_have_super_user_access(user) self.lowercase_user_attributes(user) self.db.session.add(user) self.db.session.commit() except IntegrityError as e: self.db.session.rollback() raise DBIntegrityError(e)
def update(self, new_user): self._validate_can_be('updated', new_user) try: can_have_super_user_access(new_user) self.lowercase_user_attributes(new_user) self.db.session.merge(new_user) self.db.session.commit() except IntegrityError as e: self.db.session.rollback() raise DBIntegrityError(e)
def save(self, project): self._validate_can_be('saved', project) self._empty_strings_to_none(project) try: self.db.session.add(project) self.db.session.commit() cached_projects.delete_project(project.short_name) except IntegrityError as e: self.db.session.rollback() raise DBIntegrityError(e)
def save(self, element, clean_project=True): self._validate_can_be(self.SAVE_ACTION, element) try: self.db.session.add(element) self.db.session.commit() if clean_project: cached_projects.clean_project(element.project_id) except IntegrityError as e: self.db.session.rollback() raise DBIntegrityError(e)
def update(self, project): self._validate_can_be('updated', project) self._empty_strings_to_none(project) self._creator_is_owner(project) self._verify_has_password(project) try: self.db.session.merge(project) self.db.session.commit() except IntegrityError as e: self.db.session.rollback() raise DBIntegrityError(e)
def update(self, element): print "in update" self._validate_can_be('updated', element) try: print "in update try" self.db.session.merge(element) self.db.session.commit() print "in update try" cached_projects.clean_project(element.project_id) except IntegrityError as e: print "in rollback" self.db.session.rollback() raise DBIntegrityError(e)
def save(self, project): self._validate_can_be('saved', project) self._empty_strings_to_none(project) self._creator_is_owner(project) self._verify_has_password(project) self._verify_data_classification(project) self._verify_required_fields(project) self._verify_product_subproduct(project) try: self.db.session.add(project) self.db.session.commit() except IntegrityError as e: self.db.session.rollback() raise DBIntegrityError(e)
def save(self, UserScore): project_id = getattr(UserScore, 'project_id') if current_user.is_authenticated(): if not self._check_for_score(project_id): self._validate_can_be('saved', UserScore) try: self.db.session.add(UserScore) self.db.session.commit() except IntegrityError as e: self.db.session.rollback() raise DBIntegrityError(e) else: return False else: return Unauthorized()
def delete_data(self, user): self._validate_can_be('deleted', user) import uuid try: dummy = 'del-' + str(uuid.uuid4()) user.name = dummy user.fullname = dummy user.email_addr = '{}@del.com'.format(dummy) user.enabled = False user.info = {} user.user_pref = {} self.db.session.merge(user) self.db.session.commit() except IntegrityError as e: self.db.session.rollback() raise DBIntegrityError(e)