def test_soft_delete_mixin(self):
# noinspection PyArgumentList
instance = SoftDeleteCheckingModel(title='test title')
DBSession.add(instance)
DBSession.commit()
instance.assert_is_not_deleted()
self.assertRaises(ValueError, instance.assert_is_deleted)
instance = SoftDeleteCheckingModel.query.one()
instance.soft_delete()
DBSession.commit()
instance.assert_is_deleted()
self.assertRaises(ValueError, instance.assert_is_not_deleted)
self.assertEqual(SoftDeleteCheckingModel.filter_deleted().count(), 1)
self.assertEqual(SoftDeleteCheckingModel.exclude_deleted().count(), 0)
instance.soft_undelete()
DBSession.commit()
instance.assert_is_not_deleted()
self.assertRaises(ValueError, instance.assert_is_deleted)
self.assertEqual(SoftDeleteCheckingModel.filter_deleted().count(), 0)
self.assertEqual(SoftDeleteCheckingModel.exclude_deleted().count(), 1)
DBSession.delete(instance)
self.assertRaises(HttpConflict, DBSession.commit)
def unregister(self, id):
id = int_or_notfound(id)
member = DBSession.query(Member).get(id)
if member is None:
raise HTTPNotFound()
DBSession.delete(member)
return member
def delete(self, id):
foo = DBSession.query(Foo) \
.filter(Foo.id == id) \
.one_or_none()
if foo is None:
raise HTTPNotFound(f'Foo with id: {id} is not registered')
DBSession.delete(foo)
return foo
def delete(self, listtitle, itemtitle):
me = context.identity.id
item = DBSession.query(Item) \
.filter(Item.ownerid == me) \
.filter(Item.list == listtitle) \
.filter(Item.title == itemtitle) \
.one_or_none()
if item is None:
raise HTTPNotFound()
DBSession.delete(item)
return ''.join((str(item), CR))
def __call__(self, args):
user = DBSession.query(User).filter(User.id == args.name).one_or_none()
if user is None:
print(f'Invalid username: {args.name}', file=sys.stderr)
return 1
if input(
f'Are you sure to delete the user: {user.id}? [N/y] '
).casefold() != 'y'.casefold():
print(f'User: {args.name} is not deleted', file=sys.stderr)
return 1
DBSession.delete(user)
DBSession.commit()
def delete(self, id_: int = None):
m = DBSession.query(Resource).filter(Resource.id == id_).one_or_none()
if m is None:
raise HTTPNotFound()
DBSession.delete(m)
return m
def delete(self, id: int):
instance = self._ensure(id)
DBSession.delete(instance)
return instance
def delete(self, id_: int = None):
m = Resource.query.filter(Resource.id == id_).one_or_none()
context.etag_match(m.__etag__)
DBSession.delete(m)
return m
def delete(self, issue_id: int):
issue = self.ensure_issue(issue_id)
DBSession.delete(issue)
return issue
