/*
 * Getting Started
 * $ yarn add mysql faker moment
 * $ npm i -S mysql faker moment
 * $ node index.js
 */

const mysql = require('mysql')
const faker = require('faker')
const moment = require('moment')

// Connection database
const connection = mysql.createConnection({
  host: '127.0.0.1',
  user: 'root',
  password: 'root',
  database: 'mydb'
})

// Conneting to mysql
connection.connect((err, args) => {
  if (err) console.log(err)
  console.log('Connected!')
})

const debutDate = moment(faker.date.recent()).format('YYYY/MM/DD')

// Query for create artists
const queryCreateArtistas = `
INSERT INTO artistas(nombre, debut, valoracion, bio)
VALUES("${faker.name.findName()}", "${debutDate}", ${faker.random.number(10)}, "${faker.lorem.words(50)}")
`

// Query for create genres
const queryCreateGeneros = (i, productName) => `
  INSERT INTO generos(idgeneros, nombre)
  VALUES ("${productName}")
`

const queryCreateCanciones = (titulo, anio, duracion, url) => `
  INSERT INTO canciones(titulo, anio, duracion, formato, url, artistas_idartistas, generos_idgeneros)
  VALUES(
    "${titulo}",
    "${anio}",
    "${duracion}",
    "mp3",
    "${url}",
    ${faker.random.number({ min: 1, max: 300 })},
    ${faker.random.number({ min: 1, max: 300 })}
  )
`

// Logic
for (let i = 1; i <= 300; i++) {
  connection.query(queryCreateCanciones(faker.company.companyName(), faker.random.number({ min: 1920, max: 2018 }), "3:00", faker.internet.url()), (err, results, fields) => {
    if (err) console.log(err)
    console.log(results)
  })
}

// Closing connection
connection.end()