const express = require('express')
const bodyParser = require('body-parser')
const morgan = require('morgan')
const fs = require('fs')
const render = require('./modules/render.js')
const Error = require('./services/ErrorService.js')
const mySQL = require('mysql');

const CQueue = require('./modules/Queue.js')
const queue = new CQueue()

let data;

const app = express()

const base = mySQL.createConnection({
    host: "localhost",
    user: "root",
    password: "",
    database: "prerender"
})

base.connect(function(err) {
    if (err) throw err;
    console.log("Connected!");

    const sql = "SELECT loc, slug FROM sitemap"

    base.query(sql, function(err, result){
        if(err) throw err;

        // Testing
        // data = result.slice(0, );
        // setTimeout(letsRender, 1000, data, 0)

        // Prod
        setTimeout(letsRender, 15000, result, 0)

    })
});

function letsRender(data, iteration){

    if(data.length <= iteration){
        console.log("Koniec !");
        return 0;
    }

    render(
        data[iteration].loc,
        './app/Resources/views/rendered/' + data[iteration].slug + '.html'
    );

    iteration++;
    setTimeout(letsRender, 1000, data, iteration)
}