Community type 2 and 3 + update community type op

feature set

This feature enables the new community types as defined in the original doc:

• type 1: Topic: anyone can post or comment
• type 2: Journal: guests can comment but not post. only members can post.
• type 3: Council: only members can post or comment

test cases

for all tests, the account ismember will be a member of all the communities and notmember won't be.

• create a community type 1 hive-111119
• create a community type 2 hive-211119
• create a community type 3 hive-311119
• Community type 1 tests
• • post in community type 1 from member => not muted
• • post in community type 1 from non member => not muted
• • comment in community type 1 from member => not muted
• • comment in community type 1 from non member => not muted
• • comment in community type 1 from member at depth 2 => not muted
• Community type 2 tests
• • post in community type 2 from member => not muted
• • post in community type 2 from non member => muted
• • comment in community type 2 from member => not muted
• • comment in community type 2 from non member => not muted
• • comment in community type 2 from member at depth 2 => not muted
• Community type 3 tests
• • post in community type 3 from member => not muted
• • post in community type 3 from non member => muted
• • comment in community type 3 from member => not muted
• • comment in community type 3 from non member => muted
• • comment in community type 3 from member at depth 2 => not muted
• Change community type 1 to community type 3
• • change ismember to a mod (to validate that rules apply to roles above member and not just to member)
• • post in community type 3 from member => not muted
• • post in community type 3 from non member => muted
• • comment in community type 3 from member => not muted
• • comment in community type 3 from non member => muted

hive/db/sql_scripts/hive_post_operations.sql

@@ -47,7 +47,7 @@ BEGIN
             __community_id := NULL;
         ELSE
             IF is_comment = TRUE THEN
-                SELECT hc.type_id, hc.id INTO __community_type_id, __community_id
+                SELECT hc.type_id, hc.id, hivemind_app.hive_posts.is_muted INTO __community_type_id, __community_id, __is_muted
                 FROM hivemind_app.hive_permlink_data
                     JOIN hivemind_app.hive_posts ON hivemind_app.hive_permlink_data.id = hivemind_app.hive_posts.permlink_id
                     JOIN hivemind_app.hive_communities hc ON hivemind_app.hive_posts.community_id = hc.id
@@ -56,7 +56,8 @@ BEGIN
                 SELECT type_id, id INTO __community_type_id, __community_id from hivemind_app.hive_communities where name = _parent_permlink;
             END IF;
 
-            IF __community_id IS NOT NULL THEN
+            -- __is_muted can be TRUE here if it's a comment and its parent is muted
+            IF __community_id IS NOT NULL AND __is_muted = FALSE THEN
                 IF __community_type_id = __community_type_topic THEN
                     __is_muted := FALSE;
                 ELSE