const { Seeder } = require('tiny-seeder');
const { faker } = require('@faker-js/faker');
const { v4: UUID } = require('uuid');

const tables = [
  // First table
  {
    name: 'company',
    rows: 40,
    uniques: ['suffix', 'name'],
    columns: {
      suffix: faker.company.companySuffix,
      name: faker.company.companyName,
      description: faker.company.catchPhrase,
      site: faker.internet.url,
    },
  },

  // Second table with first table relation
  {
    name: 'product',
    rows: 500,
    columns: {
      name: faker.commerce.productName,
      description: faker.commerce.productDescription,
      department: faker.commerce.department,
      image: faker.image.imageUrl,
      color: { type: faker.commerce.color, nullable: true },
      price: faker.commerce.price,
      company_id: { to: 'company' },
    },
  },

  // Last table
  {
    name: 'client',
    rows: 80,
    columns: {
      uuid: { primary: true, type: UUID },
      username: faker.internet.userName,
      email: { type: faker.internet.email, unique: true },
      password: faker.internet.password,
    },
  },
];

const seeder = new Seeder(tables, { directory: './data', truncate: true });

seeder.generate();