Skip to content
Snippets Groups Projects

Mock blocks with reblog operations

Merged Mariusz Trela requested to merge mt-mock-reblogs into develop
All threads resolved!
5 files
+ 29
30
Compare changes
  • Side-by-side
  • Inline
Files
5
DROP FUNCTION IF EXISTS delete_reblog_feed_cache(character varying,character varying,character varying, BOOLEAN)
DROP FUNCTION IF EXISTS delete_reblog_feed_cache(character varying,character varying,character varying)
;
CREATE OR REPLACE FUNCTION delete_reblog_feed_cache(
in _author hive_accounts.name%TYPE,
in _permlink hive_permlink_data.permlink%TYPE,
in _account hive_accounts.name%TYPE,
in _delete_feed_cache BOOLEAN)
in _account hive_accounts.name%TYPE)
RETURNS INTEGER
LANGUAGE plpgsql
AS
@@ -26,10 +25,8 @@ BEGIN
DELETE FROM hive_reblogs
WHERE blogger_id = __account_id AND post_id = __post_id;
IF _delete_feed_cache THEN
DELETE FROM hive_feed_cache
WHERE account_id = __account_id AND post_id = __post_id;
END IF;
DELETE FROM hive_feed_cache
WHERE account_id = __account_id AND post_id = __post_id;
RETURN 1;
END
Loading