import fs from "fs";
import dotenv from "dotenv";
import pool from "../src/db_connection";

dotenv.config();

if (process.env.NODE_ENV !== "production") {
  try {
    const seedQuery = fs.readFileSync("db/seeding.sql", { encoding: "utf8" });
    pool.query(seedQuery, async (err, res) => {
      console.log("Errors:", err);
      console.log("Results:", res);
      console.log("Seeding completed!");
      await pool.end();
    });
  } catch (err) {
    console.error("Seeding error!!!!!");
    console.error(err);
  }
}