// Don't use sequelize because we need to use a sub query
const query = UserModel.generateUserQuotaBaseSQL({
withSelect: true,
- whereUserId: '$userId'
+ whereUserId: '$userId',
+ daily: false
})
const base = await UserModel.getTotalRawQuery(query, user.id)
const query = UserModel.generateUserQuotaBaseSQL({
withSelect: true,
whereUserId: '$userId',
- where: '"video"."createdAt" > now() - interval \'24 hours\''
+ daily: true
})
const base = await UserModel.getTotalRawQuery(query, user.id)
abuseStateChange: UserNotificationSettingValue.WEB | UserNotificationSettingValue.EMAIL,
autoInstanceFollowing: UserNotificationSettingValue.WEB,
newPeerTubeVersion: UserNotificationSettingValue.WEB | UserNotificationSettingValue.EMAIL,
- newPluginVersion: UserNotificationSettingValue.WEB
+ newPluginVersion: UserNotificationSettingValue.WEB,
+ myVideoStudioEditionFinished: UserNotificationSettingValue.WEB
}
return UserNotificationSettingModel.create(values, { transaction: t })