async def get_discussions_by_created(start_author: str = '', start_permlink: str = '', limit: int = 20, tag: str = None, truncate_body: int = 0): """Query posts, sorted by creation date.""" ids = cursor.pids_by_query( 'created', valid_account(start_author, allow_empty=True), valid_permlink(start_permlink, allow_empty=True), valid_limit(limit, 100), valid_tag(tag, allow_empty=True)) return load_posts(ids, truncate_body=truncate_body)
async def get_discussions_by_created(context, start_author='', start_permlink='', limit=20, tag=None): """Query posts, sorted by creation date.""" ids = await cursor.pids_by_query( context['db'], 'created', valid_account(start_author, allow_empty=True), valid_permlink(start_permlink, allow_empty=True), valid_limit(limit, 100), valid_tag(tag, allow_empty=True)) return await load_posts(context['db'], ids)
async def get_post_discussions_by_payout(context, start_author: str = '', start_permlink: str = '', limit: int = 20, tag: str = None, truncate_body: int = 0): """Query top-level posts, sorted by payout.""" ids = await cursor.pids_by_query( context['db'], 'payout', valid_account(start_author, allow_empty=True), valid_permlink(start_permlink, allow_empty=True), valid_limit(limit, 100), valid_tag(tag, allow_empty=True)) return await load_posts(context['db'], ids, truncate_body=truncate_body)
async def get_discussions_by_hot(context, start_author: str = '', start_permlink: str = '', limit: int = 20, tag: str = None, truncate_body: int = 0, filter_tags: list = None): """Query posts, sorted by hot score.""" assert not filter_tags, 'filter_tags not supported' ids = await cursor.pids_by_query( context['db'], 'hot', valid_account(start_author, allow_empty=True), valid_permlink(start_permlink, allow_empty=True), valid_limit(limit, 100), valid_tag(tag, allow_empty=True)) return await load_posts(context['db'], ids, truncate_body=truncate_body)
async def get_trending_tags(context, start_tag: str = '', limit: int = 250): """Get top 250 trending tags among pending posts, with stats.""" limit = valid_limit(limit, ubound=250) start_tag = valid_tag(start_tag or '', allow_empty=True) if start_tag: seek = """ HAVING SUM(payout) <= ( SELECT SUM(payout) FROM hive_posts_cache WHERE is_paidout = '0' AND category = :start_tag) """ else: seek = '' sql = """ SELECT category, COUNT(*) AS total_posts, SUM(CASE WHEN depth = 0 THEN 1 ELSE 0 END) AS top_posts, SUM(payout) AS total_payouts FROM hive_posts_cache WHERE is_paidout = '0' GROUP BY category %s ORDER BY SUM(payout) DESC LIMIT :limit """ % seek out = [] for row in await context['db'].query_all(sql, limit=limit, start_tag=start_tag): out.append({ 'name': row['category'], 'comments': row['total_posts'] - row['top_posts'], 'top_posts': row['top_posts'], 'total_payouts': "%.3f SBD" % row['total_payouts'] }) return out
async def get_state(path: str): """`get_state` reimplementation. See: https://github.com/steemit/steem/blob/06e67bd4aea73391123eca99e1a22a8612b0c47e/libraries/app/database_api.cpp#L1937 """ (path, part) = _normalize_path(path) state = { 'feed_price': _get_feed_price(), 'props': _get_props_lite(), 'tags': {}, 'accounts': {}, 'content': {}, 'tag_idx': { 'trending': [] }, 'discussion_idx': { "": {} } } # account - `/@account/tab` (feed, blog, comments, replies) if part[0] and part[0][0] == '@': assert not part[1] == 'transfers', 'transfers API not served here' assert not part[1] == 'blog', 'canonical blog route is `/@account`' assert not part[2], 'unexpected account path[2] %s' % path account = valid_account(part[0][1:]) state['accounts'][account] = _load_account(account) if part[1] not in ACCOUNT_TAB_IGNORE: assert part[1] in ACCOUNT_TAB_KEYS, "invalid acct path %s" % path key = ACCOUNT_TAB_KEYS[part[1]] posts = await _get_account_discussion_by_key(account, key) state['content'] = _keyed_posts(posts) state['accounts'][account][key] = list(state['content'].keys()) # discussion - `/category/@account/permlink` elif part[1] and part[1][0] == '@': author = valid_account(part[1][1:]) permlink = valid_permlink(part[2]) post_id = get_post_id(author, permlink) state['content'] = _load_posts_recursive([post_id]) if post_id else {} state['accounts'] = _load_content_accounts(state['content']) # ranked posts - `/sort/category` elif part[0] in ['trending', 'promoted', 'hot', 'created']: assert not part[2], "unexpected discussion path part[2] %s" % path sort = valid_sort(part[0]) tag = valid_tag(part[1].lower(), allow_empty=True) posts = load_posts(cursor.pids_by_query(sort, '', '', 20, tag)) state['content'] = _keyed_posts(posts) state['discussion_idx'] = {tag: {sort: list(state['content'].keys())}} state['tag_idx'] = {'trending': await get_top_trending_tags_summary()} # tag "explorer" - `/tags` elif part[0] == "tags": assert not part[1] and not part[2], 'invalid /tags request' for tag in await get_trending_tags(): state['tag_idx']['trending'].append(tag['name']) state['tags'][tag['name']] = tag elif part[0] == 'witnesses' or part[0] == '~witnesses': assert not part[1] and not part[2] raise Exception("not implemented: /%s" % path) elif part[0] in CONDENSER_NOOP_URLS: assert not part[1] and not part[2] else: print('unhandled path /%s' % path) return state
async def get_state(context, path: str): """`get_state` reimplementation. See: https://github.com/steemit/steem/blob/06e67bd4aea73391123eca99e1a22a8612b0c47e/libraries/app/database_api.cpp#L1937 """ (path, part) = _normalize_path(path) db = context['db'] state = { 'feed_price': await _get_feed_price(db), 'props': await _get_props_lite(db), 'tags': {}, 'accounts': {}, 'content': {}, 'tag_idx': { 'trending': [] }, 'discussion_idx': { "": {} } } # account - `/@account/tab` (feed, blog, comments, replies) if part[0] and part[0][0] == '@': assert not part[1] == 'transfers', 'transfers API not served here' assert not part[2], 'unexpected account path[2] %s' % path if part[1] == '': part[1] = 'blog' account = valid_account(part[0][1:]) state['accounts'][account] = await _load_account(db, account) if part[1] in ACCOUNT_TAB_KEYS: key = ACCOUNT_TAB_KEYS[part[1]] posts = await _get_account_discussion_by_key(db, account, key) state['content'] = _keyed_posts(posts) state['accounts'][account][key] = list(state['content'].keys()) elif part[1] in ACCOUNT_TAB_IGNORE: pass # condenser no-op URLs else: # invalid/undefined case; probably requesting `@user/permlink`, # but condenser still relies on a valid response for redirect. state['error'] = 'invalid get_state account path %s' % path # discussion - `/category/@account/permlink` elif part[1] and part[1][0] == '@': author = valid_account(part[1][1:]) permlink = valid_permlink(part[2]) state['content'] = await _load_discussion(db, author, permlink) state['accounts'] = await _load_content_accounts(db, state['content']) # ranked posts - `/sort/category` elif part[0] in POST_LIST_SORTS: assert not part[2], "unexpected discussion path part[2] %s" % path sort = valid_sort(part[0]) tag = valid_tag(part[1].lower(), allow_empty=True) pids = await cursor.pids_by_query(db, sort, '', '', 20, tag) state['content'] = _keyed_posts(await load_posts(db, pids)) state['discussion_idx'] = {tag: {sort: list(state['content'].keys())}} state['tag_idx'] = { 'trending': await get_top_trending_tags_summary(context) } # tag "explorer" - `/tags` elif part[0] == "tags": assert not part[1] and not part[2], 'invalid /tags request' for tag in await get_trending_tags(context): state['tag_idx']['trending'].append(tag['name']) state['tags'][tag['name']] = tag elif part[0] in CONDENSER_NOOP_URLS: assert not part[1] and not part[2] else: raise ApiError('unhandled path: /%s' % path) return state