src/db.js

const { createClient } = require('@supabase/supabase-js');

let supabaseClient = null;
let isConnected = false;

function connect() {
  const url = process.env.SUPABASE_URL;
  const key = process.env.SUPABASE_SERVICE_ROLE_KEY;
  
  if (!url || !key) {
    console.log('⚠️  SUPABASE_URL or SUPABASE_SERVICE_ROLE_KEY not set — history features disabled (live rates still work)');
    return false;
  }
  
  try {
    supabaseClient = createClient(url, key);
    isConnected = true;
    console.log('✅ Supabase connected');
    return true;
  } catch (err) {
    console.error('❌ Supabase connection error:', err.message);
    return false;
  }
}

function getIsConnected() {
  return isConnected;
}

function getClient() {
  return supabaseClient;
}

module.exports = { connect, getIsConnected, getClient };