seedDatabase.js

const mongoose = require("mongoose");
require("dotenv").config();

// Import models
const FunctionalGroup = require("./models/functionalGroup");
const AminoAcid = require("./models/aminoAcid");

// Sample data for Functional Groups
const functionalGroupsData = [
    {
        name: "Alcohol",
        use: "Found in beverages, solvents, and antiseptics",
        example: "Ethanol (C₂H₅OH)"
    },
    {
        name: "Aldehyde",
        use: "Used in perfumes, flavoring agents, and preservatives",
        example: "Formaldehyde (HCHO)"
    },
    {
        name: "Ketone",
        use: "Used as solvents and in polymer production",
        example: "Acetone (CH₃COCH₃)"
    },
    {
        name: "Carboxylic_acid",
        use: "Found in vinegar, citrus fruits, and used in food preservation",
        example: "Acetic acid (CH₃COOH)"
    },
    {
        name: "Ester",
        use: "Used in fragrances, flavoring, and plastics",
        example: "Ethyl acetate (CH₃COOC₂H₅)"
    },
    {
        name: "Amine",
        use: "Found in amino acids, proteins, and pharmaceuticals",
        example: "Methylamine (CH₃NH₂)"
    },
    {
        name: "Amide",
        use: "Found in proteins and used in pharmaceuticals",
        example: "Acetamide (CH₃CONH₂)"
    },
    {
        name: "Ether",
        use: "Used as solvents and anesthetics",
        example: "Diethyl ether (C₂H₅OC₂H₅)"
    }
];

// Sample data for Amino Acids
const aminoAcidsData = [
    {
        name: "Alanine",
        symbol: "Ala",
        code: "A",
        group: "Nonpolar, aliphatic"
    },
    {
        name: "Glycine",
        symbol: "Gly",
        code: "G",
        group: "Nonpolar, aliphatic"
    },
    {
        name: "Valine",
        symbol: "Val",
        code: "V",
        group: "Nonpolar, aliphatic"
    },
    {
        name: "Leucine",
        symbol: "Leu",
        code: "L",
        group: "Nonpolar, aliphatic"
    },
    {
        name: "Isoleucine",
        symbol: "Ile",
        code: "I",
        group: "Nonpolar, aliphatic"
    },
    {
        name: "Methionine",
        symbol: "Met",
        code: "M",
        group: "Nonpolar, aliphatic"
    },
    {
        name: "Phenylalanine",
        symbol: "Phe",
        code: "F",
        group: "Aromatic"
    },
    {
        name: "Tryptophan",
        symbol: "Trp",
        code: "W",
        group: "Aromatic"
    },
    {
        name: "Tyrosine",
        symbol: "Tyr",
        code: "Y",
        group: "Aromatic"
    },
    {
        name: "Serine",
        symbol: "Ser",
        code: "S",
        group: "Polar, uncharged"
    },
    {
        name: "Threonine",
        symbol: "Thr",
        code: "T",
        group: "Polar, uncharged"
    },
    {
        name: "Cysteine",
        symbol: "Cys",
        code: "C",
        group: "Polar, uncharged"
    },
    {
        name: "Asparagine",
        symbol: "Asn",
        code: "N",
        group: "Polar, uncharged"
    },
    {
        name: "Glutamine",
        symbol: "Gln",
        code: "Q",
        group: "Polar, uncharged"
    },
    {
        name: "Lysine",
        symbol: "Lys",
        code: "K",
        group: "Positively charged"
    },
    {
        name: "Arginine",
        symbol: "Arg",
        code: "R",
        group: "Positively charged"
    },
    {
        name: "Histidine",
        symbol: "His",
        code: "H",
        group: "Positively charged"
    },
    {
        name: "Aspartate",
        symbol: "Asp",
        code: "D",
        group: "Negatively charged"
    },
    {
        name: "Glutamate",
        symbol: "Glu",
        code: "E",
        group: "Negatively charged"
    },
    {
        name: "Proline",
        symbol: "Pro",
        code: "P",
        group: "Cyclic"
    }
];

async function seedDatabase() {
    try {
        // Connect to MongoDB
        await mongoose.connect(process.env.DB_CONNECTION, {
            useUnifiedTopology: true,
            useNewUrlParser: true,
        });
        console.log("✅ Connected to MongoDB Atlas");

        // Clear existing data
        await FunctionalGroup.deleteMany({});
        await AminoAcid.deleteMany({});
        console.log("🗑️  Cleared existing data");

        // Insert functional groups
        await FunctionalGroup.insertMany(functionalGroupsData);
        console.log(`✅ Added ${functionalGroupsData.length} functional groups`);

        // Insert amino acids
        await AminoAcid.insertMany(aminoAcidsData);
        console.log(`✅ Added ${aminoAcidsData.length} amino acids`);

        console.log("\n🎉 Database seeded successfully!");
        console.log("\nYou can now use the flashcard app with real data!");

        process.exit(0);
    } catch (error) {
        console.error("❌ Error seeding database:", error);
        process.exit(1);
    }
}

seedDatabase();