purrform-backend / src / scripts / populateCreditSystemTraders.ts

import fs from 'node:fs/promises';

// lib
import supabase from '../lib/supabase';

interface TraderJson {
    bc_customer_id: number;
    first_name: string;
    last_name: string;
    email: string;
    company: string;
    eligible_for_credit: boolean;
    credit_amount: number;
}

export default async function populateCreditSystemTraders(): Promise<boolean> {
    console.log('Populating credit system traders...');

    try {
        const traders = await fs.readFile(
            './data/trade-customers-for-credit-system.json',
            'utf8'
        );

        const tradersData = JSON.parse(traders) as TraderJson[];

        for (const trader of tradersData) {
            if (!trader.eligible_for_credit) {
                console.log(
                    `Skipping trader ${trader.first_name} ${trader.last_name} as they are not eligible for credit.`
                );
                continue;
            }

            const {
                bc_customer_id,
                first_name,
                last_name,
                email,
                company,
                credit_amount,
            } = trader;

            const result = await supabase.from('credit_system_traders').insert([
                {
                    bc_customer_id,
                    bc_customer_first_name: first_name,
                    bc_customer_last_name: last_name,
                    bc_customer_email: email,
                    bc_customer_company: company,
                    credit_ceiling: credit_amount,
                    current_balance: credit_amount,
                },
            ]);

            if (result.error) {
                console.error(
                    `Error adding trader ${first_name} ${last_name}: ${result.error.message}`
                );
            }
        }

        console.log('Credit system traders populated!');
        return true;
    } catch (error) {
        console.error(error);
        return false;
    }
}