• Index
• Search by APIs
• Search by Words
• Project Search

• Java
• Python
• JavaScript
• TypeScript
• C++
• Scala
• Blog

• CSZ-Bot-master
  • .github
    • ISSUE_TEMPLATE
      • Fehler_Report.md
      • Funktions_Wunsch.md
    • workflows
      • CI.yml
      • CD.yml
      • codestyle.yml
  • src
    • app.ts
    • utils
      • typeUtils.ts
      • stringUtils.ts
      • userUtils.ts
      • configHandler.ts
      • logger.ts
    • storage
      • storage.ts
      • model
        • AdditionalMessageData.ts
        • Penis.ts
        • Reminder.ts
        • Birthday.ts
        • FadingMessage.ts
        • Ban.ts
        • Boob.ts
        • Nickname.ts
        • Stempel.ts
        • GuildRagequit.ts
    • commands
      • info.ts
      • saufen.ts
      • extend.ts
      • ficktabelle.ts
      • boobs.ts
      • roll.ts
      • command.ts
      • stempelgraph.ts
      • vote.js
      • bonk.ts
      • nickname.ts
      • erinnerung.ts
      • poll.js
      • erleuchtung.ts
      • min.ts
      • metafrage.ts
      • sdm.ts
      • never.ts
      • invite.ts
      • hilfe.ts
      • geburtstag.ts
      • special
        • where.ts
        • tiktok.ts
        • dadJoke.ts
        • nixos.ts
        • wat.ts
        • emoteSender.ts
        • nischdaaa.ts
      • stempelkarte.ts
      • mock.ts
      • google.ts
      • stempeln.ts
      • woisping.ts
      • selfban.js
      • penis.ts
      • modcommands
        • ban.ts
        • unban.ts
        • listroles.ts
        • hilfe.ts
        • assigner.ts
    • context.ts
    • types.d.ts
    • handler
      • fadingMessageHandler.ts
      • cmdHandler.ts
      • quoteHandler.ts
      • aprilFoolsHandler.ts
      • aocHandler.ts
      • nicknameHandler.ts
      • commandHandler.ts
      • bdayHandler.ts
      • messageDeleteHandler.ts
      • voiceHandler.ts
      • messageHandler.ts
      • reactionHandler.ts
  • shell.nix
  • .nvmrc
  • .eslintrc.json
  • LICENSE
  • .devcontainer
    • devcontainer.json
  • CONTRIBUTING.md
  • .editorconfig
  • .gitattributes
  • config.template.json
  • flake.nix
  • README.md
  • package.json
  • Dockerfile
  • tsconfig.json
  • .gitignore
  • .dockerignore
  • .vscode
    • settings.json
    • extensions.json
  • docker-compose.yml
  • assets

/* Disabled due to sequelize's DataTypes */
/* eslint-disable new-cap */

import type { User, GuildMember } from "discord.js";
import { Model, DataTypes, Sequelize, Optional, Op } from "sequelize";
import { v4 as uuidv4 } from "uuid";
import log from "../../utils/logger";

export interface BanAttributes {
    id: string;
    userId: string;
    reason: string | null;
    bannedUntil: Date | null;
    isSelfBan: boolean;
}

export interface BanCreationAttributes extends Optional<BanAttributes, "id"> { }

export default class Ban extends Model<BanAttributes, BanCreationAttributes> implements BanAttributes {
    declare id: string;
    declare userId: string;
    declare reason: string | null;
    declare bannedUntil: Date | null;
    declare isSelfBan: boolean;

    declare readonly createdAt: Date;
    declare readonly updatedAt: Date;

    static persistOrUpdate = (user: GuildMember, until: Date | null, isSelfBan: boolean, reason: string | null = null): Promise<void> => {
        log.debug(`Saving Ban for user ${user} until ${until} (Selfban: ${isSelfBan}, Reason: ${reason})`);
        return Ban.upsert({
            userId: user.id,
            reason,
            bannedUntil: until,
            isSelfBan
        }) as Promise<any>;
    };

    static remove = (user: User | GuildMember) => Ban.destroy({ where: { userId: user.id } });

    static findExisting = (user: User | GuildMember) => Ban.findOne({ where: { userId: user.id } });

    static findExpiredBans = (now: Date) => Ban.findAll({
        where: {
            bannedUntil: {
                [Op.ne]: null,
                [Op.lte]: now
            }
        }
    });

    static initialize(sequelize: Sequelize) {
        this.init({
            id: {
                type: DataTypes.STRING(36),
                defaultValue: () => uuidv4(),
                primaryKey: true
            },
            userId: {
                type: DataTypes.STRING(32),
                allowNull: false
            },
            reason: {
                type: DataTypes.STRING(255),
                allowNull: true
            },
            bannedUntil: {
                type: DataTypes.DATE,
                allowNull: true
            },
            isSelfBan: {
                type: DataTypes.BOOLEAN,
                allowNull: false
            }
        }, {
            sequelize,
            indexes: [
                {
                    unique: true,
                    fields: ["userId"]
                },
                {
                    using: "BTREE",
                    fields: [
                        {
                            name: "bannedUntil",
                            order: "ASC"
                        }
                    ]
                }
            ]
        });
    }
}