exportLinks.js

require('dotenv').config();
const mongoose = require('mongoose');
const { Client, GatewayIntentBits } = require('discord.js');
const fs = require('fs');
const path = require('path');

const RepoLink = require('./models/repoLink');

async function exportLinks() {
  // Connect to MongoDB
  await mongoose.connect(process.env.MONGODB_URI);
  console.log('Connected to MongoDB');

  // Create Discord client
  const client = new Client({ intents: [GatewayIntentBits.Guilds] });
  await client.login(process.env.DISCORD_TOKEN);
  console.log('Logged in to Discord');

  // Get guild
  const guild = client.guilds.cache.get(process.env.GUILD_ID);
  if (!guild) {
    console.error('Guild not found');
    process.exit(1);
  }

  // Fetch roles to ensure cache
  await guild.roles.fetch();
  console.log('Fetched roles');

  // Fetch channels to ensure cache
  await guild.channels.fetch();
  console.log('Fetched channels');

  // Fetch all RepoLinks
  const links = await RepoLink.find({ guildId: guild.id });
  console.log(`Found ${links.length} repo links`);

  // Prepare data
  const data = [];
  for (const link of links) {
    const channel = guild.channels.cache.get(link.channelId);
    const channelName = channel ? channel.name : 'Unknown Channel';
    const categoryName = channel?.parent?.name || 'No Category';

    // Convert role IDs to role names and sanitize
    const roleNames = link.mentionRoles.map(roleId => {
      const role = guild.roles.cache.get(roleId);
      const roleName = role ? role.name : `Unknown Role (${roleId})`;
      // Remove all Unicode characters above U+FFFF (emojis, symbols, etc.)
      return roleName.replace(/[\u{10000}-\u{10FFFF}]/gu, '').trim();
    });

    data.push({
      RepoName: link.repoName.length > 30 ? link.repoName.substring(0, 27) + '...' : link.repoName,
      ChannelName: channelName.length > 20 ? channelName.substring(0, 17) + '...' : channelName,
      CategoryName: categoryName.length > 15 ? categoryName.substring(0, 12) + '...' : categoryName,
      MentionRoles: roleNames.join(', ').length > 40 ? roleNames.join(', ').substring(0, 37) + '...' : roleNames.join(', '),
      LastChecked: link.lastChecked ? link.lastChecked.toLocaleDateString() : 'Never'
    });
  }

  // Write to CSV
  const csvHeader = 'RepoName,ChannelName,CategoryName,MentionRoles,LastChecked\n';
  const csvRows = data.map(row =>
    `"${row.RepoName}","${row.ChannelName}","${row.CategoryName}","${row.MentionRoles}","${row.LastChecked}"`
  ).join('\n');
  const csvContent = csvHeader + csvRows;

  const outputPath = path.join(__dirname, 'repo_links_export.csv');
  fs.writeFileSync(outputPath, csvContent);
  console.log(`Exported to ${outputPath}`);

  // Close connections
  await client.destroy();
  await mongoose.disconnect();
}

exportLinks().catch(console.error);