import * as dotenv from 'dotenv';
import { fetchDataFromTable } from './db/supabaseHelper';

dotenv.config();

export const config = {
  BOT_TOKEN: process.env.BOT_TOKEN || '',
  API_ID: parseInt(process.env.API_ID || ''),
  API_HASH: process.env.API_HASH || '',
  PHONE_NUMBER: process.env.PHONE_NUMBER || '',
  STRING_SESSION: process.env.STRING_SESSION || '',
};

export const PORT = process.env.PORT || 7860;

// Default values (will be overridden by DB values when loaded)
export let COMMANDS: Record<string, string> = {
  GO: ".",
};

export let MESSAGES: Record<string, string> = {
  FORWARD_SUCCESS: "أتفضل",
};

// Function to load commands and messages from the database
export const loadCommandsAndMessages = async () => {
  try {
    const commands = await fetchDataFromTable('commands', 1000,0);
    const messages = await fetchDataFromTable('messages', 1000,0);
    
    // Reset COMMANDS object
    COMMANDS = {};
    
    // Populate COMMANDS
    commands.forEach((cmd: any) => {
      COMMANDS[cmd.key] = cmd.key;
    });
    
    // Reset MESSAGES object
    MESSAGES = {};
    
    // Populate MESSAGES
    messages.forEach((msg: any) => {
      MESSAGES[msg.key] = msg.value;
    });
    
    console.log('Commands and messages loaded from database');
  } catch (error) {
    console.error('Error loading commands and messages:', error);
  }
};

// Load commands and messages initially
// loadCommandsAndMessages();