def undelete(cls, op, date, pid):
sql = """UPDATE hive_posts SET is_valid = :is_valid, is_deleted = '0',
parent_id = :parent_id, category = :category,
community = :community, depth = :depth
WHERE id = :id"""
post = cls._build_post(op, date, pid)
DB.query(sql, **post)
if not DbState.is_initial_sync():
CachedPost.undelete(pid, post['author'], post['permlink'])
cls._insert_feed_cache(post)
def undelete(cls, op, date, pid):
"""Re-allocates an existing record flagged as deleted."""
sql = """UPDATE hive_posts SET is_valid = :is_valid,
is_muted = :is_muted, is_deleted = '0', is_pinned = '0',
parent_id = :parent_id, category = :category,
community_id = :community_id, depth = :depth
WHERE id = :id"""
post = cls._build_post(op, date, pid)
DB.query(sql, **post)
if not DbState.is_initial_sync():
if post['error']:
author_id = Accounts.get_id(post['author'])
Notify('error', dst_id=author_id, when=date,
post_id=post['id'], payload=post['error']).write()
CachedPost.undelete(pid, post['author'], post['permlink'],
post['category'])
cls._insert_feed_cache(post)