import { config } from "dotenv";
config({ path: ".env.local" });
import pg from "pg";

const { Pool } = pg;

const TUXEDO = "64294306-5f42-463d-a5e8-2ad6c81a96de";

async function main() {
  const pool = new Pool({ connectionString: process.env.DATABASE_URL });

  try {
    // brand_settings
    const bs = await pool.query(
      `INSERT INTO brand_settings (brand_id, legal_business_name, phone, email, logo_url, tagline, from_email)
       VALUES ($1, $2, $3, $4, $5, $6, $7)
       ON CONFLICT (brand_id) DO UPDATE SET legal_business_name = EXCLUDED.legal_business_name
       RETURNING brand_id, legal_business_name`,
      [TUXEDO, "Tuxedo Corn LLC", "970-555-0100", "info@tuxedocorn.com",
       "/brand-logos/64294306-5f42-463d-a5e8-2ad6c81a96de/logo.png",
       "Farm-Fresh Sweet Corn, Delivered", "orders@tuxedocorn.com"]
    );
    console.log("brand_settings:", bs.rows[0]);

    // wholesale_settings
    const ws = await pool.query(
      `INSERT INTO wholesale_settings (brand_id, require_approval, pickup_location, fob_location, from_email)
       VALUES ($1, true, $2, $3, $4)
       ON CONFLICT (brand_id) DO UPDATE SET pickup_location = EXCLUDED.pickup_location
       RETURNING brand_id, pickup_location`,
      [TUXEDO, "59751 David Road, Olathe, CO 81425", "FOB Olathe, CO", "orders@tuxedocorn.com"]
    );
    console.log("wholesale_settings:", ws.rows[0]);

    console.log("\nDone!");
  } finally {
    await pool.end();
  }
}

main().catch((e) => { console.error(e.message); process.exit(1); });