Method getGuild

src/database/sqlite.ts:247–297

(query: string)

  }

  async getGuild(query: string): Promise<DBGuild> {
    // SQLite does not support arrays, so instead we convert them from strings
    let guild:
      | ({
          disabled: string;
          disabled_commands: string;
          tag_roles: string;
        } & Omit<DBGuild, "disabled" | "disabled_commands" | "tag_roles">)
      | undefined;
    try {
      this.connection.exec("BEGIN TRANSACTION");
      guild = this.connection.prepare("SELECT * FROM guilds WHERE guild_id = ?").get(query) as {
        disabled: string;
        disabled_commands: string;
        tag_roles: string;
      } & Omit<DBGuild, "disabled" | "disabled_commands" | "tag_roles">;
      if (!guild) {
        const guild_id = query;
        const prefix = process.env.PREFIX ?? "&";
        guild = {
          guild_id,
          prefix,
          disabled: "[]",
          disabled_commands: "[]",
          tag_roles: "[]",
        };
        this.connection
          .prepare(
            "INSERT INTO guilds (guild_id, prefix, disabled, disabled_commands, tag_roles) VALUES (:guild_id, :prefix, :disabled, :disabled_commands, :tag_roles)",
          )
          .run(guild);
      }
      this.connection.exec("COMMIT");
    } catch {
      this.connection.exec("ROLLBACK");
    }
    if (guild) {
      guild.disabled = JSON.parse(guild.disabled);
      guild.disabled_commands = JSON.parse(guild.disabled_commands);
      guild.tag_roles = JSON.parse(guild.tag_roles);
    }
    return (
      (guild as DBGuild | undefined) ?? {
        guild_id: query,
        prefix: process.env.PREFIX ?? "&",
        disabled: [],
        disabled_commands: [],
        tag_roles: [],
      }
    );
  }
}