Showing community count on main sidebar

- Fixes #232

2 files changed, 19 insertions, 0 deletions

diff --git a/server/migrations/2019-08-29-040006_add_community_count/down.sql b/server/migrations/2019-08-29-040006_add_community_count/down.sql
new file mode 100644
index 00000000..6302f267
--- /dev/null
+++ b/server/migrations/2019-08-29-040006_add_community_count/down.sql
@@ -0,0 +1,9 @@
+drop view site_view;
+
+create view site_view as 
+select *,
+(select name from user_ u where s.creator_id = u.id) as creator_name,
+(select count(*) from user_) as number_of_users,
+(select count(*) from post) as number_of_posts,
+(select count(*) from comment) as number_of_comments
+from site s;
diff --git a/server/migrations/2019-08-29-040006_add_community_count/up.sql b/server/migrations/2019-08-29-040006_add_community_count/up.sql
new file mode 100644
index 00000000..0ec1c9c3
--- /dev/null
+++ b/server/migrations/2019-08-29-040006_add_community_count/up.sql
@@ -0,0 +1,10 @@
+drop view site_view;
+
+create view site_view as 
+select *,
+(select name from user_ u where s.creator_id = u.id) as creator_name,
+(select count(*) from user_) as number_of_users,
+(select count(*) from post) as number_of_posts,
+(select count(*) from comment) as number_of_comments,
+(select count(*) from community) as number_of_communities
+from site s;