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)