summaryrefslogtreecommitdiff
path: root/src/api/endpoints/aggregation
diff options
context:
space:
mode:
authorAkihiko Odaki <nekomanma@pixiv.co.jp>2018-03-29 01:20:40 +0900
committerAkihiko Odaki <nekomanma@pixiv.co.jp>2018-03-29 01:54:41 +0900
commit90f8fe7e538bb7e52d2558152a0390e693f39b11 (patch)
tree0f830887053c8f352b1cd0c13ca715fd14c1f030 /src/api/endpoints/aggregation
parentImplement remote account resolution (diff)
downloadsharkey-90f8fe7e538bb7e52d2558152a0390e693f39b11.tar.gz
sharkey-90f8fe7e538bb7e52d2558152a0390e693f39b11.tar.bz2
sharkey-90f8fe7e538bb7e52d2558152a0390e693f39b11.zip
Introduce processor
Diffstat (limited to 'src/api/endpoints/aggregation')
-rw-r--r--src/api/endpoints/aggregation/posts.ts90
-rw-r--r--src/api/endpoints/aggregation/posts/reaction.ts76
-rw-r--r--src/api/endpoints/aggregation/posts/reactions.ts72
-rw-r--r--src/api/endpoints/aggregation/posts/reply.ts75
-rw-r--r--src/api/endpoints/aggregation/posts/repost.ts75
-rw-r--r--src/api/endpoints/aggregation/users.ts61
-rw-r--r--src/api/endpoints/aggregation/users/activity.ts116
-rw-r--r--src/api/endpoints/aggregation/users/followers.ts74
-rw-r--r--src/api/endpoints/aggregation/users/following.ts73
-rw-r--r--src/api/endpoints/aggregation/users/post.ts110
-rw-r--r--src/api/endpoints/aggregation/users/reaction.ts80
11 files changed, 0 insertions, 902 deletions
diff --git a/src/api/endpoints/aggregation/posts.ts b/src/api/endpoints/aggregation/posts.ts
deleted file mode 100644
index 9d8bccbdb2..0000000000
--- a/src/api/endpoints/aggregation/posts.ts
+++ /dev/null
@@ -1,90 +0,0 @@
-/**
- * Module dependencies
- */
-import $ from 'cafy';
-import Post from '../../models/post';
-
-/**
- * Aggregate posts
- *
- * @param {any} params
- * @return {Promise<any>}
- */
-module.exports = params => new Promise(async (res, rej) => {
- // Get 'limit' parameter
- const [limit = 365, limitErr] = $(params.limit).optional.number().range(1, 365).$;
- if (limitErr) return rej('invalid limit param');
-
- const datas = await Post
- .aggregate([
- { $project: {
- repost_id: '$repost_id',
- reply_id: '$reply_id',
- created_at: { $add: ['$created_at', 9 * 60 * 60 * 1000] } // Convert into JST
- }},
- { $project: {
- date: {
- year: { $year: '$created_at' },
- month: { $month: '$created_at' },
- day: { $dayOfMonth: '$created_at' }
- },
- type: {
- $cond: {
- if: { $ne: ['$repost_id', null] },
- then: 'repost',
- else: {
- $cond: {
- if: { $ne: ['$reply_id', null] },
- then: 'reply',
- else: 'post'
- }
- }
- }
- }}
- },
- { $group: { _id: {
- date: '$date',
- type: '$type'
- }, count: { $sum: 1 } } },
- { $group: {
- _id: '$_id.date',
- data: { $addToSet: {
- type: '$_id.type',
- count: '$count'
- }}
- } }
- ]);
-
- datas.forEach(data => {
- data.date = data._id;
- delete data._id;
-
- data.posts = (data.data.filter(x => x.type == 'post')[0] || { count: 0 }).count;
- data.reposts = (data.data.filter(x => x.type == 'repost')[0] || { count: 0 }).count;
- data.replies = (data.data.filter(x => x.type == 'reply')[0] || { count: 0 }).count;
-
- delete data.data;
- });
-
- const graph = [];
-
- for (let i = 0; i < limit; i++) {
- const day = new Date(new Date().setDate(new Date().getDate() - i));
-
- const data = datas.filter(d =>
- d.date.year == day.getFullYear() && d.date.month == day.getMonth() + 1 && d.date.day == day.getDate()
- )[0];
-
- if (data) {
- graph.push(data);
- } else {
- graph.push({
- posts: 0,
- reposts: 0,
- replies: 0
- });
- }
- }
-
- res(graph);
-});
diff --git a/src/api/endpoints/aggregation/posts/reaction.ts b/src/api/endpoints/aggregation/posts/reaction.ts
deleted file mode 100644
index eb99b9d088..0000000000
--- a/src/api/endpoints/aggregation/posts/reaction.ts
+++ /dev/null
@@ -1,76 +0,0 @@
-/**
- * Module dependencies
- */
-import $ from 'cafy';
-import Post from '../../../models/post';
-import Reaction from '../../../models/post-reaction';
-
-/**
- * Aggregate reaction of a post
- *
- * @param {any} params
- * @return {Promise<any>}
- */
-module.exports = (params) => new Promise(async (res, rej) => {
- // Get 'post_id' parameter
- const [postId, postIdErr] = $(params.post_id).id().$;
- if (postIdErr) return rej('invalid post_id param');
-
- // Lookup post
- const post = await Post.findOne({
- _id: postId
- });
-
- if (post === null) {
- return rej('post not found');
- }
-
- const datas = await Reaction
- .aggregate([
- { $match: { post_id: post._id } },
- { $project: {
- created_at: { $add: ['$created_at', 9 * 60 * 60 * 1000] } // Convert into JST
- }},
- { $project: {
- date: {
- year: { $year: '$created_at' },
- month: { $month: '$created_at' },
- day: { $dayOfMonth: '$created_at' }
- }
- }},
- { $group: {
- _id: '$date',
- count: { $sum: 1 }
- }}
- ]);
-
- datas.forEach(data => {
- data.date = data._id;
- delete data._id;
- });
-
- const graph = [];
-
- for (let i = 0; i < 30; i++) {
- const day = new Date(new Date().setDate(new Date().getDate() - i));
-
- const data = datas.filter(d =>
- d.date.year == day.getFullYear() && d.date.month == day.getMonth() + 1 && d.date.day == day.getDate()
- )[0];
-
- if (data) {
- graph.push(data);
- } else {
- graph.push({
- date: {
- year: day.getFullYear(),
- month: day.getMonth() + 1, // In JavaScript, month is zero-based.
- day: day.getDate()
- },
- count: 0
- });
- }
- }
-
- res(graph);
-});
diff --git a/src/api/endpoints/aggregation/posts/reactions.ts b/src/api/endpoints/aggregation/posts/reactions.ts
deleted file mode 100644
index 790b523be9..0000000000
--- a/src/api/endpoints/aggregation/posts/reactions.ts
+++ /dev/null
@@ -1,72 +0,0 @@
-/**
- * Module dependencies
- */
-import $ from 'cafy';
-import Post from '../../../models/post';
-import Reaction from '../../../models/post-reaction';
-
-/**
- * Aggregate reactions of a post
- *
- * @param {any} params
- * @return {Promise<any>}
- */
-module.exports = (params) => new Promise(async (res, rej) => {
- // Get 'post_id' parameter
- const [postId, postIdErr] = $(params.post_id).id().$;
- if (postIdErr) return rej('invalid post_id param');
-
- // Lookup post
- const post = await Post.findOne({
- _id: postId
- });
-
- if (post === null) {
- return rej('post not found');
- }
-
- const startTime = new Date(new Date().setMonth(new Date().getMonth() - 1));
-
- const reactions = await Reaction
- .find({
- post_id: post._id,
- $or: [
- { deleted_at: { $exists: false } },
- { deleted_at: { $gt: startTime } }
- ]
- }, {
- sort: {
- _id: -1
- },
- fields: {
- _id: false,
- post_id: false
- }
- });
-
- const graph = [];
-
- for (let i = 0; i < 30; i++) {
- let day = new Date(new Date().setDate(new Date().getDate() - i));
- day = new Date(day.setMilliseconds(999));
- day = new Date(day.setSeconds(59));
- day = new Date(day.setMinutes(59));
- day = new Date(day.setHours(23));
- // day = day.getTime();
-
- const count = reactions.filter(r =>
- r.created_at < day && (r.deleted_at == null || r.deleted_at > day)
- ).length;
-
- graph.push({
- date: {
- year: day.getFullYear(),
- month: day.getMonth() + 1, // In JavaScript, month is zero-based.
- day: day.getDate()
- },
- count: count
- });
- }
-
- res(graph);
-});
diff --git a/src/api/endpoints/aggregation/posts/reply.ts b/src/api/endpoints/aggregation/posts/reply.ts
deleted file mode 100644
index b114c34e1e..0000000000
--- a/src/api/endpoints/aggregation/posts/reply.ts
+++ /dev/null
@@ -1,75 +0,0 @@
-/**
- * Module dependencies
- */
-import $ from 'cafy';
-import Post from '../../../models/post';
-
-/**
- * Aggregate reply of a post
- *
- * @param {any} params
- * @return {Promise<any>}
- */
-module.exports = (params) => new Promise(async (res, rej) => {
- // Get 'post_id' parameter
- const [postId, postIdErr] = $(params.post_id).id().$;
- if (postIdErr) return rej('invalid post_id param');
-
- // Lookup post
- const post = await Post.findOne({
- _id: postId
- });
-
- if (post === null) {
- return rej('post not found');
- }
-
- const datas = await Post
- .aggregate([
- { $match: { reply: post._id } },
- { $project: {
- created_at: { $add: ['$created_at', 9 * 60 * 60 * 1000] } // Convert into JST
- }},
- { $project: {
- date: {
- year: { $year: '$created_at' },
- month: { $month: '$created_at' },
- day: { $dayOfMonth: '$created_at' }
- }
- }},
- { $group: {
- _id: '$date',
- count: { $sum: 1 }
- }}
- ]);
-
- datas.forEach(data => {
- data.date = data._id;
- delete data._id;
- });
-
- const graph = [];
-
- for (let i = 0; i < 30; i++) {
- const day = new Date(new Date().setDate(new Date().getDate() - i));
-
- const data = datas.filter(d =>
- d.date.year == day.getFullYear() && d.date.month == day.getMonth() + 1 && d.date.day == day.getDate()
- )[0];
-
- if (data) {
- graph.push(data);
- } else {
- graph.push({
- date: {
- year: day.getFullYear(),
- month: day.getMonth() + 1, // In JavaScript, month is zero-based.
- day: day.getDate()
- },
- count: 0
- });
- }
- }
-
- res(graph);
-});
diff --git a/src/api/endpoints/aggregation/posts/repost.ts b/src/api/endpoints/aggregation/posts/repost.ts
deleted file mode 100644
index 217159caa7..0000000000
--- a/src/api/endpoints/aggregation/posts/repost.ts
+++ /dev/null
@@ -1,75 +0,0 @@
-/**
- * Module dependencies
- */
-import $ from 'cafy';
-import Post from '../../../models/post';
-
-/**
- * Aggregate repost of a post
- *
- * @param {any} params
- * @return {Promise<any>}
- */
-module.exports = (params) => new Promise(async (res, rej) => {
- // Get 'post_id' parameter
- const [postId, postIdErr] = $(params.post_id).id().$;
- if (postIdErr) return rej('invalid post_id param');
-
- // Lookup post
- const post = await Post.findOne({
- _id: postId
- });
-
- if (post === null) {
- return rej('post not found');
- }
-
- const datas = await Post
- .aggregate([
- { $match: { repost_id: post._id } },
- { $project: {
- created_at: { $add: ['$created_at', 9 * 60 * 60 * 1000] } // Convert into JST
- }},
- { $project: {
- date: {
- year: { $year: '$created_at' },
- month: { $month: '$created_at' },
- day: { $dayOfMonth: '$created_at' }
- }
- }},
- { $group: {
- _id: '$date',
- count: { $sum: 1 }
- }}
- ]);
-
- datas.forEach(data => {
- data.date = data._id;
- delete data._id;
- });
-
- const graph = [];
-
- for (let i = 0; i < 30; i++) {
- const day = new Date(new Date().setDate(new Date().getDate() - i));
-
- const data = datas.filter(d =>
- d.date.year == day.getFullYear() && d.date.month == day.getMonth() + 1 && d.date.day == day.getDate()
- )[0];
-
- if (data) {
- graph.push(data);
- } else {
- graph.push({
- date: {
- year: day.getFullYear(),
- month: day.getMonth() + 1, // In JavaScript, month is zero-based.
- day: day.getDate()
- },
- count: 0
- });
- }
- }
-
- res(graph);
-});
diff --git a/src/api/endpoints/aggregation/users.ts b/src/api/endpoints/aggregation/users.ts
deleted file mode 100644
index e38ce92ff9..0000000000
--- a/src/api/endpoints/aggregation/users.ts
+++ /dev/null
@@ -1,61 +0,0 @@
-/**
- * Module dependencies
- */
-import $ from 'cafy';
-import User from '../../models/user';
-
-/**
- * Aggregate users
- *
- * @param {any} params
- * @return {Promise<any>}
- */
-module.exports = params => new Promise(async (res, rej) => {
- // Get 'limit' parameter
- const [limit = 365, limitErr] = $(params.limit).optional.number().range(1, 365).$;
- if (limitErr) return rej('invalid limit param');
-
- const users = await User
- .find({}, {
- sort: {
- _id: -1
- },
- fields: {
- _id: false,
- created_at: true,
- deleted_at: true
- }
- });
-
- const graph = [];
-
- for (let i = 0; i < limit; i++) {
- let dayStart = new Date(new Date().setDate(new Date().getDate() - i));
- dayStart = new Date(dayStart.setMilliseconds(0));
- dayStart = new Date(dayStart.setSeconds(0));
- dayStart = new Date(dayStart.setMinutes(0));
- dayStart = new Date(dayStart.setHours(0));
-
- let dayEnd = new Date(new Date().setDate(new Date().getDate() - i));
- dayEnd = new Date(dayEnd.setMilliseconds(999));
- dayEnd = new Date(dayEnd.setSeconds(59));
- dayEnd = new Date(dayEnd.setMinutes(59));
- dayEnd = new Date(dayEnd.setHours(23));
- // day = day.getTime();
-
- const total = users.filter(u =>
- u.created_at < dayEnd && (u.deleted_at == null || u.deleted_at > dayEnd)
- ).length;
-
- const created = users.filter(u =>
- u.created_at < dayEnd && u.created_at > dayStart
- ).length;
-
- graph.push({
- total: total,
- created: created
- });
- }
-
- res(graph);
-});
diff --git a/src/api/endpoints/aggregation/users/activity.ts b/src/api/endpoints/aggregation/users/activity.ts
deleted file mode 100644
index 102a71d7cb..0000000000
--- a/src/api/endpoints/aggregation/users/activity.ts
+++ /dev/null
@@ -1,116 +0,0 @@
-/**
- * Module dependencies
- */
-import $ from 'cafy';
-import User from '../../../models/user';
-import Post from '../../../models/post';
-
-// TODO: likeやfollowも集計
-
-/**
- * Aggregate activity of a user
- *
- * @param {any} params
- * @return {Promise<any>}
- */
-module.exports = (params) => new Promise(async (res, rej) => {
- // Get 'limit' parameter
- const [limit = 365, limitErr] = $(params.limit).optional.number().range(1, 365).$;
- if (limitErr) return rej('invalid limit param');
-
- // Get 'user_id' parameter
- const [userId, userIdErr] = $(params.user_id).id().$;
- if (userIdErr) return rej('invalid user_id param');
-
- // Lookup user
- const user = await User.findOne({
- _id: userId
- }, {
- fields: {
- _id: true
- }
- });
-
- if (user === null) {
- return rej('user not found');
- }
-
- const datas = await Post
- .aggregate([
- { $match: { user_id: user._id } },
- { $project: {
- repost_id: '$repost_id',
- reply_id: '$reply_id',
- created_at: { $add: ['$created_at', 9 * 60 * 60 * 1000] } // Convert into JST
- }},
- { $project: {
- date: {
- year: { $year: '$created_at' },
- month: { $month: '$created_at' },
- day: { $dayOfMonth: '$created_at' }
- },
- type: {
- $cond: {
- if: { $ne: ['$repost_id', null] },
- then: 'repost',
- else: {
- $cond: {
- if: { $ne: ['$reply_id', null] },
- then: 'reply',
- else: 'post'
- }
- }
- }
- }}
- },
- { $group: { _id: {
- date: '$date',
- type: '$type'
- }, count: { $sum: 1 } } },
- { $group: {
- _id: '$_id.date',
- data: { $addToSet: {
- type: '$_id.type',
- count: '$count'
- }}
- } }
- ]);
-
- datas.forEach(data => {
- data.date = data._id;
- delete data._id;
-
- data.posts = (data.data.filter(x => x.type == 'post')[0] || { count: 0 }).count;
- data.reposts = (data.data.filter(x => x.type == 'repost')[0] || { count: 0 }).count;
- data.replies = (data.data.filter(x => x.type == 'reply')[0] || { count: 0 }).count;
-
- delete data.data;
- });
-
- const graph = [];
-
- for (let i = 0; i < limit; i++) {
- const day = new Date(new Date().setDate(new Date().getDate() - i));
-
- const data = datas.filter(d =>
- d.date.year == day.getFullYear() && d.date.month == day.getMonth() + 1 && d.date.day == day.getDate()
- )[0];
-
- if (data) {
- graph.push(data);
- } else {
- graph.push({
- date: {
- year: day.getFullYear(),
- month: day.getMonth() + 1, // In JavaScript, month is zero-based.
- day: day.getDate()
- },
- posts: 0,
- reposts: 0,
- replies: 0
- });
- }
- }
-
- res(graph);
-});
diff --git a/src/api/endpoints/aggregation/users/followers.ts b/src/api/endpoints/aggregation/users/followers.ts
deleted file mode 100644
index 3022b2b002..0000000000
--- a/src/api/endpoints/aggregation/users/followers.ts
+++ /dev/null
@@ -1,74 +0,0 @@
-/**
- * Module dependencies
- */
-import $ from 'cafy';
-import User from '../../../models/user';
-import Following from '../../../models/following';
-
-/**
- * Aggregate followers of a user
- *
- * @param {any} params
- * @return {Promise<any>}
- */
-module.exports = (params) => new Promise(async (res, rej) => {
- // Get 'user_id' parameter
- const [userId, userIdErr] = $(params.user_id).id().$;
- if (userIdErr) return rej('invalid user_id param');
-
- // Lookup user
- const user = await User.findOne({
- _id: userId
- }, {
- fields: {
- _id: true
- }
- });
-
- if (user === null) {
- return rej('user not found');
- }
-
- const startTime = new Date(new Date().setMonth(new Date().getMonth() - 1));
-
- const following = await Following
- .find({
- followee_id: user._id,
- $or: [
- { deleted_at: { $exists: false } },
- { deleted_at: { $gt: startTime } }
- ]
- }, {
- _id: false,
- follower_id: false,
- followee_id: false
- }, {
- sort: { created_at: -1 }
- });
-
- const graph = [];
-
- for (let i = 0; i < 30; i++) {
- let day = new Date(new Date().setDate(new Date().getDate() - i));
- day = new Date(day.setMilliseconds(999));
- day = new Date(day.setSeconds(59));
- day = new Date(day.setMinutes(59));
- day = new Date(day.setHours(23));
- // day = day.getTime();
-
- const count = following.filter(f =>
- f.created_at < day && (f.deleted_at == null || f.deleted_at > day)
- ).length;
-
- graph.push({
- date: {
- year: day.getFullYear(),
- month: day.getMonth() + 1, // In JavaScript, month is zero-based.
- day: day.getDate()
- },
- count: count
- });
- }
-
- res(graph);
-});
diff --git a/src/api/endpoints/aggregation/users/following.ts b/src/api/endpoints/aggregation/users/following.ts
deleted file mode 100644
index 92da7e6921..0000000000
--- a/src/api/endpoints/aggregation/users/following.ts
+++ /dev/null
@@ -1,73 +0,0 @@
-/**
- * Module dependencies
- */
-import $ from 'cafy';
-import User from '../../../models/user';
-import Following from '../../../models/following';
-
-/**
- * Aggregate following of a user
- *
- * @param {any} params
- * @return {Promise<any>}
- */
-module.exports = (params) => new Promise(async (res, rej) => {
- // Get 'user_id' parameter
- const [userId, userIdErr] = $(params.user_id).id().$;
- if (userIdErr) return rej('invalid user_id param');
-
- // Lookup user
- const user = await User.findOne({
- _id: userId
- }, {
- fields: {
- _id: true
- }
- });
-
- if (user === null) {
- return rej('user not found');
- }
-
- const startTime = new Date(new Date().setMonth(new Date().getMonth() - 1));
-
- const following = await Following
- .find({
- follower_id: user._id,
- $or: [
- { deleted_at: { $exists: false } },
- { deleted_at: { $gt: startTime } }
- ]
- }, {
- _id: false,
- follower_id: false,
- followee_id: false
- }, {
- sort: { created_at: -1 }
- });
-
- const graph = [];
-
- for (let i = 0; i < 30; i++) {
- let day = new Date(new Date().setDate(new Date().getDate() - i));
- day = new Date(day.setMilliseconds(999));
- day = new Date(day.setSeconds(59));
- day = new Date(day.setMinutes(59));
- day = new Date(day.setHours(23));
-
- const count = following.filter(f =>
- f.created_at < day && (f.deleted_at == null || f.deleted_at > day)
- ).length;
-
- graph.push({
- date: {
- year: day.getFullYear(),
- month: day.getMonth() + 1, // In JavaScript, month is zero-based.
- day: day.getDate()
- },
- count: count
- });
- }
-
- res(graph);
-});
diff --git a/src/api/endpoints/aggregation/users/post.ts b/src/api/endpoints/aggregation/users/post.ts
deleted file mode 100644
index c6a75eee39..0000000000
--- a/src/api/endpoints/aggregation/users/post.ts
+++ /dev/null
@@ -1,110 +0,0 @@
-/**
- * Module dependencies
- */
-import $ from 'cafy';
-import User from '../../../models/user';
-import Post from '../../../models/post';
-
-/**
- * Aggregate post of a user
- *
- * @param {any} params
- * @return {Promise<any>}
- */
-module.exports = (params) => new Promise(async (res, rej) => {
- // Get 'user_id' parameter
- const [userId, userIdErr] = $(params.user_id).id().$;
- if (userIdErr) return rej('invalid user_id param');
-
- // Lookup user
- const user = await User.findOne({
- _id: userId
- }, {
- fields: {
- _id: true
- }
- });
-
- if (user === null) {
- return rej('user not found');
- }
-
- const datas = await Post
- .aggregate([
- { $match: { user_id: user._id } },
- { $project: {
- repost_id: '$repost_id',
- reply_id: '$reply_id',
- created_at: { $add: ['$created_at', 9 * 60 * 60 * 1000] } // Convert into JST
- }},
- { $project: {
- date: {
- year: { $year: '$created_at' },
- month: { $month: '$created_at' },
- day: { $dayOfMonth: '$created_at' }
- },
- type: {
- $cond: {
- if: { $ne: ['$repost_id', null] },
- then: 'repost',
- else: {
- $cond: {
- if: { $ne: ['$reply_id', null] },
- then: 'reply',
- else: 'post'
- }
- }
- }
- }}
- },
- { $group: { _id: {
- date: '$date',
- type: '$type'
- }, count: { $sum: 1 } } },
- { $group: {
- _id: '$_id.date',
- data: { $addToSet: {
- type: '$_id.type',
- count: '$count'
- }}
- } }
- ]);
-
- datas.forEach(data => {
- data.date = data._id;
- delete data._id;
-
- data.posts = (data.data.filter(x => x.type == 'post')[0] || { count: 0 }).count;
- data.reposts = (data.data.filter(x => x.type == 'repost')[0] || { count: 0 }).count;
- data.replies = (data.data.filter(x => x.type == 'reply')[0] || { count: 0 }).count;
-
- delete data.data;
- });
-
- const graph = [];
-
- for (let i = 0; i < 30; i++) {
- const day = new Date(new Date().setDate(new Date().getDate() - i));
-
- const data = datas.filter(d =>
- d.date.year == day.getFullYear() && d.date.month == day.getMonth() + 1 && d.date.day == day.getDate()
- )[0];
-
- if (data) {
- graph.push(data);
- } else {
- graph.push({
- date: {
- year: day.getFullYear(),
- month: day.getMonth() + 1, // In JavaScript, month is zero-based.
- day: day.getDate()
- },
- posts: 0,
- reposts: 0,
- replies: 0
- });
- }
- }
-
- res(graph);
-});
diff --git a/src/api/endpoints/aggregation/users/reaction.ts b/src/api/endpoints/aggregation/users/reaction.ts
deleted file mode 100644
index 0a082ed1b7..0000000000
--- a/src/api/endpoints/aggregation/users/reaction.ts
+++ /dev/null
@@ -1,80 +0,0 @@
-/**
- * Module dependencies
- */
-import $ from 'cafy';
-import User from '../../../models/user';
-import Reaction from '../../../models/post-reaction';
-
-/**
- * Aggregate reaction of a user
- *
- * @param {any} params
- * @return {Promise<any>}
- */
-module.exports = (params) => new Promise(async (res, rej) => {
- // Get 'user_id' parameter
- const [userId, userIdErr] = $(params.user_id).id().$;
- if (userIdErr) return rej('invalid user_id param');
-
- // Lookup user
- const user = await User.findOne({
- _id: userId
- }, {
- fields: {
- _id: true
- }
- });
-
- if (user === null) {
- return rej('user not found');
- }
-
- const datas = await Reaction
- .aggregate([
- { $match: { user_id: user._id } },
- { $project: {
- created_at: { $add: ['$created_at', 9 * 60 * 60 * 1000] } // Convert into JST
- }},
- { $project: {
- date: {
- year: { $year: '$created_at' },
- month: { $month: '$created_at' },
- day: { $dayOfMonth: '$created_at' }
- }
- }},
- { $group: {
- _id: '$date',
- count: { $sum: 1 }
- }}
- ]);
-
- datas.forEach(data => {
- data.date = data._id;
- delete data._id;
- });
-
- const graph = [];
-
- for (let i = 0; i < 30; i++) {
- const day = new Date(new Date().setDate(new Date().getDate() - i));
-
- const data = datas.filter(d =>
- d.date.year == day.getFullYear() && d.date.month == day.getMonth() + 1 && d.date.day == day.getDate()
- )[0];
-
- if (data) {
- graph.push(data);
- } else {
- graph.push({
- date: {
- year: day.getFullYear(),
- month: day.getMonth() + 1, // In JavaScript, month is zero-based.
- day: day.getDate()
- },
- count: 0
- });
- }
- }
-
- res(graph);
-});