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
      }
    }
  })
}