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
