const axios = require("axios");
const mysql = require("mysql");

const BASE_DELAY_MS = 2000;
const connection = mysql.createConnection({
  host: "localhost",
  user: "root",
  password: "0december",
  database: "movies"
});

connection.connect();

connection.query("delete from movies.directorlist");
connection.query("delete from movies.moviesnow");
connection.query("delete from movies.SuperTable");

axios
  .get(
    "https://api.themoviedb.org/3/movie/now_playing?api_key=bbb0e77b94b09193e6f32d5fac7a3b9c&region=GR" //calls the now playing info
  )
  .then(response => {
    for (page = 1; page <= response.data.total_pages; page++) {
      paginatorFunc(page); //for every page in the now_playing calls paginator
    }
  })
  .catch(error => {
    console.log(error);
  });

paginatorFunc = page => {
  axios
    .get(
      "https://api.themoviedb.org/3/movie/now_playing?api_key=bbb0e77b94b09193e6f32d5fac7a3b9c&region=GR&page=" +
        page
    )
    .then(response => {
      crewImdbFinder(response.data); //for every page we are in, call crewImdb finder
    })
    .catch(error => {
      console.log(error);
    });
};

//finds movie and crew info
crewImdbFinder = page => {
  page.results.map((result, idx) => {
    function resolver(resolve) {
      function executeDelayedRequest() {
        axios
          .get(
            "https://api.themoviedb.org/3/movie/" +
              result.id +
              "?api_key=bbb0e77b94b09193e6f32d5fac7a3b9c&append_to_response=credits"
          )
          .then(resolve);
      }

      setTimeout(executeDelayedRequest, BASE_DELAY_MS * idx);
    }

    new Promise(resolver)
      .then(response => {
        response.data.credits.crew.map(member => {
          if (member.job === "Director") {
            directorHandler(member.id, response.data.title);
          }
        });
        connection.query("INSERT INTO moviesnow VALUES (?, ?, ?)", [
          response.data.title,
          response.data.overview,
          response.data.original_title
        ]);
      })
      .catch(error => {
        console.log(error);
      });
  });
};
directorHandler = (directorId, title) => {
  axios
    .get(
      "https://api.themoviedb.org/3/person/" +
        directorId +
        "?api_key=bbb0e77b94b09193e6f32d5fac7a3b9c"
    )
    .then(response => {
      connection.query("INSERT INTO directorlist VALUES ( ?, ?, ?)", [
        response.data.name,
        title,
        "https://www.imdb.com/name/" + response.data.imdb_id
      ]);
    })
    .catch(error => {
      console.log(error);
    });
};