diff options
Diffstat (limited to 'vnext/server/db/Users.js')
-rw-r--r-- | vnext/server/db/Users.js | 27 |
1 files changed, 27 insertions, 0 deletions
diff --git a/vnext/server/db/Users.js b/vnext/server/db/Users.js new file mode 100644 index 00000000..3db3eb5b --- /dev/null +++ b/vnext/server/db/Users.js @@ -0,0 +1,27 @@ +import { DataTypes, Op } from 'sequelize' +import db from './index' + +export const User = db.define('user', { + id: { + type: DataTypes.INTEGER, + primaryKey: true + }, + nick: DataTypes.STRING, + banned: DataTypes.INTEGER, + last_seen: DataTypes.DATE +}) + +export const getMonthlyActiveUsers = async () => { + const seenDate = new Date() + seenDate.setMonth(seenDate.getMonth() - 1) + return await User.count({ + where: { + banned: { + [Op.eq]: 0 + }, + last_seen: { + [Op.gt]: seenDate + } + } + }) +} |