Skip to content
GitLab
Explore
Sign in
Register
Primary navigation
Search or go to…
Project
H
hivemind
Manage
Activity
Members
Labels
Plan
Issues
Issue boards
Milestones
Wiki
Code
Merge requests
Repository
Branches
Commits
Tags
Repository graph
Compare revisions
Snippets
Deploy
Releases
Package registry
Container Registry
Model registry
Operate
Terraform modules
Monitor
Incidents
Analyze
Value stream analytics
Contributor analytics
Repository analytics
Model experiments
Help
Help
Support
GitLab documentation
Compare GitLab plans
Community forum
Contribute to GitLab
Provide feedback
Keyboard shortcuts
?
Snippets
Groups
Projects
Show more breadcrumbs
hive
hivemind
Merge requests
!361
Extended mock follow tests
Code
Review changes
Check out branch
Download
Patches
Plain diff
Merged
Extended mock follow tests
dk-mock-follow-tests
into
develop
Overview
2
Commits
12
Pipelines
0
Changes
5
All threads resolved!
Hide all comments
Merged
Dariusz Kędzierski
requested to merge
dk-mock-follow-tests
into
develop
4 years ago
Overview
2
Commits
12
Pipelines
0
Changes
23
All threads resolved!
Hide all comments
Expand
0
0
Merge request reports
Compare
version 4
version 10
60f447f8
4 years ago
version 9
dfcb745b
4 years ago
version 8
c5d18310
4 years ago
version 7
04a63132
4 years ago
version 6
1d4aadeb
4 years ago
version 5
1eb11edd
4 years ago
version 4
af692748
4 years ago
version 3
614f01fe
4 years ago
version 2
479f6a64
4 years ago
version 1
9279b29c
4 years ago
develop (base)
and
version 6
latest version
d5b76441
12 commits,
4 years ago
version 10
60f447f8
11 commits,
4 years ago
version 9
dfcb745b
10 commits,
4 years ago
version 8
c5d18310
9 commits,
4 years ago
version 7
04a63132
8 commits,
4 years ago
version 6
1d4aadeb
7 commits,
4 years ago
version 5
1eb11edd
6 commits,
4 years ago
version 4
af692748
5 commits,
4 years ago
version 3
614f01fe
4 commits,
4 years ago
version 2
479f6a64
3 commits,
4 years ago
version 1
9279b29c
2 commits,
4 years ago
Show latest version
23 files
+
210
−
824
Inline
Compare changes
Side-by-side
Inline
Show whitespace changes
Show one file at a time
Files
23
Search (e.g. *.vue) (Ctrl+P)
hive/db/sql_scripts/bridge_get_ranked_post_for_all.sql
+
3
−
2
Options
@@ -270,7 +270,7 @@ $function$
language
plpgsql
STABLE
;
DROP
FUNCTION
IF
EXISTS
bridge_get_ranked_post_by_payout
;
CREATE
FUNCTION
bridge_get_ranked_post_by_payout
(
in
_author
VARCHAR
,
in
_permlink
VARCHAR
,
in
_limit
SMALLINT
)
CREATE
FUNCTION
bridge_get_ranked_post_by_payout
(
in
_author
VARCHAR
,
in
_permlink
VARCHAR
,
in
_limit
SMALLINT
,
in
_bridge_api
BOOLEAN
)
RETURNS
SETOF
bridge_api_post
AS
$
function
$
@@ -328,7 +328,8 @@ BEGIN
,
(
hp1
.
payout
+
hp1
.
pending_payout
)
as
all_payout
FROM
hive_posts
hp1
WHERE
hp1
.
counter_deleted
=
0
AND
NOT
hp1
.
is_paidout
AND
hp1
.
payout_at
BETWEEN
__head_block_time
+
interval
'12 hours'
AND
__head_block_time
+
interval
'36 hours'
WHERE
hp1
.
counter_deleted
=
0
AND
NOT
hp1
.
is_paidout
AND
(
(
NOT
_bridge_api
AND
hp1
.
depth
=
0
)
OR
(
_bridge_api
AND
hp1
.
payout_at
BETWEEN
__head_block_time
+
interval
'12 hours'
AND
__head_block_time
+
interval
'36 hours'
)
)
AND
(
__post_id
=
0
OR
(
hp1
.
payout
+
hp1
.
pending_payout
)
<
__payout_limit
OR
(
(
hp1
.
payout
+
hp1
.
pending_payout
)
=
__payout_limit
AND
hp1
.
id
<
__post_id
)
)
ORDER
BY
(
hp1
.
payout
+
hp1
.
pending_payout
)
DESC
,
hp1
.
id
DESC
LIMIT
_limit
Loading