/**
* User Data Generator (5000 Accounts)
* Usage: node seed_users.js > users_seed.sql
*/

const crypto = require('crypto'); // Built-in Node module

// --- Configuration ---
const TARGET_COUNT = 5000;
const DOMAINS = ['gmail.com', 'outlook.com', 'yahoo.com', 'petsocial.app'];
const COUNTRIES = ['USA', 'Canada', 'UK', 'Germany', 'France', 'Japan', 'Australia', 'Brazil', 'India'];

const FIRST_NAMES = [
"Emma", "Liam", "Olivia", "Noah", "Ava", "Oliver", "Isabella", "Elijah", "Sophia", "Lucas",
"Mia", "Mason", "Charlotte", "Logan", "Amelia", "Ethan", "Harper", "Aiden", "Evelyn", "Jackson"
];

const LAST_NAMES = [
"Smith", "Johnson", "Williams", "Brown", "Jones", "Garcia", "Miller", "Davis", "Rodriguez", "Martinez",
"Hernandez", "Lopez", "Gonzalez", "Wilson", "Anderson", "Thomas", "Taylor", "Moore", "Jackson", "Martin"
];

// --- Helpers ---
const getRandom = (arr) => arr[Math.floor(Math.random() * arr.length)];

const generatePhone = () => {
// Generates format: +XX XXX-XXX-XXXX
const countryCode = Math.floor(Math.random() * 90) + 10;
const area = Math.floor(Math.random() * 900) + 100;
const exchange = Math.floor(Math.random() * 900) + 100;
const sub = Math.floor(Math.random() * 9000) + 1000;
return `+${countryCode} ${area}-${exchange}-${sub}`;
};

// --- Main Generator ---
console.log(`-- Generating ${TARGET_COUNT} users for PetSocial`);
console.log(`INSERT INTO users (id, email, password_hash, display_name, first_name, last_name, phone_number, country) VALUES`);

const usedEmails = new Set();

for (let i = 0; i < TARGET_COUNT; i++) {
// 1. ID
const id = crypto.randomUUID();

// 2. Names
const fName = getRandom(FIRST_NAMES);
const lName = getRandom(LAST_NAMES);
const fullName = `${fName} ${lName}`;

// 3. Email (Ensure uniqueness)
let emailBase = `${fName.toLowerCase()}.${lName.toLowerCase()}`;
let email = `${emailBase}@${getRandom(DOMAINS)}`;
let counter = 1;
while (usedEmails.has(email)) {
email = `${emailBase}${counter}@${getRandom(DOMAINS)}`;
counter++;
}
usedEmails.add(email);

// 4. Other details
const phone = generatePhone();
const country = getRandom(COUNTRIES);
const passHash = '$2b$10$abcdefg...placeholder_hash'; // Placeholder for bcrypt hash

// 5. Output SQL Value Tuple
const isLast = i === TARGET_COUNT - 1;
const terminator = isLast ? ';' : ',';

console.log(`('${id}', '${email}', '${passHash}', '${fullName}', '${fName}', '${lName}', '${phone}', '${country}')${terminator}`);
}

console.log(`-- Done. Generated ${TARGET_COUNT} accounts.`);

Become a contributor